Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | String |
Syntax | LOG_ARCHIVE_DEST_STATE_ n = { alternate | reset | defer | enable } |
Default value | enable |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Basic | Yes |
The LOG_ARCHIVE_DEST_STATE_
n
parameters (where n
= 1, 2, 3, ... 10) specify the availability state of the corresponding destination. The parameter suffix (1 through 10) specifies one of the ten corresponding LOG_ARCHIVE_DEST_
n
destination parameters.
Values:
enabled
Specifies that a valid log archive destination can be used for a subsequent archiving operation (automatic or manual). This is the default.
defer
Specifies that valid destination information and attributes are preserved, but the destination is excluded from archiving operations until re-enabled.
alternate
Specifies that a log archive destination is not enabled but will become enabled if communications to another destination fail.
The LOG_ARCHIVE_DEST_STATE_
n
parameters have no effect on the ENABLE
state for the LOG_ARCHIVE_DEST
or LOG_ARCHIVE_DUPLEX_DEST
parameters.
The V$ARCHIVE_DEST
dynamic performance view shows values in use for the current session. The DEST_ID
column of that view corresponds to the archive destination suffix n
.
See Also:
Oracle Database Backup and Recovery Advanced User's Guide and Oracle Database Administrator's Guide for more information and examples