Oracle-L: RE: Recommended Init File for Standby

From: Kevin Lange <klange_at_ppoone.com>
Date: Fri, 11 Jul 2003 14:29:26 -0800
Message-ID: <F001.005C466C.20030711142926@fatcity.com>

Thanks Dennis. THat is what I have been doing . Guess I will continue.

Kevin

-----Original Message-----
Sent: Friday, July 11, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L

Kevin

Sounds like a trial-and-error to me. Someone else's settings probably wouldn't help you because maybe they only have 12 standby databases. My guess is that your objective is to minimize the memory usage. Some thoughts:

Try reducing the settings until the database won't run, or fails frequently enough to be annoying (like 4031 errors).
Monitor how far behind production the standby lags.
Too much reduction may be self-defeating. For example, making DB_BLOCK_BUFFERS too small might cause the same blocks to be continually reloaded, increasing I/O. This sounds like most DBA work - make a pass or two at it, then move on to the next fire.

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

-----Original Message-----
Sent: Friday, July 11, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L

I knew I would be providing more information.

Other standby databases (14).
Disaster Recovery. Automatic process applying logs only.
Bare essentials. When/If we have to turn to it we will replace the init file with the production init file.

I am looking for exactly what you said. A bare essential init file.

-----Original Message-----
Sent: Friday, July 11, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L

Hi Kevin,

I guess all I have is more questions:

What else do you have running on the server that has your standby database?
What is the purpose of the standby database (disaster recovery or reporting)?
If it is for disaster recovery, shouldn't the settings on the standby reflect the settings for your non standby database or are you looking at handling bare essentials and not your normal capacity?

Maybe some of the answers to these questions will help answer your question to the settings.

Bryan Rodrigues

-----Original Message-----
Sent: Friday, July 11, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L

Evening folks;
Does anyone happen to have any recommended init file settings for a standby database ??

We are running Oracle 8.1.7.4 on a Solaris system. I think that we may have the settings on the standbys too high and are therefore wasting resources.

Kevin
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Kevin Lange
INET: klange_at_ppoone.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: Rodrigues, Bryan
INET: BRodrigues_at_elcom.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------