Unable to start database /ORA-1092 /ORA-01578 /ORA1110
vittelNov 15 2007 — edited Nov 15 2007Hi,
Oracle 10gR1 ( 10.1.0.3.0)
Linux: RedHat 3
This morning we had a problem to connect the server so some one restart it!!!
When I try to start the database I get in first time an:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt],
So I shutdown the dtabase and I try :
recover database;
Alter database open database;
Then I get the famouse error: ORA-1092
you found here a part of my alert:
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Nov 15 14:56:43 2007
SMON: enabling cache recovery
Thu Nov 15 14:56:44 2007
Errors in file /u01/app/oracle/admin/OSIRIS/udump/osiris_ora_8825.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 137)
ORA-01110: data file 2: '/u01/app/oracle/oradata/OSIRIS/undotbs01.dbf'
Thu Nov 15 14:56:44 2007
Error 1578 happened during db open, shutting down database
USER: terminating instance due to error 1578
Instance terminated by USER, pid = 8825
ORA-1092 signalled during: ALTER DATABASE OPEN...
Some one have an idea how I can open my database?