Re: Database instance copying

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 1 Jun 2001 16:17:00 +0100
Message-ID: <991408622.3173.0.nnrp-13.c30bdde2@news.demon.co.uk>

IF you can do it during downtime, the quickest way is a clone (db down, copy db files, recreate controlfile, db up), but I suspect that option isn't available to you from your description...

"Grant Fitzgerald" <gfitzger_at_hotmail.com> wrote in message news:cdf183bb.0106010438.7ff3c875_at_posting.google.com...
> 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 Fri Jun 01 2001 - 10:17:00 CDT