[Installing Oracle DataBase Server 11.2.0.3 on Oracle Linux 6.3]: Multiplexing Archivelogs


Creating a directory for storing backup files and archive logs

$ mkdir -p /u02/oradata/${ORACLE_SID}/archivelogs
$ mkdir -p /u03/oradata/${ORACLE_SID}/archivelogs


$ sqlplus / as sysdba

Set directories for archive logs

SQL>  ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='location=/u02/oradata/ora112/archivelogs mandatory' scope=both;
SQL>  ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='location=/u03/oradata/ora112/archivelogs mandatory' scope=both;

View current values of the LOG_ARCHIVE_DEST parameter

SQL> show parameter LOG_ARCHIVE_DEST;

Set format for archivelog files

SQL>  ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%R.arc' scope=spfile;


SQL> quit





I recommend going directly to the latest version of the document, which uses newer software versions

Link to the Oracle installation document.