Re: hot standby

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Sep 2006 15:56:55 -0700
Message-ID: <1158101811.953690@bubbleator.drizzle.com>

mike7411_at_gmail.com wrote:
> I'm considering various replication solutions for a hot standby.
>
> It looks like Data Guard replicates all transactions and has no
> provisions for specificity. Given this, is it safe to say it is
> inappropriate for a hot standby in a frequent transaction, very low
> bandwidth environment?
>
> Thank you.

No.

But if you are looking to replicate only specific transactions I would suggest CDC (Change Data Capture) provided you are on an Oracle version (you apparently thought version unimportant) that supports Streams.

-- 
Daniel Morgan
Puget Sound Oracle Users Group

Received on Tue Sep 12 2006 - 17:56:55 CDT