# restore and recover datafile
sql 'alter database datafile 4, 5 offline';
restore datafile 4, 5;
recover datafile 4, 5;
sql 'alter database datafile 4, 5 online';
Do you really want to execute the above repair (enter YES or NO) yes
executing repair script
sql statement: alter database datafile 4, 5 offline
Starting restore at 21-AUG-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /u01/V112_oradata/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/V112_oradata/test01.dbf
channel ORA_DISK_1: reading from backup piece
/u01/temp/flash_areas/V112/V112/backupset/2013_08_21/o1_mf_nnndf_TAG20130821T100251_919l4f2p_.bkp
channel ORA_DISK_1: piece
handle=/u01/temp/flash_areas/V112/V112/backupset/2013_08_21/o1_mf_nnndf_TAG20130821T100251_919l4f2p_.bkp
tag=TAG20130821T100251
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 21-AUG-13
Starting recover at 21-AUG-13
using channel ORA_DISK_1
archived log for thread 1 with sequence 79 is already on disk as file
/u01/temp/flash_areas/V112/V112/archivelog/2013_08_21/o1_mf_1_79_919lm6y2_.arc
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=77
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=78
channel ORA_DISK_1: reading from backup piece
/u01/temp/flash_areas/V112/V112/backupset/2013_08_21/o1_mf_annnn_TAG20130821T101028_919llo3n_.bkp
channel ORA_DISK_1: piece
handle=/u01/temp/flash_areas/V112/V112/backupset/2013_08_21/o1_mf_annnn_TAG20130821T101028_919llo3n_.bkp
tag=TAG20130821T101028
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/temp/flash_areas/V112/V112/archivelog/2013_08_21/o1_mf_1_77_919ltj5h_.arc
thread=1 sequence=77
channel default: deleting archived log(s)
archived log file name=/u01/temp/flash_areas/V112/V112/archivelog/2013_08_21/o1_mf_1_77_919ltj5h_.arc
RECID=50 STAMP=824033680
archived log file name=/u01/temp/flash_areas/V112/V112/archivelog/2013_08_21/o1_mf_1_78_919ltj7o_.arc
thread=1 sequence=78
channel default: deleting archived log(s)
archived log file name=/u01/temp/flash_areas/V112/V112/archivelog/2013_08_21/o1_mf_1_78_919ltj7o_.arc
RECID=51 STAMP=824033680
media recovery complete, elapsed time: 00:00:00
Finished recover at 21-AUG-13
sql statement: alter database datafile 4, 5 online
repair failure complete
一旦成功完成修复脚本，这个问题应该得到解决，并且select语句返回预期的结果：
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- -------- --------- ----- --------- ---- ----- ------
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10