Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Standy DB, Replication
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