Need help. Standby database question. Using RMAN

[Sushil Singh_1]

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

[Steven E. Protter]

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

[Stan_17]

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

[doug mielke]

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.

[Henrik Palmqvist]

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.