Re: Database Down

Rachel,

I was thinking of this as a current control file vs. backup control file kind of discussion.

In any case, the current controlfile will let you do an incomplete recovery. It's been awhile since I actually worked through all of these exercises, so I can't recall the details of the differences between the 3 different types of controfiles.

The Oracle8i version of the Backup and Recovery Handbook says that the order of preference is current, rebuild from trace file, and backup.

Jared

On Wednesday 23 May 2001 14:50, Rachel Carmichael wrote:
> Jared,
>
> as I understand it, the original controlfile allows you to recover until
> the SCN's all match the one in the controlfile. A backup controlfile
> assumes that you are not certain of what the final SCN is and so allows you
> to continue recovering past the backup time.
>
> I *think* this is the premise behind the standby controlfile. I know that
> you could mimic standby in earlier versions of 7 by doing this.. and just
> recovering until you decided to stop moving archive logs over.
>
> Warning though -- you WILL have to open with resetlogs if you use the
> backup controlfile because Oracle won't be able to tell when it should
> assume recovery is complete.
>
> Rachel
>
>
> From: Jared Still <jkstill_at_cybcon.com>
>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Database Down
> >Date: Wed, 23 May 2001 08:31:50 -0800
> >
> >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).
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com

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