Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Standy DB, Replication

Re: Standy DB, Replication

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 07 Jul 1999 22:52:51 +0800
Message-ID: <378369C3.D66@yahoo.com>


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

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 07 1999 - 09:52:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US