Re: Is this replication?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 14 Oct 1999 23:45:48 +0200
Message-ID: <939937561.26442.0.pluto.d4ee154e@news.demon.nl>

Yes you can, however you would be better off by implementing a standby database. Just the same like you want to do, only Oracle takes care of it.

Hth,

--
Sybrand Bakker, Oracle DBA
Kenny <karosenb_at_erols.com> wrote in message news:38064798.E2A733FE_at_erols.com...
>
>
> Hey Everyone,
>
> Oracle Version 8.1.5
> Sun Solaris 2.6
> Production DB size 2GIG and growing rapidly
>
> I have been asked to replicate our production database every night into
our QA
> database. I wasnt sure the best way to go about this. Here is my simple
plan,
> can some of you give me advs/disadvs of the idea.
>
> Production is in archivelog mode. I plan to create the QA database
> architecture very similarly, tables, views, indexes, etc...but this QA db
will
> be in a constant state of recovery, always applying productions
archivelogs....
>
> This seems like a simple plan, but is there any information in the
archivelogs
> that specifies db_name or anything like that. I guess my question is,
can I
> apply redo logs to a different database that the one they originally came
from?
>
> THanks in advance
> -Kenny
>
>
>
Received on Thu Oct 14 1999 - 16:45:48 CDT