Re: restore accidental deleted data from cold backup

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 12 Jun 2002 18:58:53 +1000
Message-ID: <JNDN8.10662$Hj3.34191@newsfeeds.bigpond.com>

Ooops, sorry about that !!

I've always believed that the Oracle Documentation set should include a copy of "The Life and Times Of Vladimir the Impaler". A man of somewhat dubious character, he did however come up with excellent techniques on how to treat these misbehaving Developer types :)

Makes my eyes water just thinking about it.

Richard

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:ae6iob01b3c_at_drn.newsguy.com...
> In article <yhzN8.10536$Hj3.33826_at_newsfeeds.bigpond.com>, "Richard says...
> >
> >Hi Ed,
> >
> >No you don't have to restore this large tablespace.
> >
> >On your "clone" or recovered database, you can re-create the controlfile
> >(recommend you base on a 'alter database backup controlfile to trace'
script
> >from the prod database) and simply include only those data files of
> >interest.
> >
> >Perform the point in time recovery and once complete, simply open with
> >resetlogs and export the naughty table.
> >
> >Hope this helps
> >
> >Richard
> >"Ed Wong" <ewong_at_mail.com> wrote in message
> >news:a5ae1554.0206111614.586d1d2_at_posting.google.com...
> >> Hi,
> >>
> >> One of the developers accidentally deleted some data two weeks ago and
> >> we need to restore it. We do cold backup(w/archive) once a week. So
> >> basically we can restore a two-week old copy to a different server and
> >> retreive the data back. We can't restore to the existing database
> >> since we will lose 2 weeks data and we don't want any downtime.
> >>
> >> The database is 300GB and there is one big table 250Gb located in four
> >> partition tablespaces. I DON'T NEED to restore data from this big
> >> table. My question is: Can I simply restore the remaining 50GB
> >> datafiles? I understand that Oracle won't open if some files are
> >> missing. But can I have Oracle logically drop the 250GB
> >> tablespace/datafiles after "startup mount" and before "database open"?
> >> Anyone has experience?
> >>
> >> Thanks,
> >> ewong
> >
> >

>
> Richard's advice is correct in all but one area. He left out the final
step -
> kill the developer! ;)

>

> HTH. Additions and corrections welcome.

>

> Pete

>

> SELECT standard_disclaimer, witty_remark FROM company_requirements;
> Received on Wed Jun 12 2002 - 03:58:53 CDT