Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: restore accidental deleted data from cold backup
yeah - cos all those references to 'The Junior DBA' aren't veiled references
to 'The Senior DBA who forgot which system he was logged onto' at all.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:JNDN8.10662$Hj3.34191_at_newsfeeds.bigpond.com...Received on Wed Jun 12 2002 - 04:08:34 CDT
> 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;
> >
>
>