Skip to content
Home » Oracle » How to Resolve ORA-01258: unable to delete temporary file

How to Resolve ORA-01258: unable to delete temporary file

  • Oracle

ORA-01258

We successfully dropped a temporary tablespace with its all files, but we saw some errors like ORA-01258 in the alert log.

SQL> drop tablespace temp including contents and datafiles;

Tablespace altered.

In alert log, we saw many errors like this:

[oracle@standby01 ~]$ cd $ORACLE_BASE/diag/rdbms/orclcdb/ORCLCDB1/trace
[oracle@standby01 ~]$ alert_$ORACLE_SID.log
...
ORA-01122: database file 1403 failed verification check
ORA-01110: data file 1403: '+DATA/ORCLCDB/ORCLPDB/temp01.dbf'
ORA-01203: wrong incarnation of this file - wrong creation SCN
ORA-01258: unable to delete temporary file +DATA/ORCLCDB/ORCLPDB/temp01.dbf

ORA-01258 means that Oracle cannot delete the temporary file from the storage at this moment. In this case, it's because the file belongs to a different incarnation which is not the current one.

Solution

Although Oracle is unable to remove the file, we can delete it manually. For single-instance databases, just use rm command to remove tempfiles.

For RAC databases, you may use asmcmd rm to remove them.

[grid@standby01 ~]$ asmcmd rm +DATA/ORCLCDB/ORCLPDB/temp01.dbf
[grid@standby01 ~]$ asmcmd rm +DATA/ORCLCDB/ORCLPDB/temp02.dbf
[grid@standby01 ~]$ asmcmd rm +DATA/ORCLCDB/ORCLPDB/temp03.dbf
[grid@standby01 ~]$ asmcmd rm +DATA/ORCLCDB/ORCLPDB/temp04.dbf

We have solved ORA-01258 by physically removing tempfiles.

Leave a Reply

Your email address will not be published. Required fields are marked *