Solution : https://service.sap.com/sap/support/notes/491160 (SAP Service marketplace login required)
Key words :
sql>alter tablespace psaptemp add tempfile '<path/filename>' size <size>, sysdba'sql> alter database drop logfile member '<path/filename>', sysdba'sql> alter system archive log logfile '<path/filename>', terms restorerecoveryoracledatafilecontrolfileonline redologfilearchiveredo logarchived redologfilecheck & repair solution, sysdba'sql> alter database drop logfile '<path/filename>', directory$oracle_home/saptrace/usertracegoto $oracle_home/saptrace/usertrace, sysdba'sql> alter database drop logfile group <groupid>, sql> alter database add logfile member '<path/filename>', sql>alter database tempfile '<path/filename>' drop, sql> alter database drop logfile '<path/filename>'
Related Notes :
| 867681 | ALTER DATABASE TEMPFILE DROP hangs |
| 806554 | FAQ: I/O-intensive database operations |
| 719849 | ORA-01620 during Oracle upgrade to version 9i |
| 653083 | Composite SAP note: ORA-00314 |
| 639986 | crash recovery/instance recovery hangs |
| 605062 | FAQ: Restore and recovery |
| 546006 | Problems with Oracle due to operating system errors |