topic Need help. Standby database question. Using RMAN in Operating System - HP-UX

Need help. Standby database question. Using RMAN

Sushil Singh_1 — Mon, 10 Nov 2003 09:55:19 GMT

HI all,
We have 2 box. One in Jersey and other in California. Both have 11.11 HP and ORacle 8.1.7.4. Due in company policies were have to do the following.

We have to take backup of jersey machine using RMAN and then copy it at night over to California and apply the backup using RMAN. This way it exactly the same.

Question is, can the oracle_sid on jersey and California be different?

Does RMAN cares if the ORACLE_SID are the same or not?

Thanks All

Re: Need help. Standby database question. Using RMAN

Steven E. Protter — Mon, 10 Nov 2003 10:47:39 GMT

Yes the oracle sid can be different.

This is something you will need to test because the restore procedure is different if the instance names are different.

It would be easier for you however to have a copy of the rman respository database in both places and the instance names be the same.

It just makes the scripts easier to automate.

With enough bandwidth you could use oracle replication to keep the data hot and up to date through the wire.

SEP

Re: Need help. Standby database question. Using RMAN

Stan_17 — Mon, 10 Nov 2003 12:43:38 GMT

Sushil,

yes sid's can be different. however i'd would keep them same. As far as dbid is same, there shouldn't be an issue.

-
hth,
Stan

Re: Need help. Standby database question. Using RMAN

doug mielke — Mon, 10 Nov 2003 13:02:44 GMT

Unless the dbase is very small, this method will require significant bandwidth.

The fact that your planning to use rman for a DR solution may be an indication that your organination is offering limited funding, and may not have the bandwidthe required.

Depending on your storage hardware, there may be a 'snapshot' like package that could offer a solution. It's the cheapest way we found to mirror gigs of data over a few meg of bandwidth.

Re: Need help. Standby database question. Using RMAN

Henrik Palmqvist — Tue, 11 Nov 2003 05:31:12 GMT

Hi,

Is the California DB read-only?

If so, you could use built-in functionality (in the oracle database) to keep the California DB in sync with the one in Jersey.
Have a look at "How to Create a Oracle 8i Standby Database" on Metalink, doc id: 70233.1

The main advantages with using Standby Database in Oracle is that the replication is spread out during the day, only changes are replicated and the amount of transactions lost is dependent on how often the log is switched.