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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 19:47:36 | 查看: 1296| 回复: 0
我的数据库rac环境rman全备,只备份了数据库,没有备份归档日志。把rac的备份拷贝到单机去做恢复测试,restore 和 swich datafile这些做完之后,alter database open resetlogs 报错:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:/..../......system01.dbf


接着恢复:
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 14107677719408 generated at 10/25/2014 15:22:08 needed for thread 1
ORA-00289: suggestion : /app/oracle/dbs/arch1_1_861895321.dbf
ORA-00280: change 14107677719408 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:/..../......system01.dbf


查看select name,checkpoint_change# from v$datafile_header;  checkpoint是一致的。由于没有归档日志,也没有当时的redo,所以加了参数_allow_resetlogs_corruption=TRUE 想强制打开,但是加了这个参数后打开数据库报错:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [3284], [3005119352], [3284], [3005140602], [12583040], [], [], [], [], [], []
Process ID: 14409
Session ID: 385 Serial number: 3


接着加了以下几个参数各种组合试了一下都是报错600,startup force什么的都用了也不行
_allow_error_simulation=TRUE
_allow_resetlogs_corruption=TRUE
_allow_terminal_recovery_corruption=TRUE
_no_recovery_through_resetlogs=TRUE


没辙了,哪位大神看下还能恢复不? 只有rman 全备,没有归档日志。要都恢复不了,以后备份之后必须马上归档当前日志然后备份下来了。

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

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

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

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

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

GMT+8, 2024-12-20 16:46 , Processed in 0.045360 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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