Physical Standby Switchover issue

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 4 Sep 2005 14:47:10 -0400
Message-ID: <f09dd6280509041147234b8cc7@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Sep 04 2005 - 13:49:08 CDT