RE: RMAN & Oracle Business Suite for Oracle

From: Valuthur, Srikanth <SValuthur_at_erac.com>
Date: Fri, 31 Aug 2001 09:11:20 -0700
Message-ID: <F001.0037F8D4.20010831091833@fatcity.com>

WE have the same suite what you have mentioned. We are backing up around 60 databases incremental and around 20 fulls everyday using RMAN. We do have some occassional problems, But we are able to fix it.

I would suggest metalink would be first source for you to start. They have put some excellent documents about setting up RMAN and getting around issues with RMAN. That would be helpful. Once you start, Any issues you face we can help you get thru(Presuming we know that error)

HTH Srikanth

-----Original Message-----
Sent: Friday, August 31, 2001 12:04 PM
To: Multiple recipients of list ORACLE-L

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).
--

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

Author: Valuthur, Srikanth
INET: SValuthur_at_erac.com

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