Re: rman restores control to wrong server

From: Stojan Veselinovski <stojan.veselinovski_at_gmail.com>
Date: Fri, 21 Feb 2014 08:34:08 +1100
Message-ID: <CALn1tDup+x-YszrvDAzdNC6JeDdfptKfgGLQNqnWCYoCmOT4ag_at_mail.gmail.com>



Hi Howard,

Yes, its restoring to the primary as the target you are connected to is the primary. You don't need to restore the controlfile that way as the duplicate database for standby restores a standby controlfile and hence mounts a standby database.

Regards,

On Fri, Feb 21, 2014 at 4:31 AM, Howard Latham <howard.latham_at_gmail.com>wrote:

> Oracle 11.2
> Redhat 5
>
>
>
> I've been using the same procedure to create a standby for years yet now I
> find the rman restore controlfile command on the new standby server are
> writing to the primary server
> Ive even tried settng the aux and target in the recovery script.
>
>
>
> set oracle sid to sid of new standby.
>
>
>
> connect auxiliary sys/pass
> connect target sys/easy_at_primary
> restore controlfile to '/data/oradata/tripstby/ctl1.ctl'; <=======
> writes to old server
>
>
> duplicate target for standby;
>
>
> Any suggestions?
> On reading back this I think its because its restoring to the primary?
> A couple of agrees would convince me ! :-)
>
>
>
>
> --
> Howard A. Latham
>
>
>

-- 
Stojan
www.stojanveselinovski.com/blog

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 20 2014 - 22:34:08 CET

Original text of this message