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......!!!!!
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:
Post a Comment