Re: Is it possible to recover just one datafile/tablespace "until cancel"?

If all you lost were archived redo logs, you should not have had to do much , I think.

Not sure what you did first, but the correct course of action might have been real simple. Of course, once you do 1 wrong command, the correct command may no longer work. Good reason to do a cold backup before doing any recovery.

I once had a database crash in the middle of a hot backup. It looked like I needed to do some kind of recover.

But, I think (been a while - doing this from poor memory) all I had to do was 'recover database' . Basically, because the datafiles were in "begin backup" mode, Oracle needed the current REDO log just to "sync" things up and take the datafiles out of backup mode.

-- 
"Stan Brown" <stanb_at_panix.com> wrote in message
news:blc151$jg0$2_at_reader2.panix.com...


> In <255db8b61d67e8c3b996027a907cc6dd.20305_at_mygate.mailgate.org> "Thomas

Schwickert" <schwickert_at_yahoo.com> writes:


>

> >"Stan Brown" <stanb_at_panix.com> wrote in message

> >news:blbst1$i45$1_at_reader2.panix.com

>

>

> >what's your catastrophe ? Dropped Table ? Deleted Rows ?

>

> Lost a disk. The disk (the only non mirroerd one in they system) had

_only_


> archivelogs on it. Howeer, it happened in the middle of a hot backyp. So

> when I tried to start up the instance it said it needed media recovery. Of

> course I did not have all the erchivelogs. I guess the rest of the problem

> is caused by my fumbling around.

>

>

>

>

> >-- 

> >Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

> -- 

> "They that would give up essential liberty for temporary safety deserve

> neither liberty nor safety."

> -- Benjamin Franklin