We are on Oracle 11g, looking to go to 12g on AIX. We do dataguard replication (shipping logs frequently to remote site) - I vaguely remember to DBA, saying either 11g or dataguard has feature that allows the Db to remain in standby read-only mode; so based on how often you replicate (shipping logs and appying logs), you could report from the standby/Dr DB.
On AIX -- database replication, is SRDF (Symmetrix Remote Data Facility) which is done on storage, more costly base on the size of storage needed; the lag between the srdf ans dataguard was sec; but we didnot go this route because out overall DR failover process didnot gain in terms of outage and time. What SRDF - doesnot give you ability to run reports (readonly) from a standby. On AIX -- Replication is DR HA SRDF, DR High Availability Symmetrix Remote Data Facility; but this is costly. I think more of reduce outage to invoke DR for companies need the application always up; in event of unplanned DR. but again, doesnot give you ability to run reports (readonly) from a standby. We have other applications that run DB2. ( however, for reporting of standby not sure .... ) - On Linux in VM Farm -- HADR - "DB2 high availability disaster recovery (HADR) feature provides a high availability solution for both partial and complete site failures. " - On Linux in VM Farm -- Storage level replication - Recovery Point (we are currently testing) Best of luck, Hopefully -- this helps in your research. -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/AR-System-Database-Replication-tp121363p121405.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"