Re: Database instance copying

You could try Oracle's Standby database feature. The standby database is in continuous recovery mode, applying the redo log archives from the live database.

I'm not sure how it works yet, but we are looking at doing something like that.

Cheers,
John Blackburn.

Grant Fitzgerald wrote:

> Hi,
>
> I currently have a system which has two C-ISAM databases - one which
> is updateable by users and one (the live DB) which is read-only. The
> system's application programs only access the read-only DB so that the
> users can't interfere with the live DB. The users make changes to the
> updateable one and, when changes are complete, a new read-only
> database is created by copying the new data into it (overwriting what
> was previously there).
>
> I am currently in the process of investigating how the ISAM database
> can be replaced by Oracle and would really appreciate some advice
> about the best way to copy data between two DB instances. The options
> I have thought about so far are:
>
> - full export/import (performance issues?)
>
> - 8i's transportable tablespaces
>
> - Snapshot replication
>
> What are the pros/cons of each of these? Is there another option I
> should be looking at? If anyone has any advice I'd be glad to hear it.
>
> Thanks in advance,
> Grant
Received on Sun Jun 03 2001 - 23:07:00 CDT