system tablespace corrupt
Hello,
Environment: Oracle 10.2.0.4, Windows 2003 x86
I have a customer with an oracle database, of witch the SYSTEM tablespace is corrupted. No problem I hear you say, just copy a backupped datafile from tape back and do recovery using the archivelogs. But, unfortunately, they 'forgot' to make backups of the database and there aren't any archivelogs available.
so until this stage, I only know of an inconsistincy in the SYSTEM tablespace. I'm hoping that the tablespace containing all the objects of the application still is valid. Can someone give me an direction where to go?
-----
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DDB\SYSTEM01.DBF'
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 587202560 bytes
Fixed Size 1298040 bytes
Variable Size 432013704 bytes
Database Buffers 150994944 bytes
Redo Buffers 2895872 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00279: change 170420858 generated at 09/25/2012 08:00:30 needed for thread
1
ORA-00289: suggestion :
D:\ORACLE\ORADATA\DDB\ARCHIVE\DDB_1_8027_687364464.ARC
ORA-00280: change 170420858 for thread 1 is in sequence #8027
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\oradata\DDB\ONLINELOG\O1_MF_3_517Y6K00_.LOG
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
SQL>
-----
In the alertlog, the following information is stored:
ALTER DATABASE RECOVER LOGFILE 'D:\oracle\oradata\DDB\ONLINELOG\O1_MF_3_517Y6K00_.LOG'
Tue Oct 09 15:19:46 2012
Media Recovery Log D:\oracle\oradata\DDB\ONLINELOG\O1_MF_3_517Y6K00_.LOG
Hex dump of (file 1, block 4584) in trace file d:\oracle\admin\DDB\udump\DDB_ora_5328.trc
Corrupt block relative dba: 0x004011e8 (file 1, block 4584)
Fractured block found during media recovery
Data in bad block:
type: 6 format: 2 rdba: 0x004011e8
last change scn: 0x0000.0a28114d seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x6e4e0601
check value in block header: 0x728b
computed block checksum: 0x117d
Reread of rdba: 0x004011e8 (file 1, block 4584) found same corrupted data
You can't copy the datafiles from a tablespace and mount them unto another database. But is there another sollution for this? I appreciate your help!