Re: Standby/Replicated database for reporting functionality

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

joe

Rajesh Dayal wrote:

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

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

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