查看当前数据库的归档序列号
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