RE: Standby/Replicated database for reporting functionality

And if I may add to Walt's comment, Robert's RMAN book has a chapter that details how to do this. Well worth the price. http://www.amazon.com/exec/obidos/tg/detail/-/0072226625/qid=1051900621/sr=8 -1/ref=sr_8_1/103-8251541-9142223?v=glance&s=books&n=507846

Dennis Williams
DBA, 60%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, May 02, 2003 11:42 AM
To: Multiple recipients of list ORACLE-L

You can also use RMAN to create/maintain the standby database for you. Makes it a not-quite-as-manual process, or at least reduces the amount of scripting/plagiarizing you need to do.

--Walt Weaver
  Bozeman, Montana

> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> Sent: Friday, May 02, 2003 8:42 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Standby/Replicated database for reporting functionality
>
>
> I believe that the licensing as you described it will cover
> you. You do
> need a license for the separate standby database.
>
> That I know of, a "home-grown" automation of a standby database is the
> cheapest way to go. And it's not terribly complicated at all
> to set up,
> especially since you say you are willing to do recovery only at night.
>
> A rough draft of the steps (I may miss some but....)
>
> 1) backup production database and create a standby controlfile
>
> 2) copy the backups to the standby server and create the standby
> database (this is well documented in both the oracle docs
> and a number
> of papers on Metalink -- search on standby or "Lawrence To")
>
> 3) set up a nightly job to move the archived logs over to the standby
> database -- if you do this on production, you can determine which is
> the latest archived log and not copy a partial set. Keep track of the
> last one you copied so you know where to start again the next day
>
> 4) set up a job to automatically recover the database. Once you have
> processed all the logs, the automatic recovery will fail and the job
> will end.
>
> 5) ensure that the failure was from "no more logs" and open the
> database in read-only mode
>
> repeat steps 3-5 each day
>
>
> --- "Patterson, Mark" <Mark.Patterson_at_organon.ie> wrote:
> > 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).
> >
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: wweaver_at_rightnow.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).