1、系统SCN---system SCNSQL> select checkpoint_change# from v$database;CHECKPOINT_CHANGE#------------------ 1109690
2、控制文件记录的数据文件SCN--datafile SCNSQL> select name,checkpoint_change# from v$datafile;NAME CHECKPOINT_CHANGE#-------------------------------------------------- ------------------/oracle/app/oradata/db1/system01.dbf 1109690/oracle/app/oradata/db1/undotbs01.dbf 1109690/oracle/app/oradata/db1/sysaux01.dbf 1109690/oracle/app/oradata/db1/users01.dbf 1109690
3、数据文件自己头部的SCN--start SCNSQL> select name,checkpoint_change# from v$datafile_header;NAME CHECKPOINT_CHANGE#-------------------------------------------------- ------------------/oracle/app/oradata/db1/system01.dbf 1109690/oracle/app/oradata/db1/undotbs01.dbf 1109690/oracle/app/oradata/db1/sysaux01.dbf 1109690/oracle/app/oradata/db1/users01.dbf 1109690
4、控制文件中记录的数据文件结束的SCN--end SCNSQL> select name,last_change# from v$datafile;NAME LAST_CHANGE#-------------------------------------------------- ------------/oracle/app/oradata/db1/system01.dbf/oracle/app/oradata/db1/undotbs01.dbf/oracle/app/oradata/db1/sysaux01.dbf/oracle/app/oradata/db1/users01.dbf