Home » RDBMS Server » Server Administration » oracle DATABASE crash after electic power down. (oracle 11gR2 solaris 10)
oracle DATABASE crash after electic power down. [message #492685] Tue, 01 February 2011 15:31 Go to next message
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 #492686 is a reply to message #492685] Tue, 01 February 2011 15:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Re: oracle DATABASE crash after electic power down. [message #492739 is a reply to message #492686] Wed, 02 February 2011 02:42 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Just a quick tip in general in file corruption cases:

Before you do try to do *anything* else, make a cold file level backup of what you have now first.
Re: oracle DATABASE crash after electic power down. [message #492741 is a reply to message #492685] Wed, 02 February 2011 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are 2 references on this error and what is weird is that one is closed as "Not a bug" and the other one is in status "Code bug"!

You have to open a SR to get more.

Regards
Michel
Re: oracle DATABASE crash after electic power down. [message #492766 is a reply to message #492685] Wed, 02 February 2011 06:02 Go to previous message
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
Previous Topic: Db Migration from 9i to 10g
Next Topic: TNS-01151: Missing listener name, orcl (2 threads merged by bb)
Goto Forum:
  


Current Time: Wed May 08 11:17:01 CDT 2024