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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 17:46:39 | 查看: 1580| 回复: 0
情况说明:
     数据库 ORACLE 11.2.0.1 LINUX5.5 (64位)
      存储的盘柜突然故障,无法连接,最后只能重启电源,盘柜恢复正常,重新开启数据库正常,DB能正常开启,但是使用一段时间后一直报


135101g1mmp02mv88h58mn.jpg


  后面通过
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 可以吗?


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

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

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

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

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

GMT+8, 2024-12-20 14:57 , Processed in 0.054124 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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