Physical Standby Switchover issue

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 4 Sep 2005 14:47:10 -0400

While doing switchover in physical standby database which is operating in 
Maximum Availability mode, I got into this error.
I do have standby logfiles.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
------------------
SESSIONS ACTIVE


SQL> alter database commit to switchover to primary with session shutdown;
alter database commit to switchover to primary with session shutdown
*
ERROR at line 1:
ORA-16139: media recovery required


SQL> recover standby database;
ORA-00279: change 318016 generated at 09/04/2005 13:57:41 needed for thread 
1
ORA-00289: suggestion : /u07/oradata/dgtest/0001S0000000056.ARC
ORA-00280: change 318016 for thread 1 is in sequence #56


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 318016 generated at 09/03/2005 21:06:49 needed for thread 
2
ORA-00289: suggestion : /u07/oradata/dgtest/0002S0000000009.ARC
ORA-00280: change 318016 for thread 2 is in sequence #9


ORA-00328: archived log ends at change 317689, need later change 318016
ORA-00334: archived log: '/u07/oradata/dgtest/0002S0000000009.ARC'

Thanks
Sami

Other related posts: