RE: Easy way to copy databases when using RMAN?

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 6 May 2004 14:12:23 -0400
Message-ID: <004c01c43395$ae1434c0$8459699f@vttaxnet.tax.state.vt.us>

NID is an Oracle utility that allows you to change a database name and/or DBID. Check the docs.

Ruth

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ravi Kulkarni   Sent: Thursday, May 06, 2004 1:54 PM
  To: oracle-l_at_freelists.org
  Subject: RE: Easy way to copy databases when using RMAN?

What is NID ? We didn't have to use it during RMAN Duplicates.

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ruth Gramolini   Sent: Thursday, May 06, 2004 12:44 PM
  To: oracle-l_at_freelists.org
  Subject: RE: Easy way to copy databases when using RMAN?

I duplicate the target to the auxiliary of a different name then I use NID to change the dbid. I will check to see if I can really avoid using NID the next time I duplicate my database.

Ruth

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bricklen Anderson     Sent: Thursday, May 06, 2004 12:54 PM     To: oracle-l_at_freelists.org
    Subject: Re: Easy way to copy databases when using RMAN?

Hand, Michael T wrote:

> The following is from 8/8i. Don't know of things have
  changed in 9i and
> have no database to test against.

    <snip>
    Like Ruth mentioned, the NID utility can change both the db name and     dbid --> 9i only though. It is simple to use.     In a pinch, you can tar and move a db + related software to a new box     and use nid to rename/re-id it, then rman can be used successfully etc.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a9665 2/ch14.htm

  --
  Bricklen Anderson, Database Administrator   PresiNET Systems
  http://www.PresiNET.com
  Online Demo: https://www.presinet.com/secure/login

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. --
Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 06 2004 - 13:19:04 CDT