4 /u01/tiger/oradata/orcl2/users01.dbf ONLINE NO
5 /u01/tiger/oradata/orcl2/undotbs02.dbf OFFLINE WRONG FILE TYPE
7 /u01/tiger/oradata/orcl2/tiger.dbf ONLINE NO
第八，恢复
SQL> !cp /bk/undotbs02.dbf/u01/tiger/oradata/orcl2/
SQL> selectfile#,name,status,recover,error from v$datafile_header;
FILE# NAME STATUS REC ERROR
-------------------------------------------------- ------- --- --------------------
1 /u01/tiger/oradata/orcl2/system01.dbf ONLINE NO
3 /u01/tiger/oradata/orcl2/sysaux01.dbf ONLINE NO
4 /u01/tiger/oradata/orcl2/users01.dbf ONLINE NO
5 /u01/tiger/oradata/orcl2/undotbs02.dbf OFFLINEYES
7 /u01/tiger/oradata/orcl2/tiger.dbf ONLINE NO
正确识别了文件头但是需要恢复
SQL> recover datafile 5;
ORA-00603: ORACLE server session terminatedby fatal error
SQL> conn /as sysdba
Connected.
SQL> col error for a20
SQL> selectfile#,name,status,recover,error from v$datafile_header;
FILE# NAME STATUS REC ERROR
-------------------------------------------------- ------- --- --------------------
1 /u01/tiger/oradata/orcl2/system01.dbf ONLINE NO
3 /u01/tiger/oradata/orcl2/sysaux01.dbf ONLINE NO
4 /u01/tiger/oradata/orcl2/users01.dbf ONLINE NO
5 /u01/tiger/oradata/orcl2/undotbs02.dbf OFFLINE NO
7 /u01/tiger/oradata/orcl2/tiger.dbf ONLINE NO
使得5号数据文件上线
SQL> alter database datafile 5 online;
Database altered.
SQL> selectfile#,name,status,recover,error from v$datafile_header;
FILE# NAME STATUS REC ERROR
-------------------------------------------------- ------- --- --------------------
1 /u01/tiger/oradata/orcl2/system01.dbf ONLINE NO
3 /u01/tiger/oradata/orcl2/sysaux01.dbf ONLINE NO
4 /u01/tiger/oradata/orcl2/users01.dbf ONLINE NO
5 /u01/tiger/oradata/orcl2/undotbs02.dbf ONLINE NO
7 /u01/tiger/oradata/orcl2/tiger.dbf ONLINE NO