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

Stan Brown wrote:

> 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 tried replying to your emails, but every time I got a 'yahoo is not a trusted emailing source, and your email has thus been blocked' reply.

>
> 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.
>
> 1. 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?

Alter database datafile 7 offline drop;

>
> 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?

Yes, files 1, 8 and 10 are still in hot backup mode.

Alter database datafile 1 end backup;
Alter database datafile 8 end backup;
Alter database datafile 10 end backup;

Regards
HJR
>
> Thanks for helping me out on this, I just don't deal with this often
> enough to be familiar with it.
>
Received on Sun Sep 28 2003 - 16:09:29 CDT