| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
