RE: Oracle Standby.

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Fri, 09 Jan 2004 07:24:26 -0800
Message-ID: <F001.005DC452.20040109072426@fatcity.com>

• "Shrake, Jolene" <JEShrake_at_Pella.com> wrote:
  > There are good documents on Metalink (one in
  > particular by Lawrence To).
  > The Oracle RDBMS manuals are informative as well.
  >
  > I run a script bat file on Windows on the primary to
  > transfer the logs
  > every half hour to the secondary. And a bat file
  > once a day on the
  > secondary to apply the logs. I use blat to send an
  > email of the last
  > log applied so that I can be sure everything is OK.
  >
  > I don't run in managed mode, the servers come down
  > occasionally and that
  > messes up the standby if you're not careful.
  >
  > Jolene
  

Mark,

I have a few questions for you.

Oracle version? (9i R2, I'd assume)
Enterprise Edition or Standard?
Database size?
Volume of logs generated per day?
standby server on local LAN or remote network?  (do you want to use compression of logs) NetBIOS enabled over WAN/VPN?
 (what protocols are available to transfer logs) NOLOGGING operations permitted?
 (frequency of full refreshes, use of FORCE LOGGING)

We run home-grown scripts for Standard Edition, but I have a project coming up where the Client is running Enterprise Edition, so when they are migrated to 9i R2, we're planning on using DataGuard to handle the physical standby.

you're likely going to want to automate creation of initial backupset used for standby, and for automated refreshing of entire db.

gotta run.

Pd

> -----Original Message-----
> Sent: Friday, January 09, 2004 8:20 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>
> Does anybody have any good resources
> (links/whitepapers) on setting up,
> managing and monitoring an Oracle Standby
> environment?
>
> It will be a windows installation.
>
> Many thanks!
>
> Mark
>
> ===================================================
> Mark Leith | T: +44 (0)1905 330 281
> Sales & Marketing | F: +44 (0)870 127 5283
> Cool Tools UK Ltd | E: mark_at_cool-tools.co.uk
> ===================================================
> http://www.cool-tools.co.uk
> Maximising throughput & performance
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system
> (http://www.grisoft.com).
> Version: 6.0.558 / Virus Database: 350 - Release
> Date: 02/01/2004
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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: Shrake, Jolene
> INET: JEShrake_at_Pella.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).

---

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_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).

Received on Fri Jan 09 2004 - 09:24:26 CST