Archive log repository is one of the seldom used and known concepts in Oracle Database.
An Oracle Database can be configured to send archive logs to remote destination without database being present in that site.
To explain
1. Database Instance is running
2. Database Control File is present
3. The CF has to be standby CF (ensure this)
4. Database is in mount state
5. No Datafiles present
If you configure your source database similar to a dataguard configuration, your primary will start sending archive logs to the Archive log repostiory site.
What are the use case?
1. Backup of archive logs on remote site
2. Remote Site can be used for tape backup etc
3. Setup during dataguard setup - the time spent to backup and transfer the archivelogs can be used by sending the logs using the archive log repo.
So when you have your database restored, you will have your archives already there.
For More Information : https://docs.oracle.com/cd/E11882_01/server.112/e41134/log_transport.htm#SBYDB4745
An Oracle Database can be configured to send archive logs to remote destination without database being present in that site.
To explain
1. Database Instance is running
2. Database Control File is present
3. The CF has to be standby CF (ensure this)
4. Database is in mount state
5. No Datafiles present
If you configure your source database similar to a dataguard configuration, your primary will start sending archive logs to the Archive log repostiory site.
What are the use case?
1. Backup of archive logs on remote site
2. Remote Site can be used for tape backup etc
3. Setup during dataguard setup - the time spent to backup and transfer the archivelogs can be used by sending the logs using the archive log repo.
So when you have your database restored, you will have your archives already there.
For More Information : https://docs.oracle.com/cd/E11882_01/server.112/e41134/log_transport.htm#SBYDB4745
No comments:
Write comments