| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | LOG_ARCHIVE_DEST_STATE_[1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
| 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
| 29 | 30 | 31] = { enable | defer | alternate } |
| Default value | enable |
| Modifiable | ALTER
SESSION, ALTER SYSTEM |
| Basic | Yes |
The LOG_ARCHIVE_DEST_STATE_n parameters (where n = 1, 2, 3, ... 31) specify the
availability state of the corresponding destination. The parameter suffix (1
through 31) specifies one of the corresponding LOG_ARCHIVE_DEST_n destination parameters.
Values:
enable
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
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
