Hi Listers,
I'm about producing document to my boss about different strategies to build Informational database (reporting database) and ETL. Our production database is 9i supporting Oracle Financials 11i.
I'm concerned about the strategies that have a minimum impact on the overload of production database.
Could you please give me your advise and experience. Any input well be very appreciated.
Hi Kader,
What do you mean with ETL? Is your reporting database a DWH, and are you considering unload from production and ETL into it? Or do you just need an exact copy of your production database? What frequency should it be updated? Daily, Weekly, real-time?
For some of these options Data Guard might be a solution, for others not.
For a daily update you can create a (physical) standby database and put it in read-only mode. You can query along, transactions get forwarded but not processed in the meantime. Every midnight, for instance, you switch the standby from R/O to Managed Recovery mode, and it will 'synchronise' using the redologs received since the last synchronisation. After synchronisation put it back into R/O mode, and you can query all day long. During synchronisation the database isn't available for reporting. Data Guard comes for free with your Oracle Licence. However, as discussed in an earlier thread on this list, you have to pay for the standby server, unless , AFAIK, you're paying according to the named-user-plus model.
It will give you the lowest possible overhead on your production database, except from using non-oracle storage level options like mirroring disks and detach them every n hours.
Regards, Carel-Jan
-- There will allwasy be another 10 last bugs --
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
