Re: rman restores control to wrong server

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 21 Feb 2014 14:25:28 +0000
Message-ID: <CABe10sYJZKrvu0M6D31mtGBYKqY5ET6XWqEE+-VHqrVFrnspBg_at_mail.gmail.com>



I think the fundamental issue is the use of the word "target".

This means something "selected as an object of attention" which makes sense when performing a backup, but when performing a duplicate I would argue doesn't make sense. I'd rather rman had the different syntax

connect source <connection string>
connect destination <connection string>

for intra database activity. too late to change that I imagine.

On Fri, Feb 21, 2014 at 2:08 PM, Patterson, Joel <jpatterson_at_entint.com>wrote:

> One can get happy if not watching what the target actually is. For
> instance if you decide to execute all your commands from the auxiliary
> server, then you could have a tendency to believe that the commands are
> being executed on the auxiliary server.
>
>
>
> rman target sys/<password>_at_<target> auxiliary / trace rman_trace.log
>
> ...
>
> RMAN> duplicate <target> to <destination>;
>
> RMAN> shutdown immediate Shuts down target, ie production.
>
>
>
> J I always liked that behavior.
>
> Need to exit for any shutdown or configuration commands you want executed
> on the destination.
>
>
>
> RMAN> exit
>
> rman target /
>
> RMAN> configure controlfile autobackup on;
>
> RMAN> shutdown immediate <- Shuts down auxiliary, <destination>
>
>
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Chitale, Hemant K
> *Sent:* Thursday, February 20, 2014 11:12 PM
> *To:* howard.latham_at_gmail.com
> *Cc:* ORACLE-L
> *Subject:* RE: rman restores control to wrong server
>
>
>
> A RESTORE uses the "TARGET" connection. So the RESTORE CONTROLFILE uses
> the TARGET (i.e. Production Database)
>
>
>
> A DUPLICATE uses the "AUXILIARY" c onnection.
>
>
>
> Hemant K Chitale
>
>
>
>
>
> --
> *Joel Patterson*
> *Sr. Database Administrator** |* Enterprise Integration
> Phone: 904-928-2790 | Fax: 904-733-4916
> www.entint.com
>
> <http://www.entint.com/>
>
> [image:
> http://www.facebook.com/pages/Enterprise-Integration/212351215444231]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231>
> [image: http://twitter.com/#!/entint] <http://twitter.com/#!/entint> [image:
> http://www.linkedin.com/company/18276?trk=tyah]<http://www.linkedin.com/company/18276?trk=tyah>
> [image: http://www.youtube.com/user/ValueofIT]<http://www.youtube.com/user/ValueofIT>
>
> This message (and any associated files) is intended only for the use
> of the addressee and may contain information that is confidential,
> subject to copyright or constitutes a trade secret. If you are not the
> intended recipient, you are hereby notified that any dissemination,
> copying or distribution of this message, or files associated with this
> message, is strictly prohibited. If you have received this message in
> error, please notify us immediately by replying to the message and
> deleting it from your computer. Messages sent to and from us may be
> monitored. Any views or opinions presented are solely those of the
> author and do not necessarily represent those of the company. [v.1.1]
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Howard Latham
> *Sent:* Friday, February 21, 2014 1:32 AM
> *To:* ORACLE-L
> *Subject:* rman restores control to wrong server
>
>
>
> 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
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 21 2014 - 15:25:28 CET

Original text of this message