Oracle-L: RE: Standby/Replicated database for reporting functionality

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sat, 03 May 2003 06:01:37 -0800
Message-ID: <F001.0058EC6E.20030503060137@fatcity.com>

If you move to 9iR2 then Logical Standby Database could be a right fit for you..

Rajesh

-----Original Message-----
Mark
Sent: Friday, May 02, 2003 4:38 PM
To: Multiple recipients of list ORACLE-L

Hello All,

I am looking into options for creating a copy of a production database (Oracle 8.1.7 Enterprise Edition, Windows 2000) for reporting/querying purposes. The database should be hosted on a separate server and the data needs to be as real-time as possible.

The options I've looked into are database replication and a standby database. Custom development of triggers, database links etc is unfortunately not an option.

I've ruled out database replication as the overlying application must create tables via its own management interface and this cannot be integrated with Replication Manager or DBMS_REPCAT.

This leaves me with the standby database option where the database can be in read-only mode throughout the day and managed recovery though the night.

Does anybody know if there are other options available to create a such reporting read-only database or similar. (Read-only is not mandatory but is acceptable as updates to this database are not envisaged)

Are there licensing implications when using a standby database? The production "master" database is licensed under the processor licensing model but the intention is to simply purchase a named user license for the standby "reporting" database as there will be a very limited number of users using this database.
Does anybody know if this is possible/approved by Oracle?

In a nutshell, I am looking to create a real-time copy of my production database as cheaply as possible for reporting purposes only.

If anybody has answers to the above or experience of other methods of replicating a database it would be great to hear from you.

Thanks,
Mark.

This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Patterson, Mark
INET: Mark.Patterson_at_organon.ie

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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.net
--

Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------