RelationalDBDesign RelationalDBDesign


Manual | Automatic Archiving   «Prev  Next»
Lesson 1

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
  1. manual and
  2. automatic
archiving of redo log files. By the end of this lesson you should be familiar with the following topics:
  1. Normal ARCH processing
  2. Manual archiving of redo log files
  3. Automatic archive log file options
  4. Obtaining archive log information
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.
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.

V$INSTANCE

By querying the V$INSTANCE view, you can determine the status of the archiver process. Run the following query:

SELECT archiver
FROM V$INSTANCE
ARCHIVE
-------
STARTED
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.