Daily Oracle: log_archive_des

Log_archive_dest_n allows you to set the archive location, which can be a remote location or a local location. You can configure 10 locations. For example, you can set it to point to the backup node server, it helps to ensure the security of archiving log backup. If too many configurations are set, there is a certain pressure on Database io. In addition, if any of the archiving locations is faulty, the database will be suspended during the switchover and rewriting. The database must wait until all the archives are complete before re-writing the redo log.

Log_archive_dest and log_archive_duplex_dest can only point to the local location. These two parameters cannot be used together with log_archive_dest_n.

SQL> alter system set log_archive_dest_1 = 'location = c: \ Oracle \ archivelog ';

The system has been changed.

SQL> show parameter log_archive_dest_1

NAME TYPE VALUE
-----------------------------------------------------------------------------
Log_archive_dest_1 string location = c: \ oracle \ archivelog
Log_archive_dest_10 string

Log_archive_dest_state_1 string enable
Log_archive_dest_state_10 string enable

SQL> show parameter log_archive_dest _

NAME TYPE VALUE
-----------------------------------------------------------------------------
Log_archive_dest_1 string location = c: \ oracle \ archivelog
Log_archive_dest_10 string
Log_archive_dest_2 string
Log_archive_dest_3 string
Log_archive_dest_4 string
Log_archive_dest_5 string
Log_archive_dest_6 string
Log_archive_dest_7 string
Log_archive_dest_8 string
Log_archive_dest_9 string
Log_archive_dest_state_1 string DEFER
Log_archive_dest_state_10 string enable
Log_archive_dest_state_2 string enable
Log_archive_dest_state_3 string enable
Log_archive_dest_state_4 string enable
Log_archive_dest_state_5 string enable
Log_archive_dest_state_6 string enable
Log_archive_dest_state_7 string enable
Log_archive_dest_state_8 string enable
Log_archive_dest_state_9 string enable