Re: need advise for reporting database setup

From: Freek D'Hooge <>
Date: Fri, 19 Jun 2015 09:57:39 +0200
Message-ID: <1434700659.22365.9.camel_at_dhoogfr-lpt1>


Yes, that is possible with cascading standby databases and is pretty wel documented.
See for an example.

Depending on your situation, you will need to decide if the logical should always be receiving its redo from the database with the standby role or if it should be a fixed database (regardless of its role).


Freek D'Hooge
Exitas NV
Senior Oracle DBA
tel +32(03) 443 12 38 

On vr, 2015-06-19 at 08:52 +0530, nilesh kumar wrote:

> Hello gurus,
> we have the following
> 1. primary prod server ( oracle version 10g and OS : Linux)
> we have received a request to configure the physical standby , and on
> another server they want a database which should be used for reporting
> purpose,
> so that once in a week the application team can extract reports. ( But
> it should be a logical standby which receives the redo data from
> physical standby server and not from the
> primary server and gets recovered)
> we can setup the physical standby and logical standby for the
> primary.
> But will it be possible to set up a logical standby to receive a redo
> data from physical and not from primary server and gets recovered.
> Please advise if we have any other alternative.
> Thanks
> Kumar
Received on Fri Jun 19 2015 - 09:57:39 CEST

Original text of this message