Recovery Oracle 10g XE after disk crash
Hi!
I am trying to recover 10g XE database for my colleague and experiencing some problems that I cannot resolve.
He had mayor overheating problem and disk crash due to the failure of air conditioning.
OS: Windows Server 2003
DB Version: 10.2.0.1.0
After disk crashed I've managed to save image of Oracle data files and tried to recover database using them.
Database was not running in archive log mode so all files that I had were database files, control file, parameter file and redo logs.
First error that I experienced on newly installation of Oracle Express Edition (10.2.0.1.0) was:
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 1286460 bytes
Variable Size 62918340 bytes
Database Buffers 121634816 bytes
Redo Buffers 2904064 bytes
ORA-00227: corrupt block detected in control file: (block 16, # blocks 1)
ORA-00202: control file: 'C:\ORACLEXE\ORADATA\XE\CONTROL.DBF'
By default Oracle XE creates just one control file so I had just one incarnation of control file and apparently that file was corrupted so I tried to recreate control file.
With "ALTER DATABASE BACKUP CONTROLFILE TO TRACE" I've created script for new control file but after script execution received error.
SQL> @c:\ctlfile.sql
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 1286460 bytes
Variable Size 62918340 bytes
Database Buffers 121634816 bytes
Redo Buffers 2904064 bytes
CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name \E in file header does not match given name of XE
ORA-01110: data file 4: 'C:\ORACLEXE\ORADATA\XE\USERS.DBF'
I also tried to use:
"CREATE CONTROLFILE SET DATABASE "XE" RESETLOGS NOARCHIVELOG..." in script but received the same errors.
Apparently database name is wrongly written in header of USERS.DBF and I don't know how to overcome this problem. Possible character set problem or data file corruption...
I used "CHARACTER SET AL32UTF8" character set.
I don't have any RMAN backups because all tapes were destroyed along with tape drive due to the air conditioning failure what caused overheating of small server room.
So if you have any idea how to open database I would be grateful for help.
Thanks!