SYS owned .dbf file corrupt

[tman138]

I have an old HPUX E-55 server that we use as a test server. Yesterday it started reporting I/O read errors and several Oracle errors which I found in a trace log file:
ORA-00604: error occurred are recursive SQL level 1
ORA-01115: IO error reading block from file 11 (block # 7313)
ORA-01110: data file11: '/users/home/ORACLE/testdB/sys2test.dbf'
ORA-27072: skgdisp: I/O error
HP-UX Error: 5 I/O error
I'm not sure but it appears that the error was caused by a bad sector on th ehard drive. My problem is that the tape drive failed on this machine a few years ago and was never replaced so I have to backup or means to restore. Since the data file is owned by 'SYS', I can't export it from my production server (or can I?)
Naturally I've tried shutting down and restarting Oracle, but I get the error right after the database mounts.
Without a backup, what are my options?

 

[Turkbear]

Hi,
If is it part of the system tablespace and you have no backup, AFAIK, you are out of luck.

( As a last resort, you might try to use some disk utility to correct the drive's structure and recover bad sectors - maybe...)








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[oradba101]

Hi, tman138

You should be able to export the SYS objects either as an individual user or the entire database.

Regards,

William Chadbourne
Oracle DBA

 

[tman138]

I was afraid of that. I think I will delete & recreate the database, and do an import.

 

[KenCunningham]

And maybe swap out the disk first....

 

[tman138]

Yeah - I ran fsck and it's shot.