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: service@parnassusdata.com
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
Comment