Re: RE: Rman duplicate

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Lee.Robertson@xxxxxxxxxx
  • Date: Fri, 23 Apr 2010 08:12:34 -0400

Duplicate, at least since 10gR2 does the change of id for you. My memory is
that it didn't in 9i.

Niall Litchfield

On Apr 23, 2010 5:07 AM, "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>

 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 J




*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 o...

The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally

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:

  • » Re: RE: Rman duplicate - Niall Litchfield