Re: Questions about cloning an instance

"Greg Akins" <insomnia_at_cvzoom.net> wrote in message news:3ac34b02_3_at_corp.newsfeeds.com...
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3ac3387b_at_news.iprimus.com.au...
> >
> > Hi Greg,
> >
> > I honestly don't see the need to guess at all!
>
> You're right, I'm still stuck in the create database and import prod data.
> But It's becoming much more clear now, what I'm doing.
>
> <... snip...>
>
> > That gets you a clone with the same database name and Instance name as
 the
> > (currently shutdown) primary. To be able to open the primary, you'll
 need
> > to change the Instance name of the clone (which is done by starting it
 up
> > having previously changed the ORACLE_SID environment parameter).
>
> <..snip...>
>
> The database will be in Win2K, so I think I have to use Oradim rather than
> just changing the environment variables?

Ah, true. Quite an important bit of info, the O/S!!

> But as you noted, it's a different
> box, so I can leave the SID and databasename the same (tnsnames.ora can
> distinguish between the SID on BoxA, from SID on BoxB right?).
>

I doubt it (it's 7am, so I can't be more definitive!!!). You'll be wanting to configure Listeners and so on -sounds like a candidate for an Instance name change to me.

Regards
HJR
> Again, I appreciate all the help.
>
> -greg
>
>
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Thu Mar 29 2001 - 14:55:32 CST