LOG_ARCHIVE_CONFIG

Property	Description
Parameter type	String
Syntax	LOG_ARCHIVE_CONFIG = { [ SEND | NOSEND ] [ RECEIVE | NORECEIVE ] [ DG_CONFIG=(remote_db_unique_name1 [, ... remote_db_unique_name9) | NODG_CONFIG ] }
Default value	'SEND, RECEIVE, NODG_CONFIG'
Modifiable	ALTER SYSTEM
Basic	No

LOG_ARCHIVE_CONFIG enables or disables the sending of redo logs to remote destinations and the receipt of remote redo logs, and specifies the unique database names (DB_UNIQUE_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 9 unique database names (defined with the DB_UNIQUE_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.

Note:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LOG_ARCHIVE_CONFIG’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
log_archive_config		TRUE	FALSE	IMMEDIATE	TRUE	FALSE	log archive config parameter

Oracle initializatoin parameters

More Oracle DBA tips, please visit Oracle DBA Tips