为何我的SCN 不一至,数据库也能正常启动?
Select group#,sequence#,status,first_change# from v$Log;
GROUP# SEQUENCE# STATUS FIRST_CHANGE#
---------- ---------- ---------------- -------------
1 115 CURRENT 18775914
2 113 INACTIVE 18224162
3 114 INACTIVE 18526864
Select name,dbid,checkpoint_change# from v$database;
NAME DBID CHECKPOINT_CHANGE#
--------- ---------- ------------------
ORDB2 1954278483 18775915
Select file#,checkpoint_change#,name from v$datafile;
FILE# CHECKPOINT_CHANGE# NAME
---------- ------------------ -------------------------------------------------
1 18775915 E:\ORACLE\ORADATA\ORDB2\SYSTEM01.DBF
2 18775915 E:\ORACLE\ORADATA\ORDB2\UNDOTBS01.DBF
3 18775915 E:\ORACLE\ORADATA\ORDB2\CWMLITE01.DBF
4 18775915 E:\ORACLE\ORADATA\ORDB2\DRSYS01.DBF
5 18775915 E:\ORACLE\ORADATA\ORDB2\EXAMPLE01.DBF
6 18885501 E:\ORACLE\ORADATA\ORDB2\INDX01.DBF
7 18775915 E:\ORACLE\ORADATA\ORDB2\ODM01.DBF
8 18775915 E:\ORACLE\ORADATA\ORDB2\TOOLS01.DBF
9 18775915 E:\ORACLE\ORADATA\ORDB2\USERS01.DBF
10 18775915 E:\ORACLE\ORADATA\ORDB2\XDB01.DBF
11 18775915 E:\ORACLE\ORADATA\ORDB2\ERPSYS.ORA
12 18775915 E:\ORACLE\ORADATA\ORDB2\KYLINSPACE.DBF
13 18775915 E:\ORACLE\ORADATA\ORDB2\SOFTSPACE.DBF
为何我的SCN 不一至,数据库也能正常启动?