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

Francisco Amores

Hi,

so you mean the field is not refreshed in the data source?

1 person found this helpful
AbanoubZaki

Yes

Moatasem Shebl

Hello Abanoub,

Try to create a new saved search in net suite "copy from the old one included the new column" and then re-initialization

Thank You

1 person found this helpful
AbanoubZaki

That's what I have done already, and the new columns were not synchronized.

But I think the Instances was hanging

Thnaks

1 - 4
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
736 views