SQL：查看归档日志的存储位置及其状态
Command：
col dest_name for a30
col destination for a30
set linesize 400
col pagesize 400
select dest_nae,destinatin,status,binding from v$archive_dest;
Log：
|
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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
SQL> col destination for a30 SQL> set pagesize 300 SQL> set linesize 300 SQL> col dest_name for a28 SQL> SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 23 Current log sequence 25 SQL> SQL> select dest_name,destination,status,binding from v$archive_dest; DEST_NAME DESTINATION STATUS BINDING ---------------------------- ------------------------------ --------- --------- LOG_ARCHIVE_DEST_1 USE_DB_RECOVERY_FILE_DEST VALID MANDATORY LOG_ARCHIVE_DEST_2 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_3 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_4 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_5 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_6 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_7 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_8 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_9 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_10 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_11 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_12 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_13 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_14 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_15 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_16 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_17 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_18 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_19 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_20 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_21 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_22 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_23 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_24 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_25 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_26 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_27 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_28 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_29 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_30 INACTIVE OPTIONAL LOG_ARCHIVE_DEST_31 INACTIVE OPTIONAL 31 rows selected. SQL> |
——————————————————————
Ending。
