Re: backup recovery / oracle 10.2.0.4/ backup controlfile

From: joel garry <joel-garry_at_home.com>
Date: Fri, 26 Mar 2010 13:44:03 -0700 (PDT)
Message-ID: <c52f136d-9dc5-45e4-b322-3a91fcc362b6_at_k4g2000prh.googlegroups.com>

On Mar 26, 9:43 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> I need to understand what event/ sequence of events requires the use
> of the ' using backup controlfile' syntax when effecting recovery
>
> I am trying to build my own recovery scenario cases for our specific
> set-up
>
> regards
> Chris B

It's basically a way of telling Oracle that you know better than it what logs are available. For example, if you have a copy of everything from Sunday, including the controlfile, and all the archived logs since then, you can use the syntax to bring it more current than Sunday. Conversely, it is one of the ways to perform recovery to a point in time before, though not necessary (see MOS 94114.1).

As to what sequence of events requires the use of it:

$ oerr ora 1610
01610, 00000, "recovery using the BACKUP CONTROLFILE option must be done"
// *Cause: Either an earlier database recovery session specified BACKUP
// CONTROLFILE, or the control file was recreated with the RESETLOGS
// option, or the control file being used is a backup control file.

//          After that only BACKUP CONTROLFILE recovery is allowed
//          and it must be followed by a log reset at the next

database open.
// *Action: Perform recovery using the BACKUP CONTROFILE option.

There're also some incarnation scenarios, and if you are using a split mirror, see MOS 302615.1.

Also, to belabor the obvious, if you've lost all your controlfiles.

jg

--
_at_home.com is bogus.
http://www.signonsandiego.com/news/2010/mar/26/phony-products-impress-federal-energy-program/

Received on Fri Mar 26 2010 - 15:44:03 CDT