Re: Problems cloning a database/database instance

ohaya wrote:
>
> "Howard J. Rogers" wrote:
> >
> > "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> > news:40cd53ac$0$11521$afc38c87_at_news.optusnet.com.au...
> > >
> > > "ohaya" <ohaya_at_cox.net> wrote in message news:40CD4736.F213987C_at_cox.net...
> > > > Hi,
> > > >
> > > > I'm running Oracle 9i on a Win2K Server, and I've been trying to follow
> > > > a procedure for cloning a database ("TEST") as shown here:
> > > >
> > > > http://www.sap-img.com/oracle-database/cloning-a-oracle-database.htm
> > > >
> >
> > Actually, upon a little further investigation, that site is apparently
> > nothing very much but unattributed rip-offs of all my old material.
> >
> > I should know better, but it is depressing to realise that that which one
> > gave away free to start with is nevertheless capable of being stolen. Now
> > there's a paradox for the age we live in.
> >
> > Regards
> > HJR
>
> Hi Howard,
>
> Do you have a new site, and is there an updated procedure for this?
>
> I'm still having problems getting past "Step 2" (see post after this).
>
> Thanks!

Hi Howard,

Well, I have no idea how, but I was finally able to (kind of) get to the point where I was able to get a cloned instance (CTEST1) working, pointing to files in e:\Cloned\...

I say "kind of" because after all of that thrashing around, I went back to the original/source database/instance (TEST1), and found that instead of it pointing to files in e:\oracle\oradata\..., that original instance was also pointing to e:\Cloned\...

I have no idea why, but I'm going to try to go through this exercise again, from scratch. I think that this problem may've occurred because I ran the new CREATE CONTROLFILE .SQL file when I was connected to the TEST1 database instance :(.

So, if I'm understanding how the cloning procedure you have works (in very simplistic terms):

1. Copy the database files from the source database to some target location
2. Create a set of control files in the target location

At this point, both the source and target databases are "valid", but they both have/use the same database instance, so only one of the databases can be used at a time, and so the source database is shutdown, and the target database is running. So, the next step is to create a new database instance:

• On Windows (which is what I'm on), this means using Oradim
• On Unix, this means setting the ORACLE_SID

Once the new database instance is created, then both the original source database instance and the new database instance can be running at the same time, with the source database instance pointing to the original file locations, and the new database instance pointing to the target location.

Is that about right???

Thanks,
Jim Received on Mon Jun 14 2004 - 23:42:54 CDT