Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Candidate for replication?
On 4 Oct 2001 23:57:58 -0700, pagesflames_at_usa.net (Dusan Bolek) wrote:
>staryeti_at_bellsouth.net wrote in message news:<3bbccb01.27717545_at_news1.lig.bellsouth.net>...
>> I've got a project that will require making a
>> read-only copy of our production database available
>> to a new web-based system. The production database
>> is Oracle8 (soon to be 8i); it consists of about
>> 40 reference tables, which would tend to be fairly static,
>> and about 60 data tables, about 30 of which would be
>> used by the new web app, and which would be updated
>> often. If I understand replication (snapshots) correctly, the
>> replication is done on a table-by-table basis (I have to write a
>> scripts for each table).
>>
>> Is this situation a good candidate for replication, or should I just
>> create an automatic process to export from the production db each
>> night and import a fresh copy into the read-only db daily? How
>> fast would the replication scripts run once the initial copy is set up
>> (i.e., is speed a consideration with this number of tables)?
>
>That depends on your needs. If your site is not 24/7 and read-only
>copy of your database can contains one day old data, then running
>exp/imp by scripts each night within backup window can be a good idea.
>It will be simple to build and maintain. If you need exact copy
>through the day, you can use replication or stand-by database.
>
>--
The read-only db doesn't need to be real-time - right now it looks like a once-a-day snapshot would be fine. That could change down the road, maybe 6-12 months, though. At some point, the time spent doing the export/import could be a factor - it's not a 24/7, but it will be something like an 18/6.
Thanks,
Harry
Received on Fri Oct 05 2001 - 09:48:09 CDT