| After the switchover... [message #241436] |
Tue, 29 May 2007 10:00 |
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
|
Senior Member |
|
|
I performed a Switchover (DG 9.2, Physical Standby DB), and it seems to have worked flawlessly except that the former Primary DB is still trying to send redo data across. To fix this, I set log_archive_dest_state_2=DEFER. I didn't see that in the Oracle documentation, and wonder if it is required, or if I missed a step in the switchover. Switchover, basically, was:
Standby Site:
> Cancelled recovery mode
Primary Site:
> Switched Logfile
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
> Restarted in Managed Standby mode.
Standby Site:
> Restarted recovery mode.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
> Restarted in Open mode as new Primary Database.
I DID a log switch (alter system switch logfile;) on the Standby site (instead of the documented "ALTER SYSTEM ARCHIVE LOG CURRENT;". Seemed to work.
M
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
