为何我的SCN 不一至，数据库也能正常启动？

Question

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              18526864Select name,dbid,checkpoint_change# from v$database;
NAME            DBID CHECKPOINT_CHANGE#
--------- ---------- ------------------
ORDB2     1954278483           18775915Select 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 不一至，数据库也能正常启动？

Answer 1

您的 indx 表空间是否offline 才导致E:\ORACLE\ORADATA\ORDB2\INDX01.DBF SCN 不一致？