ORA-01115 ORA-01110:system01.dbf Oracle OS corrupted

If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.

Parnassusdata Software Database Recovery Team

Service Hotline:  +86 13764045638 E-mail: [email protected]



Database has been forced to open with _allow_resetlogs_corruption and _corrupted_rollback_segments
Now we are trying to export all the data to recreate database, export fails with:
Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 871
ORA-01115: IO error reading block from file 1 (block # 68730)
ORA-01110: data file 1: '/pelican/PELICAN/system01.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 110: Media surface error
Additional information: 7
Additional information: 68729
Additional information: -1

ora10g4S@(/pelican/PELICAN)$ /orahome/ora10204s/bin/dbv file=system01.dbf feedback=100
DBVERIFY: Release 10.2.0.4.0 - Production on Wed Aug 14 12:50:05 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = system01.dbf
................................................................................
................................................................................
................................................................................
................................................................................
................................................................................
................................................................................
................................................................................
................................................................................
.....................
DBV-00102: File I/O error on FILE (system01.dbf) during verification read operation (-2)

run
{
allocate channel d1 type disk;
backup check logical validate datafile 1;
release channel d1;
}


RMAN> backup check logical validate datafile 1;
Starting backup at 14-AUG-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=380 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/pelican/PELICAN/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/14/2013 13:31:14
ORA-19501: read error on file "/pelican/PELICAN/system01.dbf", blockno 66817 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 110: Media surface error
Additional information: -1
Additional information: 1048576

Reading a block of system datafile fails with IBM AIX RISC System/6000 Error: 110: Media surface err
Reading a block of system datafile fails with IBM AIX RISC System/6000 Error: 110: Media surface err

Action Plan:
=========
1. Shutdown the database with immediate option
2-Un-mount the FS that contain the Datafile
3-Run FSCK to fix the corrupted OS Blocks.
4-Re-mount the FS.
5. Restart the database


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *