Skip to content

Archivelog Mode On RAC

    Configuring Archivelog Mode On RAC

    If the LOG_ARCHIVE_DEST_n parameters are not set, the archived redo logs will be placed in the FRA. If you want to specify their location and the file name format manually, you can do it as follows.

    ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/MYDB/archive/' SCOPE=spfile;
    ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

    From the command line we can stop the entire clustered database and start it in mount mode using the following.

    $ srvctl stop database -d MYDB
    $ srvctl start database -d MYDB -o mount

    With the database mounted issue the following commands.

    sqlplus / as sysdba
    
    ALTER DATABASE ARCHIVELOG;
    EXIT;

    Since the datafiles and spfile are shared between all instances this operation only has to be done from a single node.

    From the command line we stop and start the clustered database again using the following commands.

    $ srvctl stop database -d MYDB
    $ srvctl start database -d MYDB

    Also See:

    Oracle RAC

    Instances and Cluster Databases