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

bitao

$ sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on 星期二 6月 7 19:55:27 2005

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to an idle instance.

SQL>; SQL>;
SQL>;
SQL>;
SQL>; startup
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.
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/system01.dbf'


SQL>;


$ dbv file=/data/orarle/aradata/smartcd/system01.dbf blocksize=8192

DBVERIFY: Release 8.1.7.0.0 - Production on 星期二 6月 7 21:41:10 2005

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

DBVERIFY - Verification starting : FILE = /data/oracle/oradata/smartcd/system01.
dbf
Block Checking: DBA = 4194362, Block Type = KTB-managed data block
Found block already marked corrupted


DBVERIFY - Verification complete

Total Pages Examined         : 33280
Total Pages Processed (Data) : 10541
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 3257
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 562
Total Pages Empty            : 18920
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
$

bitao

没有冷备，只有二天前的逻辑备份。有没办法恢复呀！！

zwm1234

有备份吗

zwm1234

你可以强制打开数据库
1. 在init.ora参数文件中加入如下参数
   _ALLOW_RESETLOGS_CORRUPTION = TRUE

2. mount数据库
   sql>; startup mount
3. 执行如下命令
   RECOVER DATABASE
       或
   RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

4. 当需要应用归档日志文件时,键入cancel回车

5. 打开数据库
   sql>; ALTER DATABASE OPEN RESETLOGS
如可以请回复

bitao

就是因为没做备份呀，有好的办法吗？

zwm1234

能打开数据库吗?

bitao

OPEN时报如下错
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/system01.dbf'

zwm1234

用我的方法打不开吗?
SHUTDOWN ABORT
STARTUP MOUNT
ALTER SESSION SET EVENTS '10015 TRACE NAME ADJUST_SCN LEVEL 1';
ALTER DATABASE OPEN

zwm1234

还是不能打开吗?

bitao

因为里面数据是很重要的，，现在正在做好备份，还没试。。试完有结果再回复您!!
谢谢先!!