How do I restore archive logs?
To restore archived redo logs to a new location:
- Start RMAN and connect to a target database.
- Ensure that the database is mounted or open.
- Perform the following operations within a RUN command: Specify the new location for the restored archived redo logs using SET ARCHIVELOG DESTINATION .
How do I restore missing archive logs from RMAN backup?
Step 1: uncatalog the required archivelogs from RMAN prompt RMAN>CHANGE ARCHIVELOG FROM LOGSEQ=60 UNTIL LOGSEQ=70 UNCATALOG; Once the archivelogs have been successfully uncataloged, you are now able to successfully restore the archive logs to a new location.
How to recover from a missing Archive Log?
Now remove that archivelog with sequence# 27 physically from standby server also. Once after deleting the archivelog file from both production and standby database servers, enable the media recovery process in standby database. Database log mode Archive Mo Automatic archival Enabled
How to recover a missing Archive Log from Oracle SCN?
1 row created. Commit complete. SQL> select * from emp; You can see that we connected to a user “veera”, created a table “emp” and inserted rows in to it. connect to the standby database and check whether the table has been replicated or not.
How to remove archivelog with sequence # 27 from standby database?
Since the media recovery process has been canceled the archivelog will not be applied to the standby database. Now remove that archivelog with sequence# 27 physically from standby server also. Once after deleting the archivelog file from both production and standby database servers, enable the media recovery process in standby database.
What happens when archives are deleted from primary?
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary .But due to intermittence error or human error, the archives has been deleted from primary.