RE: Database Down

My database is up and with no data loss!!!  I was able to do a complete recovery, not incomplete.

After the coca-cola (for caffeine) to calm my nerves I had the sysadmin restore the datafiles and archive logs from the hot backup from Friday.  The control files 1 and 2 were restored because they were on the corrupted disks, but I had a 3rd copy which I used to recover the database.  It worked just like Case 4 and all is well.

Just a note, I am glad I had another copy of the control file.  When I tried to use the file that had been restored I received an 'old controlfile' error. 

I do have the Backup and Recovery book by Rama Velpuri (v7.3) and it helped.  This is one of those things I have wanted to do but have never had time to do...  It has been about 3 years since I took the class and the 'use it or lose it' scenario has taken over.

Thanks to all who replied!!

Laura

-----Original Message-----
From: Jared Still [mailto:jkstill_at_cybcon.com] Sent: Wednesday, May 23, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Database Down

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