Re: Recover a table from cold backup-noarchivelog

Ruth,

Way back when I was a newbie and we had this Oracle consultant on site (Some 
people call him ... Tim), we had a developer (very
sharp and normally very careful) drop a table in production. As we were trying 
to figure out how to recover it with a minimum of
downtime (well, Tim and another consultant were trying to figure it out, I was 
standing by with a very perplexed and anxious look),
I asked the type of question that only a newbie asks, the type that run counter 
to common sense and normal practice, you know, the
moron type. It was something to the effect of "Can we open the online backup as 
a separate database, recover it to the time the
table was dropped and then export the data from the table?" Lacking other 
options (I think it was a 7.1 db), we decided to give it a
shot. No docs, no notes, just hack away and see what we can accomplish. It took 
a couple of tries to get the right tablespaces
recovered (we tried to minimize the recovery needs), but it worked. I think we 
were able to accomplish this from panic to beers in
about 4 hours. The production database was in full use (except for one app) the 
whole time.

Tim poked around the Oracle notes/papers and found several papers that 
addressed each part of what we accomplished, but nothing that
described it in its entirety. IIRC, this was my *first* ever recovery and the 
first time Tim had done this type of object-level
recovery from an online backup.

Dan

Ruth Gramolini wrote:
> Dan,
> 
> Great post!  I never even thought of this, but it should work as advertised.
> It is sure worth a try as long as you backup the current version of the DB
> first.
> 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: