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. ---------------------------------------------------------------- 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 -----------------------------------------------------------------