Actually, if I recall my version features correctly, you do not need step 3
anymore in 8i. You configure net8 to move the archived redo logs across as
they are generated.
Also, look into Oracle9i and it's new features including logical standby
database. I'm doing a 9i physical standby database implimentation right now
and it's been smoooooth... well, ok, there was the bug with autoextend in
9.2.0.3... and there was the 9.2.0.2 bug with the ora-600's that made me
have to goto 9.2.0.3.... ok, so it wasn't that smooth, but it's smooth now.
With a Logical Standby you can add additional schema objects, such as
indexes and MVIews, which can make your reporting much easier and faster
AND.... you can update the database and report from it at the same time.
Downside, in my view, is that it's a bit more complex to manage than
physical standby.
RF
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 5/2/2003 9:41 AM
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....)
- backup production database and create a standby controlfile
- 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")
- 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
- 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.
- 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: Freeman Robert - IL
INET: FREEMANR_at_tusc.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).
Received on Fri May 02 2003 - 11:11:48 CDT
