试着open库
SYS@linuxidc SQL>alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/dbdata/oradata/linuxidc/moe01.dbf'
SYS@linuxidc SQL>recover datafile 5;
Media recovery complete.
SYS@linuxidc SQL>alter database open;
Database altered.
看一下alert文件
ALTER DATABASE RECOVER datafile 5
Media Recovery Start
Serial Media Recovery started
Media Recovery Complete (linuxidc)
Completed: ALTER DATABASE RECOVER datafile 5
Thu Nov 10 13:47:24 2016
alter database open
Thu Nov 10 13:47:25 2016
Thread 1 opened at log sequence 27
Current log# 3 seq# 27 mem# 0: /dbdata/oradata/linuxidc/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Nov 10 13:47:25 2016
SMON: enabling cache recovery
[20910] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:3710149144 end:3710149224 diff:80 (0 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 AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Nov 10 13:47:25 2016
QMNC started with pid=20, OS id=21409
Completed: alter database open
在本次恢复过程中，recover是可行的，原因是该库并没做过resetlog，如果datafile是在 resetlog之前就已经offline的数据文件，那recover是不可行的。