This article applies to:
OS: Linux
Product edition: Phoenix (Latest Oracle agent)
Overview
This article helps to enable the Archive mode on RMAN. It also helps to know if the mode is already active.
Enable the Archive mode on RMAN
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