Manual and Automatic Archiving Options
Up to this point we have learned to set up a database to facilitate archiving of redo log files.
In this module we will learn to set up a database to provide for both
archiving of redo log files. By the end of this lesson you should be familiar with the following topics:
- manual and
Also included is a brief discussion on the use of standby databases. While the Oracle8 DBA certification exam does not test you on this topic, it is an important consideration when formulating a complete backup and recovery plan. Often the cost to maintain a standby database can be justified by doing an analysis of lost revenue incurred during the recovery of your primary database.
- Manual archiving of redo log files
- Automatic archive log file options
- Obtaining archive log information
The next lesson discusses archiving your redo log files.
The exam does not contain questions pertaining to getting the database in ARCHIVELOG mode, just questions about the differences between ARCHIVELOG
mode and NOARCHIVELOG mode as well as questions about automatic and manual archiving.
By querying the V$INSTANCE view, you can determine the status of the archiver process. Run the following query:
A status of STARTED means that automatic archiving has been enabled for the database and that the ARCn process is running.
If the value is STOPPED, this indicates that either manual archiving or no archiving is being performed.