ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN学习--- Datafile 恢复

RMAN学习--- Datafile 恢复

原创 Linux操作系统 作者:quanli0818 时间:2012-01-06 14:44:58 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 删除列操作
请登录后发表评论 登录
全部评论

注册时间:2010-01-25

  • 博文量
    26
  • 访问量
    121767