Oracle Tips by Burleson

log_archive_config Tips

Parameter type – String

Syntax – log_archive_config =
      {
      [ SEND | NOSEND ]
      [ RECEIVE | NORECEIVE ]
      [ DG_CONFIG=(remote_sp_name1 [, ... remote_sp_name9)
      | NODG_CONFIG ]
     }

Default value – ’SEND, RECEIVE, NODG_CONFIG’

Modifiable – ALTER SYSTEM

log_archive_config enables or disables the sending of redo logs to remote destinations and the receipt of remote redo logs. It also specifies the service provider names (sp_name) for each database in the Data Guard configuration.

Values:

• send – Enables the sending of redo logs to remote destinations.
   

• nosend – Disables the sending of redo logs to remote destinations.
   

• receive – Enables the receipt of remotely archived redo logs.
   

• noreceive – Disables the receipt of remotely archived redo logs.
   

• dg_config – Specifies a list of up to nine service provider names (defined with the sp_name initialization parameter) for all of the databases in the Data Guard configuration.
   

• nodg_config – Eliminates the list of service provider names previously specified with the dg_config option.

With dg_config, you can dynamically add a database to the Data Guard configuration while in maximum availability or maximum protection mode without shutting down databases.

The following four parameters are related to Automated Storage Management instance (ASM).