Xref: alice comp.databases.oracle.server:56422 Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!dispose.news.demon.net!demon!news-lond.gip.net!news.gsl.net!gip.net!diablo.theplanet.net!news.theplanet.net!newspost.theplanet.net!not-for-mail From: Connor McDonald Newsgroups: comp.databases.oracle.server Subject: Re: Standy DB, Replication Date: Wed, 07 Jul 1999 22:52:51 +0800 Organization: Customer of Planet Online Message-ID: <378369C3.D66@yahoo.com> References: <7m065g$diu$1@violet.singnet.com.sg> Reply-To: connor_mcdonald@yahoo.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news5.svr.pol.co.uk 931384149 14870 62.136.196.161 (7 Jul 1999 21:49:09 GMT) NNTP-Posting-Date: 7 Jul 1999 21:49:09 GMT X-Complaints-To: abuse@theplanet.net X-Mailer: Mozilla 3.01 (Win95; I) To: Joo Wah Lines: 41 Joo Wah wrote: > > Hi, > > We are required to setup an estimated 2 tera byte Db for an online > transaction processing project. > The db has to keep up a high level of service level. (24x7) > Besides there is also large regular back-end processing jobs. > > The problem is that there are also requirements to do a substantial amount > of reporting from the data on this database. > Possibly some large backend and also user reports. > > My peers are suggesting we do replication on the database to a seperate > machine for the reporting. > My feeling is that doing replication on 2 tera of data is quite unthinkable > and I have no experience on > what the performance impact on the db wiil be like. (It could be better off > to let reportingbe done on the db itself). > (We are talking about possibly 3hrs snapshots). > > I was also thinking of setting up a standby database instead and opening it > as only read-only database. > I have read somewhere that 8i can do that but the current version we are on > is 8.0.5 so I'm not sure it can be archieved. > > Anyone has such setup or experience to share ? > I'm open to any suggestions and comments Your info is correct - replication probably won't be able to do it - you can have read-only standby in 8i - you can't in 8.0 and below -- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald@yahoo.com "Some days you're the pigeon, and some days you're the statue."