Re: Physical Standby Switchover issue

Sami

I guess this is still the RAC HA sandbox system you're using for your POC? Did you shutdown all but one instance at both ends? During switchover only one instance per database is allowed to run.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Sun, 2005-09-04 at 14:47 -0400, Sami Seerangan wrote:

> 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