12 rows selected.

SQL> select file#,to_char(checkpoint_change#,'999999999999'),to_char(RESETLOGS_CHANGE#,'999999999999') from v$datafile_header;

FILE# TO_CHAR(CHECK TO_CHAR(RESET
----- ------------- -------------
    1       3587033       3580553
    2       3587033       3580553
    3       3587033       3580553
    4       3587033       3580553
    5       3587033       3580553
    6       3587033       3580553
    7       3587033       3580553
    8       3587033       3580553
    9       3587033       3580553
   10       3587033       3580553
   11       3587033       3580553
   12       3395372        995548

12 rows selected.

 

SQL> alter database open;

Database altered.

SQL> recover datafile 5;
Media recovery complete.
SQL> alter database datafile 5 online;

Database altered.

SQL> 

如下是：从alter database open; 之后的alert日志：

Sun Apr 19 05:09:46 2015
alter database open
Sun Apr 19 05:09:47 2015
LGWR: STARTING ARCH PROCESSES
Sun Apr 19 05:09:47 2015
ARC0 started with pid=20, OS id=3461
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sun Apr 19 05:09:48 2015
ARC1 started with pid=21, OS id=3463
Sun Apr 19 05:09:48 2015
ARC2 started with pid=22, OS id=3465
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Apr 19 05:09:48 2015
SMON: enabling cache recovery
Sun Apr 19 05:09:48 2015
ARC3 started with pid=23, OS id=3467
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
[3382] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:17282894 end:17283434 diff:540 (5 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sun Apr 19 05:09:53 2015
QMNC started with pid=24, OS id=3470
Sun Apr 19 05:10:04 2015
Completed: alter database open
Sun Apr 19 05:10:04 2015
Starting background process CJQ0
Sun Apr 19 05:10:06 2015
CJQ0 started with pid=30, OS id=3494
ALTER DATABASE RECOVER  datafile 5
Media Recovery Start
Serial Media Recovery started
WARNING! Recovering data file 5 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
Media Recovery Complete (test)
Completed: ALTER DATABASE RECOVER  datafile 5
Sun Apr 19 05:10:17 2015
alter database datafile 5 online
Completed: alter database datafile 5 online

?

?