Re: What do you do when someone drops a bunch of datafiles ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 6 Nov 2002 17:02:16 +1000
Message-ID: <W22y9.70169$g9.199443@newsfeeds.bigpond.com>

Hi Scott,

What I would do if someone somehow managed to delete a bunch of datafiles would be to restore them from backup and fully recover them.

Cheers

Richard
"Scott W" <CantGiveMyAddressBecauseIm_at_work.com> wrote in message news:C_.cnSa1.8Fwv1WgXTWQlg_at_News.GigaNews.Com...
> Besides strangle them :). Scenario: someone deletes a bunch of datafiles
and
> you can't bring up Oracle, and you end up doing an alter database datafile
> 'datafilename' offline drop, one datafile at a time until it comes up... I
> have spent the last two hours doing this to an 9.2 instance trying to
bring
> it back up. Is there any way to drop all missing datafiles at once so you
> don't have to go through this pain ? Or at least get a listing of them so
I
> can create a SQL script ?
>
> Thanks, Scott
>
> PS, this is not a prod environment, but a dev environment, thus many
people
> are in the dba group. This kind of thing is a cost of doing business, and
> thankfully it doesn't happen often.
>
>
>
Received on Wed Nov 06 2002 - 01:02:16 CST