Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Question of degrees in Oracle DB recovery
Practice recoveries are a must. Do not believe the reports that a tape
was written to successfully. At my last employer the development server
was backed up nightly using the OS dd> commands. A disk failed and a
restore was attempted from the tape backups. The tape drive was
defective and no tape was usable for a 2 month period. A lesson
learned... practice restore procedures. It verifies your ability and the
validity of the backup.
Ron
>>> Daniel.Fink_at_Sun.COM 06/29/2004 12:37:31 PM >>> I don't recall if this is an exact quote from Tim Gorman or Gary Dodge, but the essence is
"The job of the dba is not to backup the database, but recover the database."
If you use this approach, you will be focusing on the right issues and performing the right tasks (like performing test recoveries).
Regards,
Daniel Fink
DENNIS WILLIAMS wrote:
> Stephen
> You are getting some excellent responses. I don't see where the
following
> point was mentioned (forgive me if I have overlooked it)
> - A backup practice can't be trusted unless you've tested it with
an
> actual recovery.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> I said it "looked" clear - Riddick
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org 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 -----------------------------------------------------------------Received on Wed Jun 30 2004 - 07:10:53 CDT