RMAN questions

From: <ryan_oracle_at_cox.net>
Date: Thu, 04 Dec 2003 06:44:37 -0800
Message-ID: <F001.005D8CA3.20031204064437@fatcity.com>

We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types.

Production instances that have both OLAP and OLTP. These must be in archive log mode.
We have staging instances where we do data loads. We do not put these in archive log mode for obvious reasons. We do our backups of these with transportable tablespaces and running dbverify.

We also have 2 locations. One is remote. Its not practical to store our backups from the remote location at our local location or vice versa. So we will need 2 seperate RMAN setups.

I have seen that some people like to use two instances that have RMAN. Many people will just put the RMAN catalog in an existing instance. Is that really a good idea? The idea behind two instances is that they can back each other up. Is that really enough? You can lose both instances, then your backup sets are useless. We have a shared NAS, so each location uses the same set of storage. We do backup to tape as well.

Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan.

--

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

Author: <ryan_oracle_at_cox.net
INET: ryan_oracle_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Dec 04 2003 - 08:44:37 CST