- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-14 17:46:39
|
查看: 1579 |
回复: 0
情况说明:
数据库 ORACLE 11.2.0.1 LINUX5.5 (64位)
存储的盘柜突然故障,无法连接,最后只能重启电源,盘柜恢复正常,重新开启数据库正常,DB能正常开启,但是使用一段时间后一直报
后面通过
SQL> recover datafile 113;
SQL> alter database datafile 113 online;
可以使用,但是过十几分又报ORA-00376及ORA-01110的错,反复做了几次都是这样。
再来通过RMAN的备份来恢复这个数据文件
RMAN> restore datafile 113;
这个可以做
但是做RECOER时报错
RMAN>recover datafile 113;
archived log file name=/oradata01/archive/1_250665_725732074.dbf thread=1 sequence=250665
archived log file name=/oradata01/archive/1_250666_725732074.dbf thread=1 sequence=250666
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/29/2013 03:14:46
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/oradata01/archive/1_250666_725732074.dbf'
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [113], [701255], [474657607], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 113, block# 701255, file offset is 1449713664 bytes)
ORA-10564: tablespace CELL_INFO_2013_B
ORA-01110: data file 113: '/oradata01/appdata01/cell_info_2013_b_03.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 258035
请教大家如何恢复这个数据文件,能否先RESTORE DATAFILE 113,再做RECOVER 时能RECOVER到指定时间?或是RECOVER到最近的归档?
急呀,请大这帮忙看看
实在不行就RMAN恢复,RMAN有做8/16日有个全备是完整的,然后ARCHIVE LOG的备份是从8/14号以后都有,另外8/23日有个全备,但是因为空间满了,只备了一大半,没备份完,如果这样用RMAN来restore 及recover,RMAN是自动判断用8/16的全备吗?还是要手动指定?
为什么DB都可以 OPEN,但是113 这个文件就是显示RECOVER的状态,
SQL> select file#,checkpoint_change#,status,name from v$datafile where file#='113'
2 ;
FILE# CHECKPOINT_CHANGE# STATUS
---------- ------------------ -------
NAME
--------------------------------------------------------------------------------
113 1.2828E+10 RECOVER
/oradata01/appdata01/cell_info_2013_b_03.dbf
另外做RECOVER时报错:
SQL> recover datafile 113;
ORA-00279: change 12827494452 generated at 08/28/2013 21:13:45 needed for
thread 1
ORA-00289: suggestion : /oradata01/archive/1_250667_725732074.dbf
ORA-00280: change 12827494452 for thread 1 is in sequence #250667
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [113], [701255],
[474657607], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 113, block# 701255, file
offset is 1449713664 bytes)
ORA-10564: tablespace CELL_INFO_2013_B
ORA-01110: data file 113: '/oradata01/appdata01/cell_info_2013_b_03.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 258035
ORA-01112: media recovery not started
有什么办法没有?急呀!
有完整备份,在RMAN下做的话,如何可以恢复至REDO坏之前,
直接RECOVER DATABASE 可以吗?
|
|