Archive log files missing

Create Standby Control file. Transfer Backup to standby. List Control file location on standby. Replace the controlfile from backup. Mount Standby Database. Catalog backuppiece On Standby. Recover standby. Switch logfile On Primary. Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you.

Ensure that you run it in your test environment before using. Once after deleting the archivelog file from both production and standby database servers, enable the media recovery process in standby database.

From the above we can clearly see that there is an archival gap sequence 27 has not been applied to the standby database. But the archivelogs are moving to the standby database location but not applying. Archivelog with sequence 27 is missing from primary and also from standby database. Due to this there is an archival gap between primary database and standby database. The synchronization between primary database and standby database has been lost. The steps to resync the standby database using an incremental RMAN backup from the primary database are as follows.

You can see the Alert log in which the recovery process is clearly mentioned. From the above check, we can clearly see that both primary and standby databases are in sync. Save my name, email, and website in this browser for the next time I comment. View Results. Hit enter to search or ESC to close. Close Search.

Advantages: This does not require a full rebuild of the standby database and can be a lot more efficient. Normally in DR setup, the archives from primary shipped to standby and applied there. But due to intermittence error or human error, the archives has been deleted from primary. In oracle 12c , We can use the rolling forward method to fix it.

See Full article. Here i have created a setup where archive is missing before it is being applied in the physical standby. RMAN does not know about these files yet; so you must let it know — by a process called cataloging. This error are expected errors.