Thursday 20 March 2014

Recovering when temp file is lost

How to recover a temp file when it is lost?


Here we dont need to restore/recover any datafile/controlfile.
Just restart the database.It will be automatically created.
 1.Remove the file
~ rm temp01.dbf
2.Restart database
~ sqlplus / as sysdba
SQL>shutdown
SQL>startup
3. check the file now
~ ls -lrt temp*
-rw-r----- 1 oracle dba 20979712 Mar 19 19:50 temp01.dbf.


Cheers......!!!!!












No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...