Rachel, Having the same backup problems as talked about in the article, I can agree with the views and opinions of the author. The second part of the article dealt with the placement of the data and type of operation on the data in the same instance. I have mixed emotions about that idea. With the proper horse power and memory and the published features of 9i, why can't the two co-exist happily on the same instance? The 9i features allow for multi database block size and auto tune is provided that should handle the data-mart and OLTP processes quite well. Partitioning is "tunable" by combining it with the LMT, and you can set the size parameters in LMT to make optimal use of the disks. The updating of the data from the current process to the datamart would be fast because the data resides on the same server and the backup procedure would automatically provide the archive data in 2 places, the archivelogs and the original source table. After backup of the warehoused data you could systematically delete the partition and create new ones for the new data. On the other side of the coin, if the server dies nothing at all works. At what price does the cost of the needed horse power and disks out weigh the possible advantages of one instance? The author talked about mirrored drives and splitting the mirrors to perform backups. I would rather use hot backups but I do not know the volume of data activity he was talking about. I do not think it was the datamart data he was talking about. That would be a large amount of data activity to not use hot backups. Could the archivelogs be that large if you use hot backups compared to the archivelogs generated during normal processing and split mirrors?
Just a few thoughts. Good luck with your project, Ron ROR m���m >>> [EMAIL PROTECTED] 05/23/02 03:40PM >>> ron, Even without reading the rest of the article, my first instinct is to scream NOOOOOOOOOOOOOOOOOOOOOO and, after reading the article, it appears the author agrees with me. I have a sane boss. an intelligent boss. He is management, not damagement.... he has the same concerns about what the end user wants and what the consultants say they/we can accomplish in the time we have. Rachel --- Ron Rogers <[EMAIL PROTECTED]> wrote: > Rachel, > This was just received from the "SearchDatabase" email and I thought > it might be of interest to you. > ................. > TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2) > > By William McKnight, SearchCRM Expert > > Another question I received [last week at the Data Warehousing > Institute World Conference] had to do with placement of the data > warehouse and the potential myriad of other databases (staging, data > marts, ODS, etc.) in the data warehouse architecture. The recommended > approach by the questioner's management was to place them all on the > same DBMS instance -- the same instance that the main operational > source system was on... > > Read the rest of this strategy at: > http://www.searchCRM.com/tip/1,289483,sid11_gci825543,00.html > > Read the first part of this strategy at: > http://searchcrm.techtarget.com/tip/1,289483,sid11_gci824982,00.html?FromTaxonomy=/pr/288366 > > > .................... > Ron > ROR m���m > > >>> [EMAIL PROTECTED] 05/23/02 01:43PM >>> > Dennis, > > We are active participants in the process. We are also making an > offer > to someone with an extensive background in developing data > warehouses, > which will help me to sleep much more comfortably at night :) > > Rachel > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > 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). __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
