归档日志查询

查看当前数据库的归档序列号

SQL> select hxfil,fhscn,fhrba_seq from x$kcvfh;

 

     HXFIL FHSCN             FHRBA_SEQ

---------- ---------------- ----------

         1 3078640                  37

         2 3078640                  37

         3 3078640                  37

         4 3078640                  37

         5 3078640                  37

         6 3078640                  37

         7 3078640                  37

         8 3077425                  31

1）FHRBA_SEQ：表示当前联机日志对应的日志序列号

2）FHSCN ：SCN

 查看归档日志的归档序列号

SQL> select group#,archived,sequence#,status from v$log;

 

    GROUP# ARC SEQUENCE# STATUS