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!

how to solve sequence gaps on standby

#bucketlistNov 23 2012 — edited Dec 4 2012

Hi Experts,

I really need to hear your thoughts.

I have 11g databases for both production and standby database. FYI production is setup with RAC. For some reason, the standby database lost connection for 20 days. So we have sequence gaps.

What I did copied the archived logs from the production to standby since its not deleted. But I just notice that there is file_name convert associated with archivelogs. I already registered the archivelogs but with the wrong naming convention. It is correct to transfer archivelogs from prod to standby?

And the dg is working fine now, it's transporting the recent archivelogs but its not applying. How to applied those logs?

I would be very grateful of your response.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2013

Added on Nov 23 2012

#data-guard, #performance-availability

5 comments

1,439 views