RE: rman restores control to wrong server
Date: Fri, 21 Feb 2014 09:08:41 -0500
Message-ID: <C1117B1AA0340645894671E09A7891F7156AFAC0BF_at_EIHQEXVM2.ei.local>
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.
:) 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/>
[http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<http://www.entint.com/>
[http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231> [http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg] <http://twitter.com/#!/entint> [http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg] <http://www.linkedin.com/company/18276?trk=tyah> [http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg] <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> [mailto: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.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 21 2014 - 15:08:41 CET