Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Cloning gurus.

Re: Cloning gurus.

From: zhu chao <zhuchao_at_gmail.com>
Date: Fri, 24 Sep 2004 22:03:36 +0800
Message-ID: <962cf44b0409240703143347c2@mail.gmail.com>


just recreate the controlfile with set dbname won't change the dbid.

On Fri, 24 Sep 2004 08:56:44 -0400, nelson.petersen_at_homehardware.ca <nelson.petersen_at_homehardware.ca> wrote:
> You might want to add the following at the end of your cloning process.
>
> 'alter database rename global_name to new_name.domain_name;'
>
> (SELECT * FROM GLOBAL_NAME; to see the current value.)
>
> Regards,
> Nelson Petersen
>
>
>
>
> -----Original Message-----
> From: Ganesh Raja [mailto:ganesh.raja_at_gmail.com]
> Sent: Thursday, September 23, 2004 7:00 PM
> To: bspears_at_limitedbrands.com
> Cc: oracle-l_at_freelists.org
> Subject: Re: Cloning gurus.
>
> All the datafiles also have a DBID on them that gets Reset when the
> Controlfile is Recreated with set Database Name Call.
>
> HTH
>
> Cheers
> Ganesh R
>
> On Thu, 23 Sep 2004 16:46:42 -0400, Spears, Brian
> <bspears_at_limitedbrands.com> wrote:
> > I checked and only the controlfiles have the db name... And I am
> guessing
> > these get the newnames on the new clone?
> >
> > Brian
> >
> >
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 24 2004 - 09:05:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US