Re: cloning instance from box A to box B

Saugato,

That's pretty much the process that we are using with Oracle 7.3.3.5. So far, we have not had any problems. We do this on the same machine as well as on seperate machines. Only problem if you do this on the same machine is that the source db has to be down. I posted a question on this just yesterday as to why the source has to be down and got a couple of very good answers.

hth

mkb

In article <81v03p$4vk1_at_atbhp.corpmel.bhp.com.au>, "Saugato Mukerji" <Mukerji.Saugato.S_at_bhp.com.au> wrote:
> Hi
> I created a new instance on box B with database configuration
> assistant
> shut down the instances on box A and box B.
> copied the control and datafiles from box A to box B into an
> identical
> directory hierarchy
> altered the init.ora on box B to reflect the new control and
> Datafiles
> logged in as internal and started the cloned instance on box B.
> The database came up and i was able to select data from tables in
> the cloned
> database.
> 1. I would like to know if the procedure follwed by me to clone
> the database
> is correct?
> 2. will it always work.?
> 3. is there a better way to clone a database from box A to box B
> both box A and B were running Oracle 8.1.5 on NT4.0 sp5.
> thanks
> Saugato Mukerji

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!