Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Standby/Replicated database for reporting functionality

Re: Standby/Replicated database for reporting functionality

From: Joe Testa <>
Date: Sat, 03 May 2003 06:46:39 -0800
Message-ID: <>

Logical standby database is beta software at best. I wouldnt recommend it to anyone to use for production purposes(besides all of the limitations it has).


Rajesh Dayal wrote:

>If you move to 9iR2 then Logical Standby Database could be a right fit for you..
>-----Original Message-----
>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.
>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.

Joseph S Testa
Chief Technology Officer
Data Management Consulting
It's all about the "CACHE"

Please see the official ORACLE-L FAQ:
Author: Joe Testa

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Sat May 03 2003 - 09:46:39 CDT

Original text of this message