oracle非一致性开库,数据库一致性关闭与非一致性关闭的一些问题

一致性关闭数据库的状态下：

SQL> select

FILE#,CHECKPOINT_CHANGE#,LAST_CHANGE# from v$datafile;

FILE# CHECKPOINT_CHANGE# LAST_CHANGE#

----------

------------------ ------------

111332661133266

211332661133266

311332661133266

411332661133266

511332661133266

611332661133266

6 rows selected.

由此可以发现CHECKPOINT_CHANGE#与LAST_CHANGE#的scn号是一样的；

非一致性关闭数据库的状态下；

SQL>select

FILE#,CHECKPOINT_CHANGE#,LAST_CHANGE# from v$datafile;

FILE# CHECKPOINT_CHANGE# LAST_CHANGE#

----------

------------------ ------------

11133734

21133734

31133734

41133734

51133734

61133734

6 rows selected.

由此可以看出CHECKPOINT_CHANGE#与LAST_CHANGE#的scn号是不一样的。所以此时要正常关闭数据库重新启动，然后再查看发现他们的scn号一样了；

SQL> alter

database open;

Database altered.

SQL> shutdown immediate

Database closed.

Database

dismounted.

ORACLE instance

shut down.

SQL> startup mount

ORACLE instance

started.

Total System

Global Area830930944 bytes

Fixed Size2257800 bytes

Variable Size536874104 bytes

Database

Buffers285212672 bytes

Redo Buffers6586368 bytes

Database mounted.

SQL> select

FILE#,CHECKPOINT_CHANGE#,LAST_CHANGE# from v$datafile;

FILE# CHECKPOINT_CHANGE# LAST_CHANGE#

----------

------------------ ------------

111543401154340

211543401154340

311543401154340

411543401154340

511543401154340

611543401154340

6 rows selected.