Qzheng, your scenario should work.
No need for any recovery, no need for any backup controlfile to trace etc, as suggested by some other members.
You have clean cold backup, that is everything you need. Restore everything from your cold backup and you are ready to mount your database.
About redo logs:
When you have database in mount mode (here you will be able to drop the unwanted tablespaces) you will also update the controlfile with the new locations of your restored redo log files and datafiles.
ALTER DATABASE RENAME FILE 'old_redo_log' TO 'new_redo_log;
[Edited by jmodic on 10-10-2002 at 03:05 AM]
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Reply With Quote