Skip to main content

How can we help you?

Druva Documentation

How to set archive mode in RMAN

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

  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.

    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.
     
  3. 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
  • Was this article helpful?