Re: Snapshot Logs/Triggers

From: Adrian Carlson-Hedges <adrian.ch_at_btinternet.com>
Date: Tue, 27 Nov 2001 17:53:21 -0000
Message-ID: <9u0jtn$k67$1@plutonium.btinternet.com>

A Cool way of going this is to have a hot standby database as your reporting database.

Basicly, the reporting database is permantly in recovery mode with the archive logs from the main database being applied to it.

Adrian

"Casey Dyke" <cdyke_at_froggy.com.au> wrote in message news:3C0376E1.5F45A52_at_froggy.com.au...
> Folks,
>
> Am curious to know what setup others may have employed when trying to
> shift incremental data (ie: only that that has changed) from one
> instance to the next (prod --> reporting). Snapshot logs or triggers
> quite easily facilitate this, but come at a cost. Has anyone avoided
> them due to said cost and, if so, how'd you dig out?
>
> :-)
Received on Tue Nov 27 2001 - 11:53:21 CST