| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle recovery
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_at_Sun.COM 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
> ----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon May 03 2004 - 15:41:17 CDT
 |
 |