Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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'

Comments

Cac47
I check Archivelog Destinations and Everything it's OK!!!

Doesn anyone face this iisue during a switchover ?

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'

Thxs for your Help.
Bests
Cac47
Sorry to Bother you guys,

The Standby Archivelogs were Missing in the Standby Site
After I've recreate them I could Finally do the switchover from Primary Site
Just An Hic, I had to do an "Swicth Log file Fisrt"
SQL> alter system switch logfile;
System altered.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
Database altered.
SQL> SHUTDOWN NORMAL;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> STARTUP NOMOUNT;
ORACLE instance started.
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
Database altered.
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;

Now Is My Secondary Site that's is Hanging

When I run step 7 copy from Oracle Doc I get Error Message :

********* Step 7 **************
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY DATABASE;
Shut down and restart the new primary database instance.

************************************

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY DATABASE;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY DATABASE
*
ERROR at line 1:
ORA-00905: missing keyword


What a f... crap
Robert Geier
select SWITCHOVER_STATUS from v$database;

Try :-

alter database commit to switchover to PRIMARY with session shutdown;

When you switchover, always tail the alert log on both sides to watch what is happening. (e.g look for failed archives, recovery, end-of-redo etc)
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2010
Added on Dec 8 2009
#general-database-discussions
3 comments
737 views