Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

During SWITCHOVER - 112255 not archived, no available destinations!!!

Cac47Dec 8 2009 — edited Dec 8 2009

dear Gurus,

Yesterday you really help me a lot and I thank you,
I've finally Start Getting into this SWITCHOVER Stuff,

So I've Recreated the Standby, clean and proper, and I follow procedure In Oracle Doc ,
http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/scenarios.htm#1015677
10.3 Switching Over to a Physical Standby Database That Has a Time Lag

I made
Step 1,
Step 2 (kill all Active sessions) and in Step 3
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
*
ERROR at line 1:
ORA-16014: log 2 sequence# 112255 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/u01/oradata/CFMP/rdo/redog2m1.log'
ORA-00312: online log 2 thread 1: '/u02/oradata/CFMP/rdo/redog2m2.log'
ORA-00312: online log 2 thread 1: '/u03/oradata/CFMP/rdo/redog2m3.log'

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2010

Added on Dec 8 2009

#general-database-discussions

3 comments

754 views