你在这里

You are here:

首页

博客

PDSERVICE的博客

Unable to open the database after data block corruption

Posted by PDSERVICE on 4月 18, 2017 In

O.S-windows vista enterprise(Personal PC),

oracle 11.1.0.2.0

I am getting the following error, please help to fix:

I am unable to recover data file &open database.

SQL> conn sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup open

ORACLE instance started.

Total System Global Area 644468736 bytes

Fixed Size 1376520 bytes

Variable Size 251662072 bytes

Database Buffers 385875968 bytes

Redo Buffers 5554176 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00604: error occurred at recursive SQL level 1

ORA-01578: ORACLE data block corrupted (file # 1, block # 665)

ORA-01110: data file 1: 'C:\ORACLE\ORADATA\GIRO\SYSTEM01.DBF'

Process ID: 6132

Session ID: 767 Serial number: 3

SQL> recover datafile 'C:\ORACLE\ORADATA\GIRO\SYSTEM01.DBF';

ERROR:

ORA-03114: not connected to ORACLE

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL>

Answer:

You cannot recover media failure in noarchivelog mode. The best you can do is use a data recovery service like PRM-DUL http://www.parnassusdata.com/en/oracle-dul or Oracle's expensive service unless you get lucky and Aman's suggestion works. Support might have some help since it is the system data file, but I wouldn't hold my breath.

This is why you take backups.

If all the data you need is character type, you might try the unix strings command.