万分火急呀！！突然掉电后数据库文件损坏，请问怎样恢复？

你是广东的吗?

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

bitao

丰衣足食

论坛徽章:: 0

12楼 [报告]

发表于 2005-06-07 23:33 |只看该作者

万分火急呀！！突然掉电后数据库文件损坏，请问怎样恢复？

是呀!!我QQ49464421 加我吧

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

bitao

丰衣足食

论坛徽章:: 0

13楼 [报告]

发表于 2005-06-08 02:14 |只看该作者

万分火急呀！！突然掉电后数据库文件损坏，请问怎样恢复？

SQL>; startup mount
ORACLE instance started.

Total System Global Area  481030820 bytes
Fixed Size                   74404 bytes
Variable Size          462532608 bytes
Database Buffers          16777216 bytes
Redo Buffers             1646592 bytes
Database mounted.
SQL>; recover database
Media recovery complete.
SQL>; alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

SQL>; shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL>; startup mount
ORACLE instance started.

Total System Global Area  481030820 bytes
Fixed Size                   74404 bytes
Variable Size          462532608 bytes
Database Buffers          16777216 bytes
Redo Buffers             1646592 bytes
Database mounted.
SQL>; recover database using backup controlfile until cancel;
ORA-00279: change 83910256 generated at 06/08/2005 00:36:32 needed for thread 1
ORA-00289: suggestion : /redo/oracle/arch/arch_1_22802.arc
ORA-00280: change 83910256 for thread 1 is in sequence #22802

Specify log: {<RET>;=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL>; alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 5

ORA-01110: data file 1: '/data/oracle/oradata/smartcd/system02.dbf'

SQL>;

二种方式都试过了，，但都不行。

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

sshd

家境小康

论坛徽章:: 0

14楼 [报告]

发表于 2005-06-08 05:08 |只看该作者

万分火急呀！！突然掉电后数据库文件损坏，请问怎样恢复？

the logical backup (done by exp) can NOT be used

if you do not have physical backup, your only choice is to call oracle support to see if they can fix the block using a binary editor.

make sure do not attemp any recovery methods before (cold) backup all the database (control, redo, data) files