Для информации... Вдруг кто-то искать будет.
1. How to Recover When OS Tempfiles Are Missing
--------------------------------------------
a) The tempfile was located on a disk that crashed, had a bad
controller, or some other type of media failure.
Since Oracle does not record checkpoint information in tempfiles,
Oracle can start up a database with a missing tempfile.
If a tempfile does not exist when the database is brought up,
DBW0 writes to a trace file indicating the tempfile is not found,
but the database opens normally.