Oracle：归档日志文件的查询
查询数据库当前的归档日志文件的详细信息可以通过视图：v$archived_log获得，其中“sequence#”对应了归档日志的序列号。
Shell 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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 |
SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 33 Next log sequence to archive 37 Current log sequence 37 SQL> SQL> show parameter db_recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fast_recovery_ area db_recovery_file_dest_size big integer 4182M SQL> SQL> select name,Thread#,SEQUENCE#,status,archival_thread# from v$archived_log; NAME THREAD# SEQUENCE# S ARCHIVAL_THREAD# ------------------------------------------------------------------------------------------ ---------- ---------- - ---------------- /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_3_9yfvyd9c_.arc 1 3 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_4_9yfvyo9j_.arc 1 4 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_5_9yfvywd6_.arc 1 5 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_6_9yfvz1fj_.arc 1 6 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_7_9yfvz96t_.arc 1 7 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_8_9yfwh4ot_.arc 1 8 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_9_9yfz853v_.arc 1 9 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_10_9yfzko8y_.arc 1 10 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_11_9yfzslyf_.arc 1 11 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_12_9yfztn2j_.arc 1 12 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_13_9yfzvcn2_.arc 1 13 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_14_9yfzw0ps_.arc 1 14 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_15_9yg050cj_.arc 1 15 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_16_9yg0g1tc_.arc 1 16 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_17_9yg0hg9d_.arc 1 17 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_18_9yg0jvby_.arc 1 18 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_19_9yg0lkdf_.arc 1 19 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_20_9yg0whjl_.arc 1 20 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_21_9yg1f29p_.arc 1 21 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_22_9yg1hbs9_.arc 1 22 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_23_9yg1krxf_.arc 1 23 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_24_9yg1on7p_.arc 1 24 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_25_9yg21xjx_.arc 1 25 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_26_9yg2cjq0_.arc 1 26 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_27_9yg2f0lg_.arc 1 27 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_28_9yg2j9yx_.arc 1 28 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_29_9yg2l90l_.arc 1 29 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_30_9yg3cfd9_.arc 1 30 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_31_9yg3y2t6_.arc 1 31 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_32_9yg40ms0_.arc 1 32 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_33_9yg41xtc_.arc 1 33 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_09/o1_mf_1_34_9yg4cnwj_.arc 1 34 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_10/o1_mf_1_35_9yg6hhcw_.arc 1 35 A 1 /u01/app/oracle/fast_recovery_area/EMDB/archivelog/2014_08_13/o1_mf_1_36_9yq08g3s_.arc 1 36 A 1 34 rows selected. SQL> SQL> run 1* select dest_id,dest_name,name_space,target,status,log_Sequence,process,reopen_secs,delay_mins,applied_scn,type from v$archive_Dest DEST_ID DEST_NAME NAME_SP TARGET STATUS LOG_SEQUENCE PROCESS REOPEN_SECS DELAY_MINS APPLIED_SCN TYPE ---------- -------------------- ------- -------------------- --------- ------------ ---------- ----------- ---------- ----------- ------- 1 LOG_ARCHIVE_DEST_1 SYSTEM PRIMARY VALID 36 ARCH 0 0 0 PUBLIC 2 LOG_ARCHIVE_DEST_2 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 3 LOG_ARCHIVE_DEST_3 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 4 LOG_ARCHIVE_DEST_4 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 5 LOG_ARCHIVE_DEST_5 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 6 LOG_ARCHIVE_DEST_6 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 7 LOG_ARCHIVE_DEST_7 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 8 LOG_ARCHIVE_DEST_8 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 9 LOG_ARCHIVE_DEST_9 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 10 LOG_ARCHIVE_DEST_10 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 11 LOG_ARCHIVE_DEST_11 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 12 LOG_ARCHIVE_DEST_12 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 13 LOG_ARCHIVE_DEST_13 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 14 LOG_ARCHIVE_DEST_14 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 15 LOG_ARCHIVE_DEST_15 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 16 LOG_ARCHIVE_DEST_16 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 17 LOG_ARCHIVE_DEST_17 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 18 LOG_ARCHIVE_DEST_18 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 19 LOG_ARCHIVE_DEST_19 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 20 LOG_ARCHIVE_DEST_20 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 21 LOG_ARCHIVE_DEST_21 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 22 LOG_ARCHIVE_DEST_22 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 23 LOG_ARCHIVE_DEST_23 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 24 LOG_ARCHIVE_DEST_24 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 25 LOG_ARCHIVE_DEST_25 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 26 LOG_ARCHIVE_DEST_26 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 27 LOG_ARCHIVE_DEST_27 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 28 LOG_ARCHIVE_DEST_28 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 29 LOG_ARCHIVE_DEST_29 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 30 LOG_ARCHIVE_DEST_30 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 31 LOG_ARCHIVE_DEST_31 SYSTEM PRIMARY INACTIVE 0 ARCH 0 0 0 PUBLIC 31 rows selected. SQL> SQL> show parameter LOG_ARCHIVE_DEST_1 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string log_archive_dest_10 string 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 SQL> SQL> show parameter log_archive_format NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_format string %t_%s_%r.dbf SQL> SQL> show parameter db_create_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string SQL> |
————————————————————————————
Ending。
