RE: rman, init.ora, spfile???

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 29 Mar 2004 16:18:30 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA85@USAHM018.amer.corp.eds.com>

Dennis, in the case of RAC on a system that does not support a clustered file system the init.ora contains a line that points to the spfile since it has to be built using a raw partition and will not be located in the expected default location. AIX 4.3 is such an environment. In a case like this I wonder what would happen if you used remote administration. We do not use OEM.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS
Sent: Monday, March 29, 2004 3:55 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: rman, init.ora, spfile???

Paula - My understanding (just working from what somebody told me and I haven't checked the documentation) is that if the database uses the spfile, that single file will always be used when starting up the database. This was one of the purposes of spfile, to get away from the need to have distributed init.ora files. A simple test should suffice to verify that statement.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Paula_Stankus_at_doh.state.fl.us
Sent: Monday, March 29, 2004 2:43 PM
To: oracle-l_at_freelists.org
Cc: Rich.Jesse_at_qtiworld.com
Subject: RE:rman, init.ora, spfile???

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 29 2004 - 15:15:44 CST