If your production database can afford a short downtime. You can copy all
the datafiles and rename the database. We did this way. Refreshed the
database everyday. 15GB database needs 15 min. downtime on the production
database. Depends on your system I guess. Or using hot backup recover to
another machine rename the database. Of course, all those methods are not
real time approach. We don't care a one day delayed data on reporting
purpose.
Thanks,
Joan
-----Original Message-----
Sent: Tuesday, February 06, 2001 9:00 AM
To: Multiple recipients of list ORACLE-L
Tom,
One of the big advantages of a "standby" database is that it can be opened
in the "read only" mode just for the purpose of a report type database.
Be sure to check all of your options before you make the final decision. The
report database and the OLTP database could/should have different INIT.ORA
parameters to have the database operate at peak effeciency.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 02/06/01 07:25AM >>>
How are you all creating reporting databases? We currently have an OLTP
database and we wish to create a reporting database from it. As I see it,
we have the following options:
1. Create the reporting database as a Standby database. I don't think that
this will work since the database must be up and not in standby mode.
2. Use Oracle replication. I have heard it is cumbersome and has trouble
keeping up with lots of transactions.
3. Snapshots/materialized views.
4. Beef up our current machine so that it can handle OLTP transactions and
reports.
5. Since we are using a BMC disk array, we could break the mirror
periodically and mount the disks on a new machine.
6. Other 3rd party replication products.
7. We could probably use some type of import/exports.
How are the rest of you doing it? Are there any other options that I
forgot?
Thanks,
Tom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Thomas
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joan Hsieh
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).
