RE: Easy way to copy databases when using RMAN?

My experience has been that you have to run the NID utiltiy to change the
DBID.

Ruth

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
  k.sriramkumar@xxxxxxxxxxxxxxxxxx
  Sent: Thursday, May 06, 2004 10:17 AM
  To: oracle-l@xxxxxxxxxxxxx
  Subject: RE: Easy way to copy databases when using RMAN?


  Hi Wolfson,

  9i RMAN can help you to clone the database using duplicate target
  database. It will take care of resetting the DBID too. Not sure
  this is what you are looking for. I have used a couple of times
  and it worked fine.

  Best Regards

  Sriram Kumar

        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Wolfson
  Larry - lwolfs
        Sent: Thu 5/6/2004 11:33 AM
        To: 'oracle-l@xxxxxxxxxxxxx'
        Cc:
        Subject: RE: Easy way to copy databases when using RMAN?



        Thanks for info Ken.

                Any idea on my original RMAN clones?

        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx
        [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ken Naim
        Sent: Thursday, May 06, 2004 12:41 AM
        To: 'oracle-l@xxxxxxxxxxxxx'
        Subject: RE: Easy way to copy databases when using RMAN?


        The Oracle 8i install on Solaris does hard code some of the
  os path's into
        some of the binaries (particularly java related ones) and
  the database will
        work fine assuming everything is soft linked properly until
  you need to
        apply a patch or upgrade the system. T universal installer
  had issues even
        though the orainventory was identical to the other server.
  I had to install
        the software and only then I could apply patches. I haven't
  tried this with
        9i but IMHO I'd avoid it. I hear 10g will allow cloning of
  an installation
        onto the grid.

        Ken Naim

        -----Original Message-----
        From: Wolfson Larry - lwolfs [mailto:lawrence.wolfson@xxxxxxxxxx]
        Sent: Thursday, May 06, 2004 1:21 AM
        To: 'oracle-l@xxxxxxxxxxxxx'
        Subject: Re: Easy way to copy databases when using RMAN?

        I don't need RMAN, client is insisting on it.

                I thought the "RESETLOGS" just reset the redo counter.

                I'd swear we did that with another database and RMAN got all
        confused about what DBID the archives belonged to.

                And now that you mentioned it Mladen, can I take my
  9i install, tar
        it up and copy it to another server?  Apply some soft links
  and do a relink
        all instead of multiple installs?
                This particular client has all SUN servers.

                Thanks
                Larry

        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx
        [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mladen Gogala
        Sent: Wednesday, May 05, 2004 11:47 PM
        To: oracle-l@xxxxxxxxxxxxx
        Subject: [SPAM] Re: Easy way to copy databases when using RMAN?


        Actually, why do you need rman? If you use the the cloning tool
        known as "cp" or "scp", if the clone needs to be on another node,
        you can get the desired result with a FS-based database. The DBID
        problem is solved by opening the database with the
  "RESETLOGS" option.
        Once you issue "alter database open resetlogs" command, your old
        DBID is gone and, technically speaking, you have a new database.


        On 05/06/2004 12:37:28 AM, Wolfson Larry - lwolfs wrote:
        > Hi, guys!
        >         I I've got a number of servers to create multiple
  9i databases.
        >
        >         Is it possible to just create one system
  tablespace and just copy
        it
        > multiple times?
        --
        Mladen Gogala
        Oracle DBA
        ----------------------------------------------------------------
        Please see the official ORACLE-L FAQ: http://www.orafaq.com
        ----------------------------------------------------------------
        To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
        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
        -----------------------------------------------------------------



  **********************************************************************
        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 re-send this communication to the sender and
        delete the original message or any copy of it from your
        computer system. Thank You.

        ----------------------------------------------------------------
        Please see the official ORACLE-L FAQ: http://www.orafaq.com
        ----------------------------------------------------------------
        To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
        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@xxxxxxxxxxxxx
        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@xxxxxxxxxxxxx
        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
        -----------------------------------------------------------------


  -- Binary/unsupported file stripped by Ecartis --
  -- Type: application/ms-tnef
  -- File: winmail.dat


  ----------------------------------------------------------------
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  ----------------------------------------------------------------
  To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
  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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: