Skip to Main Content
Forums

Database Software

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.

Missing archive log files on primary

646135Aug 12 2011 — edited Aug 15 2011
Hi - so what I'm trying to do is to catch the standby DB up with the primary.

What happened.

Primary and standby shutdown.
primary started again but not standby.
conrjob removes archivelogs older than 7 days - didnt have logic to check standby to see if they were applied or not. They werent and were deleted from primary, however were backed up to tape.

I used rman to restrore them to the primary and ran a crosscheck. I would then assume that the Standby would just catch up??
It didnt, even after trying to poke it, restarting redo apply etc..

turns out log_archive_dest_2 is using LGWR not archive log shipping - so am I even in the right ballpark here?
Whats my next step?

I tried registering the archive logs on the primary but got an error - I've read this
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_transport.htm#i1268281
and I think it says I should be registering them on the STBY, is this the case?

Thanks

R

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 12 2011
Added on Aug 12 2011
#data-guard, #dataguard, #performance-availability
5 comments
719 views