oracle DATABASE crash after electic power down. [message #492685] |
Tue, 01 February 2011 15:31 |
koff10
Messages: 58 Registered: December 2006 Location: france
|
Member |
|
|
My oracle DATABASE (on archivelog mode ) crash after electic power down.
when try to restart the database ( startup "sid")
I got error :
SQL> startup
Oracle instance started
Instance ORACLE lancée.
Total System Global Area 1536602112 bytes
Fixed Size 2211288 bytes
Variable Size 1191182888 bytes
Database Buffers 335544320 bytes
Redo Buffers 7663616 bytes
Database mounted
ORA-00600: internal error code, arguments : [kcratr_nab_less_than_odr], [1],
[41], [2984], [3011], [], [], [], [], [], [], []
There are no alerte log file.
thanks for help.
|
|
|
|
|
|
Re: oracle DATABASE crash after electic power down. [message #492766 is a reply to message #492685] |
Wed, 02 February 2011 06:02 |
Yasir Hashmi
Messages: 304 Registered: April 2006
|
Senior Member |
|
|
Whenever there is a power failure or abnormal shutdown of the database, there is some kind of corruption occurs in the datafiles or redo logfiles when ora-600 is thrown. Check the associated trace file
if it lists out any corruption information of any tablespace.
Ofcourse you must contact support but you might try
recover database if you have the archive files/redo log files intact
|
|
|