Skip to main content
How to set archive mode in RMAN
Updated over a week ago

This article applies to:

  • OS: Linux

  • Product edition: Phoenix (Latest Oracle agent)


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

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

    Mkdir -p /u01/ARCHIVE
  2. 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.

    alter system set log_archive_dest_1='location=/u01/ARCHIVE' scope=spfile;
    System altered.


    alter system set log_archive_format='NewOra_%t_%s_%r.arc' scope=spfile;
    System altered.
  3. Check the log mode on Oracle database with the following command:


    select log_mode from v$database;
        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
Did this answer your question?