Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 13:17:27 | 查看: 1614| 回复: 0
忍受了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日以来的全部归档。没有删过归档

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-23 14:21 , Processed in 0.043407 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569