Home » Server Options » Data Guard » standard edition data guard
standard edition data guard [message #196229] Wed, 04 October 2006 10:12
alanm
Messages: 284
Registered: March 2005
Senior Member

All,
I have a 9i standard edition production database and a 9i standard edition standby database. logs are shipped via a cron job and applied to the standby database.

I have no experience of failing over a standard edition database. My guess is as follows

1 - primary fails
2 - issue ALTER DATABASE ACTIVATE STANDBY DATABASE on the standby database
3 - shutdown the standby and take an rman cold backup
4 - start the new primary and create a standby controlfile
5 - shutdown the new primary database
6 - copy the created standby control file to the existing control file locations and rename
7 - restore the rman backup onto the old primary
8 - start the database mounted on the standby server and issue RECOVER STANDBY DATABASE;
9 - ensure logs are being shipped etc

Is any one able to confirm this for me.

regards

Alan
Previous Topic: standby and auto start
Next Topic: oracle broker notes
Goto Forum:
  


Current Time: Thu Mar 28 18:24:13 CDT 2024