Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Cloning gurus.
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-lReceived on Fri Sep 24 2004 - 09:05:29 CDT
![]() |
![]() |