Database Backup and Recovery (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center