| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Advice on setting up a standby database of an OPS cluster
With oracle SID present in archive file name it could be difficult.
You should have DB_NAME as part of archive file name. This DB_NAME will remain same for all your OPS Instance's database as well as your standby database. Alongwith DB_NAME have thread number also in log_archive_format , so your Log_Archive_format (for all OPS nodes as well as Standby database) should look like
DB_NAME%t%S.ARC
If you have SID as part of archive name then all the SID's of different nodes would be different for all the instance and your standby database will have problem in interpretting the same.
More Ideas are welcome !!
Cheers,
Rajesh
-----Original Message-----
Bryan
Sent: Tuesday, April 08, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
My company is setting up a disaster recovery site for our node OPS cluster. At the disaster recovery site we are setting up a non ops standby database for the cluster.
My question is that,
In the cluster we have 2 sets of archive logs being produced and each set of
archive logs the name contains the oracle sid for the node that produced it.
Will this cause problems with the automated recovery of the standby
database?
Database version 8.1.7.4
O/S HP-UX 11.0
Thank you,
Bryan Rodrigues
Elcom, Inc.
Oracle Database Administrator
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rodrigues, Bryan
INET: BRodrigues_at_elcom.com
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Rajesh_at_ohitelecom.com
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 Tue Apr 08 2003 - 10:23:44 CDT
 |
 |