ALTER SYSTEM CHECKPOINT 影响数据文件的检查点

来源：互联网发布：如何把淘宝网店关闭编辑：程序博客网时间：2024/06/05 21:15

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
2015368

SQL> select name,checkpoint_change# from v$datafile;

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/system01.dbf
2015323

/u01/app/oracle/oradata/orcl/undotbs01.dbf
2015323

/u01/app/oracle/oradata/orcl/sysaux01.dbf
2015323

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/users01.dbf
2015323

/u01/app/oracle/oradata/orcl/eygle01.dbf
2015323

SQL> alter system checkpoint;

System altered.

SQL> select name,checkpoint_change# from v$datafile;

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/system01.dbf
2015376

/u01/app/oracle/oradata/orcl/undotbs01.dbf
2015376

/u01/app/oracle/oradata/orcl/sysaux01.dbf
2015376

NAME
--------------------------------------------------------------------------------
CHECKPOINT_CHANGE#
------------------
/u01/app/oracle/oradata/orcl/users01.dbf
2015376

/u01/app/oracle/oradata/orcl/eygle01.dbf
2015376