Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Srinivas.

Asked: July 25, 2016 - 4:24 am UTC

Last updated: July 27, 2016 - 1:32 pm UTC

Version: 11.2.0.1.0

Viewed 1000+ times

You Asked

I understand that Recover Catalog Manager does has the metadata of the registered database, if the registered database has been recovered by doing restlogs(once we reset the logs we cannot use the old backups using the control file of the database as due to incarnation the control files scn will be reset ) can we still be able to use the old backups by using recover catalog please suggest.

and Connor said...

You *can* still use the older backups, but that would be to take the database back to a previous incarnation. New backups would be associated with the new incarnation

From the doc:

http://docs.oracle.com/database/121/BRADV/rcmcatdb.htm

"If you open the database with the RESETLOGS option, then a new database incarnation record is automatically created in the recovery catalog. The database also implicitly and automatically issues a RESET DATABASE command, which specifies that this new incarnation of the database is the current incarnation. All subsequent backups and log archiving done by the target database is associated with the new database incarnation."

Notice the term: *subsequent*

Hope this helps.

Rating

  (1 rating)

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

Comments

Srinivas, July 26, 2016 - 2:38 am UTC

Thanks a lot, it really helps but have one more question, in this case is it mandate to take full database backup again after the incarnation or just use the setup as it is ?
Connor McDonald
July 27, 2016 - 1:32 pm UTC

It *is* possible to recover through a resetlogs operations, but it is slightly more involved sequennce of steps. So I would take another backup.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.