Attribute | Description |
---|---|
|
Log transport services can transmit redo data to this destination. |
|
Log transport services will not transmit redo data to this destination. This is a valid but unused destination. |
|
This destination is not enabled, but it will become enabled if communication to its associated destination fails. |
|
Functions the same as |
SQL> alter system set log_archive_dest_state_ 2="defer";
System altered.
SQL> show parameter dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/tbtest/a
dump
background_dump_dest string /u01/app/oracle/diag/rdbms/pr_
tbtest/tbtest/trace
core_dump_dest string /u01/app/oracle/diag/rdbms/pr_
tbtest/tbtest/cdump
cursor_bind_capture_destination string memory+disk
db_create_file_dest string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 4122M
diagnostic_dest string /u01/app/oracle
log_archive_dest string
log_archive_dest_1 string location=/u01/archlog valid_
for=(all_logfiles,all_roles)
db_unique_name=pr_tbtest
log_archive_dest_10 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service=st_tbtest lgwr async
valid_for=(online_logfiles,pri
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
mary_role) db_unique_name=st_
tbtest