RE: Adding Control files

shutdown the database.

Copy the control files to your two new locations.

Add to the init.ora and restart.

>>> michaelcupp_at_SHONAC.com 7/5/02 9:13:33 AM >>>
CREATE CONTROLFILE -----Original Message-----
Sent: Thursday, July 04, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L

Hello All

I got a request to add at least 2 more control files to the database. Currently we are having 2 control files.

I read the docs (not too much, it is 20:00 now) and did not see it.

1. How do you add a control file? Alter system backup control file and then add it to Init parms?
2. I was told that having 4 control files solves some contention. Anybody encountered this?

Oracle 8.1.6.3.4 on NT4 SP6 server.

Yechiel Adar
Mehish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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).

************************************************************
This message originated from the internet.  Its originator may not be who they claim to be and the information contained herein my or may not be Accurate.

All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Cupp
  INET: michaelcupp_at_SHONAC.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeffrey Beckstrom
  INET: JBECKSTROM_at_gcrta.org

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).