Re: Duplicate Oracle Database

R Lewis wrote:

> Hi All,
>
> I need to do something and I'm looking for any suggestions that you may
> have.
>
> I have 2 Oracle databases that are exactly the same, however both reside
> on
> different servers (eg. server A and server B). What I
> need to do is have all the information from the database on server A copy
> and append itself to the tables, etc. in the database on server B. I
> would like to have this occur on a daily basis.
>
> If anyone can lend any assistance in this matter I would really appreciate
> it.
>
> Thanks

I do the same thing with a couple of my oracle db's, but I use export/import to refresh database "b". depending on what your needs are, this may do for you, or as Daniel suggested, look at replication.

I simply have a timed export run on "A" at a "quiet" time, then run a script that truncates all tables, disables all triggers,constraints in "B", runs the import then re-enables all triggers and constraints in "B".

I havent bothered with incremental exports as the databases I do this with are small enough the export time is not a problem, but this may change.

But you might want to look at creating a standby database(replication), which in a nutshell updates "B" with redo from "A".

HTH Received on Wed Sep 25 2002 - 12:48:17 CDT