Oracle 7.3.4 Restoring a DB without TEMP tablespace result in hung database
Hi,
We have restored the Db from backup taken excluding the TEMP tablespace.
SVRMGR>recover database using backup controlfile until cancel;
CANCEL
Media recovery cancelled.
SVRMGR> alter database datafile '/u01/db6/oradata/hops/hops_temp01.dbf' offline drop;
SVRMGR> Statement processed.
SVRMGR> alter database open resetlogs;
Statement processed.
SVRMGR> drop tablespace temp;
drop tablespace temp
*
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option
There are temp segments in the TEMP tablespace. Why?
SVRMGR> drop tablespace temp including contents;
hangs.
SVRMGR> shutdown immediate;
Hungs.
Urgent production issue.
Any hints/help will be greatly appreciated.
Thanks