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: Rachel Carmichael <>
Date: Fri, 02 May 2003 06:41:49 -0800
Message-ID: <>

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

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
Please see the official ORACLE-L FAQ:
Author: Rachel Carmichael

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 Fri May 02 2003 - 09:41:49 CDT

Original text of this message