In Oracle : Oracle Database ARCHIVELOG mode

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Maintenance Tasks

-> Oracle Database ARCHIVELOG mode

 

 Oracle Database ARCHIVELOG mode

 

 

Here are the main topics for this article:

Database ARCHIVELOG mode: Overview

 

An Oracle database could be in ARCHIVELOG or NON ARCHIVELOG mode. When the database is in ARCHIVELOG mode one or more ARC process(es)  are taking backups of the redo log files when the redo logs are full or switched. That assure that all the database operations are kept in 2 places (in data files and in archive log files). Having the database in ARCHIVELOG mode assure us that the data will not be lost even if the original data (from datafiles) will become inaccessible or will be deleted accidentally. 

 

 

Is my database in ARCHIVELOG mode ?

 

To see if the database is in archivelog mode the following command could be used:

 


select NAME, LOG_MODE, ARCHIVELOG_CHANGE# from v$database;

 

Oracle Database ARCHIVELOG mode

 

 

How could I enable the ARCHIVELOG mode ?

 

1)  assure that we have the following parameters in init.ora:

      log_archive_dest_1='location=C:\OHome_9i\ARC'
      log_archive_start=TRUE                  -->obsolete for 10g and higher.

 

2)  startup mount

3)  alter database archivelog;  (enable automatic archiving)

     alter database archivelog MANUAL;   (ALTER SYSTEM ARCHIVE LOG ALL; must be run to archive the log files) 

 

 

How could I disable the ARCHIVELOG mode ?

 

1)  startup mount

2)  alter database noarchivelog; 

 

 

Automatic/ Manual Archiving

 

ARCHIVE LOG LIST;       ->  Show the Status of Automatic Archiving.
ARCHIVE LOG START;   ->  Start Automatic Archiving.
ARCHIVE LOG STOP;     ->  Stop Automatic Archiving.

 

 

Views used in managing database ARCHIVELOG mode

 

V$ARCHIVE_DEST      ->  Show the places where the archive logs are shipped. 

V$ARCHIVED_LOG     ->  Show the history of archived log files 

V$ARCHIVE_PROCESSES  ->  Show information about the current archiving process

 

 

In-Oracle.com  -> Oracle DBA -> Oracle Maintenance Tasks

-> Oracle Database ARCHIVELOG mode

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.