Skip to Main Content
  • Questions
  • Recovering Physical Standby after RESETLOGS on Primary

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Robert.

Asked: December 18, 2015 - 5:33 pm UTC

Last updated: December 19, 2015 - 4:36 am UTC

Version: 11.2.0.3 and 10.2

Viewed 10K+ times! This question is

You Asked

Hello,

We had an issue where we had to restore/recover a production database from the previous backup (actually several database but for simplicity I'm using the singular)

This database has a Data Guard physical standby database associated with it.
The physical standby does NOT have flashback turned on.

After the "open database resetlogs" the archlogs continue to ship to the standby but they are not appyling.
i.e. the sequence# re-started at "1".

One odd thing to me is that the primary shows the same incarnation as the standby
i.e. "list incarnation" on the primary shows the same thing as "list incarnation" of it's associated standby.
... and yet the new archlogs are not applying to the standby.

My question is this:

Is there any way to re-establish my standby database (i.e. so the new archlogs will apply) WITHOUT having to rebuild it from scratch (i.e. a full database copy or backup)?

Thank you!

Robert Wood

and Connor said...

From the docs:

"If the standby has applied redo data past the new resetlogs SCN (past the start of the new branch of redo data) and Flashback Database is not enabled on the standby database"

then the standby database must be recreated.

I think you might be out of luck.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Just what I needed to know

Robert Wood, December 19, 2015 - 12:06 pm UTC

Thank you, Connor.

I spent quite a while searching the internet and the Oracle documentation for the definitive answer for this but couldn't find the definitive quote in the proper context that you gave me.

It did seem there was no way to recover but I wanted to clear up the 1% doubt in my mind before blowing it all away and starting over on the standby.

This time I will be sure to have flashback enabled on the standby since we actually already had the space allocated for it.

Thanks again.

Robert.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.