Re: Recreate standby controlfile for DB that uses OMF and ASM

From: Don Seiler <don_at_seiler.us>
Date: Thu, 20 May 2010 16:54:21 -0500
Message-ID: <AANLkTinjFGzy0JR38yGsmKhpYeuR4_S0nilE-b0UNfZc_at_mail.gmail.com>

Just want to chime in that Note 734862.1 saved me a lot of time and trouble today! So glad I wasn't the first to have this problem.

Don.

On Fri, Jan 8, 2010 at 2:13 PM, Yong Huang <yong321_at_yahoo.com> wrote:
> Fairlie is absolutely correct! I opened an SR. The analyst told me to
> follow Note:734862.1 (Step By Step Guide On How To Recreate Standby
> Control File When Datafiles Are On ASM And Using Oracle Managed
> Files). It's easier done than said.
>
> Basically, after I restore the newly created standby controlfile, I
> need to
>
> catalog start with '[first part of the ASM OMF path on standby]';
> switch database to copy;
>
> I guess the key to understanding this is that the datafiles on the
> standby are treated as datafile image copies. In this context, they
> are, because they were created as such by the duplicate command
> when the standby was initially created. Once they're catalog'ed, the
> switch command magically matches each old name with a new name.
>
> All is well now. Thanks.
>
> Yong Huang
>

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 20 2010 - 16:54:21 CDT