My Oracle Support Banner

Database Recovery Through Resetlogs may not Run Fine with Old Control File Backup (Doc ID 2288838.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


Recovery though resetlogs does not run fine unexpectedly, when using control file backup taken before resetlogs. In following scenario, second recovery action at step 8 does not accept archived log file which is generated after resetlogs.

  1.  Prepare database and take full backup including control files.
  2.  Remove all data files and online redo log files, keep control files and archived log files.
  3.  Restore data files from full backup
  4.  Run incomplete media recovery, and open database with resetlogs.
  5.  Remove all data files, online redo log files, control files and archived log files.
  6.  Restore data files and control files from full backup
  7.  Register all archived log files generated after step 1
  8.  Recover database, Oracle does not suggest archived log file generated after resetlogs at step 4. Explicitly specify archived log file fails with ORA-342

When we fail, we will see following at step 8. <FILE_NAME>.dbf is generated before resetlogs, sequence#3 does not exist, <FILE_NAME>.dbf is generated after open resetlogs.



 This problem does not happen on 10.2


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.