Home » Server Options » Data Guard » After the switchover...
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



Previous Topic: Oracle 9i Missing Conrtol and Redolog files
Next Topic: Yet another topic -- archiving being done by another process
Goto Forum:
  


Current Time: Sun Nov 23 10:29:17 CST 2014

Total time taken to generate the page: 0.07592 seconds