RMAN学习--- Datafile 恢复

RMAN> sql 'alter database datafile 3 offline';  ---模拟 3号数据文件丢失

sql statement: alter database datafile 3 offline

RMAN> restore datafile 3;    --- 恢复数据文件3

Starting restore at 06-JAN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
channel ORA_DISK_1: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_01_05\O1_MF_NNNDF_TAG20120105T170442_7JBSXCKD_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_01_05\O1_MF_NNNDF_TAG20120105T170442_7JBSXCKD_.BKP tag=TAG20120105T170442
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
Finished restore at 06-JAN-12

RMAN> recover datafile 3; --- Media恢复数据文件3

Starting recover at 06-JAN-12
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:11

Finished recover at 06-JAN-12

RMAN> sql 'alter database datafile 3 online';  --- 数据文件3 Online

sql statement: alter database datafile 3 online

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22606628/viewspace-714526/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22606628/viewspace-714526/