Re: restore accidental deleted data from cold backup

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 Tue Jun 11 2002 - 23:30:03 CDT