Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot Logs/Triggers
Yep - agree that it's cool, but oh how I wish it were that easy. Thing
is we're transforming data as it flows over to the reporting instance.
RO standby works just find with stasis, obviously ... and I'd be stoked to implement it. Just ain't applicable here. Now, if I could modify the RO standby data, that would be cool ... :-)
Adrian Carlson-Hedges wrote:
>
> 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 - 15:25:42 CST