Re: Oracle Database Replication

From: <catatony_at_my-deja.com>
Date: 2000/05/02
Message-ID: <8emt7d$8e2$1@nnrp1.deja.com>#1/1

In article <956659755.3881.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>
> Tony Pich <apich_at_viviance.com> schreef in berichtnieuws
> 8e3qos$nl2$1_at_diana.bcn.ttd.net...
> > Hi:
> >
> > I have an Oracle 8.0.5 running and with several tables created.
 Now, I
> > have installed Oracle 8.0.5 on a different machine and I'd like to
 know
 how
> > can migrate the old database to the new one so they are exactly the
 same.
> >
> > Thanks a milion,
> >
> > --
> >
> > Tony Pich
> >
> >
> >
> 1 in svrmgr
> alter database backup controlfile to trace.
> This will produce a trace file in the user_dump_dest directory.
> 2 shut the source database
> 3 backup the source database
> 4 copy all files to the new database (including init.ora and
 controlfiles)
> 5 copy the trace file when necessary edit it to change file names.
> 6 startup svrmgr and run the trace file as a sql script.
> 7 shut the target database and make a backup
>
> This should be all...
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>

Sybrand,

I use a method similar to the one you list above to create clones of my production database for use as test databases, and have had no problems. Now, however, we are changing our backup procedures and are using RMAN to catalog backups to provide better/quicker recoverability. We would like to test RMAN on a database clone to verify our procedures, but we cannot do so if both the production and test databases are registered in RMAN. This is because the "clone" method duplicates the DBID of the production database in the test database, and RMAN uses DBID alone to identify databases. As a result, any actions taken by RMAN on the test database will also be performed in production. Not a good situation.

My understanding is that the only way to generate a DBID for a database is to issue a "create database" statement. No such statement is issued during cloning. Do you know of any way to recreate DBIDs during cloning, for example by issuing a "create database" statment at some point?

I do have other options:
1) REGISTER/UNREGISTER

• unregister the production database in RMAN
• test RMAN procedures with the cloned database
• register production, unregister clone
• implement tested RMAN procuedures 2) DATABASE EXPORT/IMPORT

Both these alternatives are somewhat painful. A way to generate new DBIDs would be so much easier. Any ideas?

Thanks,
Tony Catania

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 02 2000 - 00:00:00 CDT