Oracle非归档模式Media Recovery错误之--ORA-26040(二)

2014-11-24 17:16:26 · 作者: · 浏览: 2
ng from backup piece /dsk3/bak/34_PROD.bak


channel ORA_DISK_1: piece handle=/dsk3/bak/34_PROD.bak tag=TAG20140724T181640


channel ORA_DISK_1: restored backup piece 1


channel ORA_DISK_1: restore complete, elapsed time: 00:00:01


Finished restore at 24-JUL-14


RMAN> recover datafile 9;


Starting recover at 24-JUL-14


using channel ORA_DISK_1


starting media recovery


media recovery complete, elapsed time: 00:00:01


Finished recover at 24-JUL-14



查看告警日志:


Thu Jul 24 18:34:49 2014


Full restore complete of datafile 9 /u01/app/oracle/oradata/prod/tbs2.dbf. Elapsed time: 0:00:00


checkpoint is 2168258


Thu Jul 24 18:34:57 2014


alter database recover datafile list clear


Completed: alter database recover datafile list clear


alter database recover if needed


datafile 9


Media Recovery Start


Serial Media Recovery started


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


Mem# 0: /dsk1/oradata/prod/redo03a.log


Mem# 1: /dsk2/oradata/prod/redo03b.log


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


Mem# 0: /dsk1/oradata/prod/redo01a.log


Mem# 1: /dsk2/oradata/prod/redo01b.log


Media Recovery Complete (prod)


Completed: alter database recover if needed


datafile 9


通过group1和3,进行了media recovery !