Re: Oracle recovery
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 03 May 2004 14:43:34 -0600
I'll never forget it. We pulled a rabbit out of the hat in saving a single
table dropped from production by a careless developer on a moment's notice,
then went out for beers and got hammered in celebration. Returned to the
office to find another outage in progress. At least it didn't hurt so much
the second time...
The 9iRMAN command to DUPLICATE TARGET DATABASE ... EXCLUDING TABLESPACES
really helps simplify this task now...
on 5/3/04 2:13 PM, Daniel Fink at Daniel.Fink@xxxxxxx wrote:
> You can do object-level recovery from a backup. The advantage
> with this is that you can get the object as of a point in time,
> e.g. immediately before the table was dropped. The downside is
> that you need someplace to create and recover the database. It
> can be done (remember that Friday, Tim?) and the beers
> afterwards taste all the more cool and refreshing.
>
> Daniel
>
> "Smith, Ron L." wrote:
>>
>> We do full exports on all databases at least once a day for table level
>> recovery if needed. We also do daily hot backups for point in time
>> recovery. I feel there is a need for both.
>>
>> Ron Smith
> ----------------------------------------------------------------
> 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 //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
