检查Oracle归档日志——v$archived_log和v$archived_log视图

查看系统当前归档日志信息

SQL> select  THREAD#,SEQUENCE#,ARCHIVAL_THREAD# from v$archived_log;

   THREAD#  SEQUENCE# ARCHIVAL_THREAD#
---------- ---------- ----------------
	 1	    7		     1
	 1	    8		     1
	 1	    9		     1

SQL> 

查看归档日志产生的时间

SQL>  select * from v$loghist;

   THREAD#  SEQUENCE# FIRST_CHANGE# FIRST_TIM SWITCH_CHANGE#
---------- ---------- ------------- --------- --------------
	 1	    1	     925702 28-SEP-19	      956602
	 1	    2	     956602 28-SEP-19	      956843
	 1	    3	     956843 28-SEP-19	      966279
	 1	    4	     966279 28-SEP-19	      987743
	 1	    5	     987743 28-SEP-19	     1014282
	 1	    6	    1014282 28-SEP-19	     1040672
	 1	    7	    1040672 09-OCT-19	     1041743
	 1	    8	    1041743 09-OCT-19	     1041746
	 1	    9	    1041746 09-OCT-19	     1041749

9 rows selected.

SQL> 


或者：

SQL> select THREAD#,SEQUENCE#,FIRST_CHANGE#,to_char(FIRST_TIME,'yyyy-mm-dd hh24:mi:ss'),SWITCH_CHANGE# from v$loghist;

   THREAD#  SEQUENCE# FIRST_CHANGE# TO_CHAR(FIRST_TIME, SWITCH_CHANGE#
---------- ---------- ------------- ------------------- --------------
	 1	    1	     925702 2019-09-28 19:39:48 	956602
	 1	    2	     956602 2019-09-28 19:40:58 	956843
	 1	    3	     956843 2019-09-28 19:41:02 	966279
	 1	    4	     966279 2019-09-28 19:41:18 	987743
	 1	    5	     987743 2019-09-28 19:41:36        1014282
	 1	    6	    1014282 2019-09-28 20:12:20        1040672
	 1	    7	    1040672 2019-10-09 12:38:51        1041743
	 1	    8	    1041743 2019-10-09 12:41:23        1041746
	 1	    9	    1041746 2019-10-09 12:41:24        1041749

9 rows selected.

SQL>