使用 RMAN 修复案例

使用 RMAN 修复

blockrecover datafile 11 block 12;

RMAN> blockrecover datafile 11 block 12;

启动 blockrecover 于 2008-06-27 14:48:54

使用通道 ORA_DISK_1

通道 ORA_DISK_1: 正在恢复块

通道 ORA_DISK_1: 正在指定要从备份集恢复的块

正在恢复数据文件 00011 的块

通道 ORA_DISK_1: 正在读取备份段 E:\06JK01HI_1_1

通道 ORA_DISK_1: 已从备份段 1 恢复块

段句柄 = E:\06JK01HI_1_1 标记 = TAG20080627T144154

通道 ORA_DISK_1: 块恢复完成, 用时: 00:00:02

正在开始介质的恢复

介质恢复完成, 用时: 00:00:03

完成 blockrecover 于 2008-06-27 14:49:02

select count(*) from users;

COUNT(*)

46

完成恢复了数据，前提条件：有相应备份和近期的 REDO 和归档

alter database recover datafile list clear

Fri Jun 27 14:48:59 2008

Completed: alter database recover datafile list clear

Fri Jun 27 14:48:59 2008

Starting block media recovery

Fri Jun 27 14:49:00 2008

Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0

Mem# 0 errs 0: E:\ORACLEFILES\DATABASEFILES\WWW\REDO01.LOG

Fri Jun 27 14:49:02 2008

Completed block media recovery

drop tablespace tbs including contents and datafiles;