Tuesday, 27 September 2011

Oracle database lost Temp datafile

1- Shutdown the database if its open.
     Shutdown abort;

2- Startup the database in mount state:
    startup mount;

3- Drop the missing tempfile:
    Alter database datafile '/OraData/DBPORTAL/temp03.dbf' offline drop;

4- Open the database normally:
    alter database open;

No comments:

Post a Comment

Number of Visitors