Re: need advise for reporting database setup

Yes, that is possible with cascading standby databases and is pretty wel documented.
See
http://www.oracle.com/au/products/database/maa10gr2multiplestandbybp-1-131937.pdf 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).

Regards,

-- 
Freek D'Hooge
Exitas NV
Senior Oracle DBA
email: freek.dhooge_at_exitas.be
tel +32(03) 443 12 38
http://www.exitas.be 

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

> 



--
http://www.freelists.org/webpage/oracle-l