rman实验之归档模式有备份，正常关机丢失数据文件的恢复(二)
3510_81zojyz5_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_08_06/o1_mf_nnndf_TAG20120806T223510_81zojyz5_.bkp tag=TAG20120806T223510
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 06-AUG-12
RMAN> recover datafile 4;
Starting recover at 06-AUG-12
using channel ORA_DISK_1
www.2cto.com
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 06-AUG-12
RMAN> alter database open;
database opened
5 查询数据
[sql]
hr@ORCL> select * from tt;
NAME
--------------------
test1
test2
test3
数据全部回来，恢复成功！
作者 linwaterbin