Hmm...it sounds like your database is in noarchivelog mode. Maybe you
would prefer to have the database in ARCHIVELOG mode if you are going
to start dropping datafiles ;) It sounds like a complete recovery is
impossible, unless that datafile did not contain any useful data.
Options:
- If the file did not have any useful data in it, you can just add the
file back by using the alter tablespace <name> reuse 'a1.dbf'. But you
won't get any data in the file back again.
- If the file had useful data in, you can either restore the database
from a previous backup (but obviously lose all changes between the full
backup and the current version)..
- ..or you can restore the database to a new location, drop the
tablespace that owned the 'a1.dbf', and transport a copy of the
tablespace from the restored version. Search the manuals for TSPITR
Received on Tue Feb 08 2005 - 04:58:55 CST