Ora-19697 standby control file not found in backup set

In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z Some messages recommend contacting Oracle Support Services to report a problem.

Please go here for more information : Oracle Support. What is the cause of ORA from Oracle 11g? Catalog failed because the database id in file header does not match the one in control file. Supply the correct file belonging to this database. Author : Kevin Loney. Author : Jason Price. Here is procedure and solution that solved my problem.

Here is where RMAN threw back errors as follows:. After tough investigation and googling the error, I came across this site that gave me the solution databaseninja. It is interesting that RMAN is not aware of the this backup piece even after catalog the entire location. Based on the suggestion from the site, I decided to catalog individual backup piece from that location as follow. You are commenting using your WordPress. You are commenting using your Google account.

You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Once your database backup is completed successfully, Now copy the above backup on New server with a password file if forget to copy the password file then you need to create a password manually. The Newly configured server must have installed Oracle binary.

Check here how to install Oracle on Linux. After copying the RMAN Backup we need to create a few directories which are required if you want the same directory structure as your production otherwise you can ignore it safely and go with the second method.

After creating the above directories now we start the restoration steps, just follow me. Copy spfile and password file on its real location. After copying above both files now create a pfile using spfile and check all directory structures, if any directory is not available then create it.