Creating Archive Log Files in Oracle ASM

Disk groups can be specified as archive log destinations in the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_n initialization parameters. When destinations are specified in this manner, the archive log file names are created in default subdirectories with unique names. However, all LOG_ARCHIVE_DEST_n parameters must have a unique string. To enter the same disk group more than once, subdirectories must be used. For example, you can set LOG_ARCHIVE_DEST_n as follows:

LOG_ARCHIVE_DEST_1 = 'LOCATION=+FRA/orcl/arc_1'
LOG_ARCHIVE_DEST_2 = 'LOCATION=+FRA/orcl/arc_2'
...

If LOG_ARCHIVE_DEST is set to a disk group name, LOG_ARCHIVE_FORMAT is ignored. Unique filenames for archived logs are automatically created by Oracle Database under default subdirectories. If LOG_ARCHIVE_DEST is set to a directory in a disk group, LOG_ARCHIVE_FORMAT has its normal semantics for the file alias. The underlying file is still generated in the default directories for the disk group with a system generated name.

You can also set the DB_RECOVERY_FILE_DEST initialization parameter to a disk group destination. In Example 17-3, archive log files are generated with ARCHIVELOG mode enabled, DB_RECOVERY_FILE_DEST set to the +FRA disk group, and ORCL is the value of the DB_UNIQUE_NAME parameter.

See Also:

Oracle Database Administrator's Guide for information about managing archived redo log files

Example 17-3 Archived log files in an Oracle ASM disk group

SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +FRA

SQL> SELECT SUBSTR(name,1,64) name FROM V$ARCHIVED_LOG;
 
NAME
----------------------------------------------------------------
+FRA/ORCL/ARCHIVELOG/2013_06_24/thread_1_seq_112.260.818960623
+FRA/ORCL/ARCHIVELOG/2013_06_24/thread_1_seq_113.261.818978423
+FRA/ORCL/ARCHIVELOG/2013_06_25/thread_1_seq_114.262.818993031
+FRA/ORCL/ARCHIVELOG/2013_06_25/thread_1_seq_115.263.819032439
+FRA/ORCL/ARCHIVELOG/2013_06_25/thread_1_seq_116.264.819047121
+FRA/ORCL/ARCHIVELOG/2013_06_25/thread_1_seq_117.265.819064815
+FRA/ORCL/ARCHIVELOG/2013_06_26/thread_1_seq_118.266.819079417
...