How to set archive mode in RMAN

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

This article applies to:

Overview

This article helps to enable the Archive mode on RMAN. It also helps to know if the mode is already active.

Create a directory on the on the volume where the Archive log files need to be stored.

Mkdir -p /u01/ARCHIVE
Assign the directory for the Archive logs and the format of the file name in sp file (configuration file). The output of each command is provided for reference.

SQL> alter system set log_archive_dest_1='location=/u01/ARCHIVE' scope=spfile;
System altered.
SQL> alter system set log_archive_format='NewOra_%t_%s_%r.arc' scope=spfile;
System altered.
Check the log mode on Oracle database with the following command:

SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG

SQL> archive log list;

Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/ARCHIVE
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2