RE: Standby Database

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Fri, 06 Jul 2001 09:27:09 -0700
Message-ID: <F001.0034309A.20010706085737@fatcity.com>

Richard,

As long as the 2nd instance doesn't interfere with the application of archived redo logs to the standby, I don't see a problem.

I routinely use the extra CPU available on our standby server (Win2K) to zip up exports from production and other, similar tasks that would otherwise put extra load on our production server.

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com
(512)327-9068

-----Original Message-----
Huntley
Sent: Friday, July 06, 2001 10:28 AM
To: Multiple recipients of list ORACLE-L

Just wondering if anyone sees any problems with creating a second instance and DB on a standby database server that would be used for reporting querying against a small dataset??? Running the standby DB in read only mode is not an option since I'm applying archived logs every 10 minutes. If anyone knows of any issues with doing this, could you please let me know.

TIA,
Richard Huntley

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Jul 06 2001 - 11:27:09 CDT