- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 19:47:36
|
查看: 1297 |
回复: 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 全备,没有归档日志。要都恢复不了,以后备份之后必须马上归档当前日志然后备份下来了。
|
|