RE: Rman duplicate
- From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
- To: <andrey.hudyakov@xxxxxxxxx>, <joe_dba@xxxxxxxxxxx>
- Date: Fri, 23 Apr 2010 10:01:19 +0100
Yep, works a treat, I have done this many times, and its well documented
online if you need examples.
One thing you may need to be aware of though. The most recent database I
duplicated was eventually going to use the same RMAN catalog as the
original for backups. You must therefore set a new Database ID for your
new database or you will not be able to register it in your RMAN catalog
(the DBID must be unique).
Again this is well documented online but basically....
On new database -
1. Shutdown immediate
2. startup mount
3. From OS cmd line run the necessary nid command
4. startup new db
5. register new db with your rman catalog
Did this all just yesterday and both DB's now being backed via RMAN just
fine :-)
HTH
Lee
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of andrey khudyakov
Sent: 23 April 2010 07:34
To: joe_dba@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Rman duplicate
Yes, you can.
Bearing in mind that you duplicate remote host, then there is no
restriction on ORACLE_SID
2010/4/22 Joe Smith <joe_dba@xxxxxxxxxxx>
When you use RMAN to duplicate a database from server A to server B (
i.e. to a remote host ) can you use the same ORACLE_SID?
Thanks
________________________________
The New Busy is not the too busy. Combine all your e-mail accounts with
Hotmail. Get busy.
<http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=P
ID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4>
***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank You.
****************************************************************************
Other related posts:
