数据库一致性的4个SCN

湖北佛 · 发表于 2013-9-8 22:27:49

马上注册，结交更多好友，享用更多功能^_^

您需要登录才可以下载或查看，没有账号？立即注册

x

sys@OMREP> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
         1995418

sys@OMREP> select checkpoint_change#,last_change# from v$datafile;

CHECKPOINT_CHANGE# LAST_CHANGE#
------------------ ------------
         1995418
         1995418
         1995418
         1995418

sys@OMREP> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
         1995418
         1995418
         1995418
         1995418

sys@OMREP> shutdown immediate;
sys@OMREP> startup mount;

sys@OMREP> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
         1996199

sys@OMREP> select checkpoint_change#,last_change# from v$datafile;

CHECKPOINT_CHANGE# LAST_CHANGE#
------------------ ------------
         1996199    1996199
         1996199    1996199
         1996199    1996199
         1996199    1996199

sys@OMREP> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
         1996199
         1996199
         1996199
         1996199

sys@OMREP> alter database open;

sys@OMREP> alter system switch logfile;

System altered.

sys@OMREP> startup mount force;
ORACLE instance started.

Total System Global Area  422670336 bytes
Fixed Size                1336960 bytes
Variable Size          331352448 bytes
Database Buffers          83886080 bytes
Redo Buffers             6094848 bytes
Database mounted.

sys@OMREP> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
         2016326

sys@OMREP> select checkpoint_change#,last_change# from v$datafile;

CHECKPOINT_CHANGE# LAST_CHANGE#
------------------ ------------
         2016326
         2016326
         2016326
         2016326

sys@OMREP> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
         2016326
         2016326
         2016326
         2016326

不一致性关闭没有last_change#
scn有四个,控制文件中三个：
select checkpoint_change# from v$database;
select checkpoint_change#,last_change# from v$datafile;

数据文件里一个:
select checkpoint_change# from v$datafile_header;

伙夫和甲鱼 · 发表于 2016-1-30 18:43:18

支持一下

账号		自动登录	找回密码
密码			立即注册

[Oracle] 数据库一致性的4个SCN

马上注册，结交更多好友，享用更多功能^_^