ALLSTARS_ORACLE 发表于 2017-4-16 13:17:27

晕倒费了N久时间resorte文件成功,recover database出错。

忍受了N个错误,终于resorte文件成功了,
recover database skip tablespace SYSAUX,OLDDATA,MEDIA,MISDATA,TABBAK,NEWUNDOTBS;

Starting recover at 04-JAN-09
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/04/2009 18:23:53
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 12374 lowscn 4431406600 found to restore
RMAN-06025: no backup of log thread 1 seq 12373 lowscn 4431344118 found to restore
RMAN-06025: no backup of log thread 1 seq 12372 lowscn 4431291546 found to restore
RMAN-06025: no backup of log thread 1 seq 12371 lowscn 4431248259 found to restore
RMAN-06025: no backup of log thread 1 seq 12370 lowscn 4431194374 found to restore
RMAN-06025: no backup of log thread 1 seq 12369 lowscn 4431119817 found to restore
RMAN-06025: no backup of log thread 1 seq 12368 lowscn 4431036858 found to restore
RMAN-06025: no backup of log thread 1 seq 12367 lowscn 4430951948 found to restore
RMAN-06025: no backup of log thread 1 seq 12366 lowscn 4430865429 found to restore
RMAN-06025: no backup of log thread 1 seq 12365 lowscn 4430782014 found to restore
RMAN-06025: no backup of log thread 1 seq 12364 lowscn 4430684645 found to restore
RMAN-06025: no backup of log thread 1 seq 12363 lowscn 4430555571 found to restore
RMAN-06025: no backup of log thread 1 seq 12362 lowscn 4430471276 found to restore
RMAN-06025: no backup of log thread 1 seq 12361 lowscn 4430380167 found to restore
RMAN-06025: no backup of log thread 1 seq 12360 lowscn 4430294853 found to restore
RMAN-06025: no backup of log thread 1 seq 12359 lowscn 4430204285 found to restore
RMAN-06025: no backup of log thread 1 seq 12358 lowscn 4430094894 found to restore
RMAN-06025: no backup of log thread 1 seq 12357 lowscn 4429834341 found to restore
RMAN-06025: no backup of log thread 1 seq 12356 lowscn 4429682447 found to restore
RMAN-06025: no backup of log thread 1 seq 12355 lowscn 4429632182 found to restore
RMAN-06025: no backup of log thread 1 seq 12354 lowscn 4429542611 found to restore
RMAN-06025: no backup of log thread 1 seq 12353 lowscn 4429451589 found to restore
RMAN-06025: no backup of log thread 1 seq 12352 lowscn 4429353236 found to restore
RMAN-06025: no backup of log thread 1 seq 12351 lowscn 4429305661 found to restore
RMAN-06025: no backup of log thread 1 seq 12350 lowscn 4429291617 found to restore
RMAN-06025: no backup of log thread 1 seq 12349 lowscn 4429267274 found to restore
RMAN-06025: no backup of log thread 1 seq 12348 lowscn 4429246186 found to restore
RMAN-06025: no backup of log thread 1 seq 12347 lowscn 4429225550 found to restore
RMAN-06025: no backup of log thread 1 seq 12346 lowscn 4429201624 found to restore
RMAN-06025: no backup of log thread 1 seq 12345 lowscn 4429176485 found to restore
RMAN-06025: no backup of log thread 1 seq 12344 lowscn 4429133246 found to restore
RMAN-06025: no backup of log thread 1 seq 12343 lowscn 4429019535 found to restore
RMAN-06025: no backup of log thread 1 seq 12342 lowscn 4428822693 found to restore

看了归档目录,所有的这些缺的归档都在,问题何在?

不是RAC,是个单机的恢复环境


如何写?

recover database until cancel skip tablespace SYSAUX,OLDDATA,MEDIA,MISDATA,TABBAK,NEWUNDOTBS;



有2008年12月28日的全备份,2008年12月29-31日的1级备份,2009-1-1的1级备份,备份时间是晚上0:30
我只打算恢复到2009年1月1日 0:00 的时间点就好了,有25日以来的全部归档。没有删过归档

页: [1]
查看完整版本: 晕倒费了N久时间resorte文件成功,recover database出错。