Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help. Standby database question. Using RMAN

Need help. Standby database question. Using RMAN

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
4 REPLIES
Steven E. Protter
Exalted Contributor

Re: Need help. Standby database question. Using RMAN

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Stan_17
Valued Contributor

Re: Need help. Standby database question. Using RMAN

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
Respected Contributor

Re: Need help. Standby database question. Using RMAN

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

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.