| 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 recall a paper from Oracle (about 5 years ago) that analyzed
the various outages, the methods of recovery and how long they
took. I have it at home and I'll see if I can get a doc_id from
it.
The point I would make with the DBA is that exports are not a recovery mechanism, they are only able to restore to a given point (time of the export) and they do not restore everything (sys objects). With an export, there is no way to roll-forward. Of course, a cold backup w/out archive logs is also unable to roll-forward. All data from the last export and the current time is lost period end of story. Is this acceptable? Perhaps. In certain environments where data loss is not a problem, exports are a pretty simple way of capturing a snapshot of the data. It is also not just 'data' that is lost. It is anything stored inside the db, including procedures, packages, etc. In a development environment, a days worth of coding could easily run into the 10s of 1000s of dollars.
Daniel
"M.Godlewski" wrote:
>
> Believe it or not the database I'm currently using the DBA is forcing us to use exports as our applications recovery scenario. I'm trying to locate information about archive logging and the tablespace point in time recovery versus full database recovery. I wanted to find some kind of percentages about the number of databases that need full database recovery (ie applying all archive logs) and percentages of databases that only needed TSPIR.
>
> I thinking if I can get some type of failure rate it could help sway him into using archive log mode which would give us better recovery options.
-- 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 - 14:47:18 CDT
 |
 |