Brief descriptions of the parameters used in the LOG_ARCHIVE_DEST_n.
SERVICE – Specifies a valid service name for the standby database.
SYNC | ASYNC – Specifies whether the redo data is to be received at the destination before the transaction is committed. ASYNC is default.
AFFIRM | NOAFFIRM – Control whether the redo destination acknowledges received redo data. NOAFFIRM is the default for ASYNC if not specified. AFFIRM is the default for SYNC for if not specified.
NET_TIMEOUT – Specifies the time in seconds that the primary database log writer will wait for a response from the Log Network Service (LNS) before terminating the connection and marking the standby (destination) as failed. The default value is 30 seconds.
REOPEN – Specifies the time in seconds that the log writer should wait before attempting to access a previously failed standby (destination). The default is 300 seconds.
DB_UNIQUE_NAME – Unique name for the standby database
VALID_FOR(logifile,role) –Specifies that a specific log destination is valid only when the database is in a particular role.
Hope this will help you... :)
Best Regards,
SERVICE – Specifies a valid service name for the standby database.
SYNC | ASYNC – Specifies whether the redo data is to be received at the destination before the transaction is committed. ASYNC is default.
AFFIRM | NOAFFIRM – Control whether the redo destination acknowledges received redo data. NOAFFIRM is the default for ASYNC if not specified. AFFIRM is the default for SYNC for if not specified.
NET_TIMEOUT – Specifies the time in seconds that the primary database log writer will wait for a response from the Log Network Service (LNS) before terminating the connection and marking the standby (destination) as failed. The default value is 30 seconds.
REOPEN – Specifies the time in seconds that the log writer should wait before attempting to access a previously failed standby (destination). The default is 300 seconds.
DB_UNIQUE_NAME – Unique name for the standby database
VALID_FOR(logifile,role) –Specifies that a specific log destination is valid only when the database is in a particular role.
Hope this will help you... :)
Best Regards,
No comments:
Post a Comment