Scribd
Upload
3 views11 pages

Dba 67

The document provides an introduction to Archive and NoArchive Redo Log Files in Oracle Database administration. It explains the process of archiving redo log files, the importance of ARCHIVELOG mode, and the usage of archived redo logs for database recovery and maintenance. Additionally, it covers the transition between enabled and disabled states for archived redo logs and the role of the archiver process in managing these logs.

Uploaded by

rf539goodpako
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views11 pages

Dba 67

The document provides an introduction to Archive and NoArchive Redo Log Files in Oracle Database administration. It explains the process of archiving redo log files, the importance of ARCHIVELOG mode, and the usage of archived redo logs for database recovery and maintenance. Additionally, it covers the transition between enabled and disabled states for archived redo logs and the role of the archiver process in managing these logs.

Uploaded by

rf539goodpako
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Introduction to Database Administration

Archive & NoArchive Redo


Log Files
Archive and NoArchive Redo Log Files
Archive & NoArchive of Redo Log
Files

• Archived Redo Log


• Archived Redo Log Usage
• Archived Redo Log Mode
• Archived Redo Log Disabled to
Enabled
• Archived Redo Log Enabled to
Disabled
• Redo Logs Use in ARCHIVELOG Mode
Archive and NoArchive Redo Log Files
Archived Redo Log

• Oracle Database lets you save filled


groups of redo log files to one or
more offline destinations, known
collectively as the archived redo log.
• The process of turning redo log files
into archived redo log files is called
archiving. This process is only
possible if the database is running in
ARCHIVELOG mode.
• You can choose automatic or manual
archiving
Archive and NoArchive Redo Log Files
Archived Redo Log

• An archived redo log file is a copy of


one of the filled members of a redo
log group with log sequence number.
• For example, if you are multiplexing
your redo log, and if group 1 contains
identical member files a_log1and
b_log1, then the archiver process
(ARCn) will archive one of these
member files.
Archive and NoArchive Redo Log Files
Archived Redo Log

• Should a_log1 become corrupted,


then ARCn can still archive the
identical b_log1. The archived redo
log contains a copy of every group
created since you enabled archiving.
Archive and NoArchive Redo Log Files
Archived Redo Log

• When the database is running in


ARCHIVELOG mode, LGWR cannot
reuse and hence overwrite a redo log
group until it has been archived.
• The background process RCn
automates archiving operations
when automatic archiving is enabled.
The database starts multiple archiver
processes as needed to ensure that
the archiving of filled redo logs does
not fall behind.
Archive and NoArchive Redo Log Files
Archived Redo Log Usage

You can use archived redo logs to:


• Recover a database
• Update a standby database
• Get information about the history of
a database using the LogMiner utility
Archive and NoArchive Redo Log Files
Archived Redo Log Mode

Display DB Archive Mode Disable or Enable


Login with sys / as sysdba.
We will discuss archival files backup later
Archive and NoArchive Redo Log Files
Archived Redo Log Disabled to Enabled

Using SQL sys to convert


Archivelog Disabled to
Enabled & Vice Versa

During recovery Oracle


ask you to use
Alter database open
instead of startup open
Archive and NoArchive Redo Log Files
Archived Redo Log Enabled to Disabled
Archive and NoArchive Redo Log Files
Redo Logs Use in ARCHIVELOG Mode

You might also like