RMAN & Oracle Business Suite for Oracle

From: Gene Sais <Gsais_at_co.palm-beach.fl.us>
Date: Fri, 31 Aug 2001 08:54:34 -0700
Message-ID: <F001.0037F7E9.20010831090413@fatcity.com>

OS: AIX 4.3.3 ML8
Oracle: 8.1.7
Legato 6.1

OK, I have avoided RMAN and hot backups for some years now. I have always used my trusty scripts. Having come from the sysadmin side of dba, I prefer backups/restores that I can control. I am leary of depending on RMAN, but I have no choice b/c this 1tb db of blobs is just too big for full backups. I need to do incremental backups using RMAN and Legato's Oracle Business Suite.

Question: Has anyone used the aforementioned products together to do incremental backups? And if so, any quick guide to set up and configuration?

Thanks,
Gene
*Now Forced to use RMAN*

PS. The db is 950gb blobs. I am trying to get the vendor to put the blobs on the filesystem where they belong, but they are a big informix shop and like blobs in the db. I am building a case to remove the blobs. So far I have:

Backup/restore window would shrink, as well as performance degradtion during the backup window.
Db copies (e.g. for dev, test, web, ...) would be more managable.
Oracle upgrades would be more managable. I prefer exp/imp for upgrades. Oracle's migrate utility is never clean. Besides, get a reorg out of an upgrade.

Any other ideas I may have missed?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gene Sais
INET: Gsais_at_co.palm-beach.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Aug 31 2001 - 10:54:34 CDT