RE: Reporting database

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

>>> Thomas.Terrian_at_standardregister.com 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: Thomas.Terrian_at_standardregister.com

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: ListGuru_at_fatcity.com (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: RROGERS_at_galottery.org

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: ListGuru_at_fatcity.com (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: Joan.Hsieh_at_mirror-image.com

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: ListGuru_at_fatcity.com (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).