2 questions, deleting a tablespace on a damaged instance and tablespace

From: Stan Brown <stanb_at_panix.com>
Date: Sun, 28 Sep 2003 15:24:53 +0000 (UTC)
Message-ID: <bl6ug4$snp$1@reader2.panix.com>

First, let me apologize fro starting a new thread on this, but I seem to have stopped getting any replies to the old one :-(

I've got a V7 instance that suffered a hardware failure, while doing a hot backup. The disk that failed was the disk contain the archivelogs. In addition I discovered that my backup methodology had a 2G limit that I was unaware of, so my backups of the .dbf files are useless. In addition, I tried doing media recovery, when perhaps I should not have.

In any case, here are the questions.

I can get as far a "startup mount". at that point what do I need to do to delete a tablespace (contained in a single .dbf file) from the instance?

2/ Given the following:

SVRMGR> select * from v$backup ;
FILE# STATUS CHANGE# TIME

---------- ------------------ ---------- --------------------
         1 ACTIVE              108475458 09/25/03 01:34:44
         2 NOT ACTIVE          108475457 09/25/03 00:17:04
         3 NOT ACTIVE          108475459 09/25/03 01:35:06 
         4 NOT ACTIVE          108475460 09/25/03 01:36:58  
         5 NOT ACTIVE          108475463 09/25/03 02:43:04
         6 NOT ACTIVE          108475461 09/25/03 01:37:10  
         7 FILE NOT FOUND              0 01/01/88 00:00:00
         8 ACTIVE              108475456 09/25/03 00:17:02 
         9 NOT ACTIVE          108474684 09/24/03 23:15:11
        10 ACTIVE              108474673 09/24/03 23:14:59

10 rows selected.

What files are in backup mode? The ones that say "ACTIVE" is my guess, but I've screwed up enough on this already, that I need a sanity check. Also, how do I take the out of backup mode?

Thanks for helping me out on this, I just don't deal with this often enough to be familiar with it.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin

Received on Sun Sep 28 2003 - 10:24:53 CDT