Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Down

Re: Database Down

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 23 May 2001 08:54:22 -0700
Message-ID: <F001.0030C0F3.20010523083149@fatcity.com>

On Wednesday 23 May 2001 01:00, Paul Drake wrote:
>
> 0. caffeine.

Agreed.

> 2. You *will* be performing incomplete recovery. Recover until cancel,
> preferably with a backup controlfile.
> Did you create a backup controlfile as part of the hot backup on May
> 11th? Restore with that controlfile.

Is there a particular reason for recommending the backup controlfile?

Shouldn't be needed unless the controlfile has been lost.

> 3. After the recovery is completed (you've opened RESETLOGS) close the
> database and get a *full* cold backup. Fight the urge to *get the

Some repetition for emphasis here. As Paul says, a cold backup must be completed before any work is done on the database.

Some add'l advice for Laura. Read Rama Velpuri's book 'Oracle Backup and Recovery Handbook' cover to cover, and do all of the exercises. It will make an immense difference in your understanding of recovery.

Backup is easy, recovery is not always so.

Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed May 23 2001 - 10:54:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US