各個scn的查詢方法

RBA增量檢查點 儲存在控制檔案中
SQL> select last_redo_change# from v$thread;

LAST_REDO_CHANGE#
-----------------
          2728183

資料庫當前scn
SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    2728191
資料庫當前全域性檢查點

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
           2716603
儲存在控制檔案中的檢查點資訊

SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#
------------------
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603

9 rows selected.
儲存在資料檔案頭中的檢查點資訊

SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603
           2716603

9 rows selected.