Home » RDBMS Server » Backup & Recovery » Database abnormally shutdown
Database abnormally shutdown [message #264279] |
Sun, 02 September 2007 15:03  |
kamragulshan
Messages: 66 Registered: May 2005 Location: Delhi
|
Member |
|
|
I have Oracle 10gR1 on Solaris 5.8. Database is in archive log mode. We did shutdown our database. But when we bring up the database, it is having strang behaviour. when i start the database then after opening the database it abnormally generating the trace files and fillup the space at the partition where trace files stores. But when i read the alert log file then i found that the below file may need media recovery.
/OracleData/oradata/beatles/undotbs02.dbf
I started the database at mount stage and then put the above datafile offline and open the database. then i observe that the trace file storage area was in consistent state. But when i recover the database and the online the datafile. It automatically behaving abnormally and filling up the trace files storage area and the result is database down.
Could you please help me to troubleshoot this issue.
Thanks in Advance.
|
|
|
|
|
|
Goto Forum:
Current Time: Thu May 01 20:50:05 CDT 2025
|