Re: rman restores control to wrong server
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
- Date: Fri, 21 Feb 2014 14:25:28 +0000
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@xxxxxxxxxx>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>@<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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Chitale, Hemant K
> *Sent:* Thursday, February 20, 2014 11:12 PM
> *To:* howard.latham@xxxxxxxxx
> *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@xxxxxxxxxxxxx [
> mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] *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@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
Other related posts:
