Saturday, March 3, 2012

How to work around standby database in case of missing archive log file

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to work around standby database in case of missing archive log file


Symptoms:
Missing archive log file from production and from standby before apply


Solution:



SQL> alter database recover managed standby database cancel;

2. Shutdown the Standby Database:

SQL> shutdown immediate;

3. Connect to the Primary Database as SYS:

SQL> connect sys/@ as sysdba

4. Create a new Physical Standby Controlfile from the Primary:

SQL> alter database create standby controlfile as '';

5. Copy the new created Standby Controlfile to the Standby Database using OS-Tools (eg. cp or ftp) and replace the current Standby Controlfile with the new created one.

6. Mount the Standby Database with the new Standby Controlfile:

SQL> startup mount
10. Start Managed Recovery again:

SQL> alter database recover managed standby database disconnect;

References:

Note 232649.1 Data Guard Gap Detection and Resolution
Refer to Note.459411.1 Steps to recreate a Physical Standby Controlfile .
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: