Create pfile='/path/initSID.ora' from
Spfile='/path/spfileSID.ora';
Change initSID.ora
Delete old spfile
Create spfile='/path/spfileSID.ora' from
Pfile='/path/initSID.ora';
All Done....
Scott Stefick
MILPDS OCP Oracle DBA
[EMAIL PROTECTED]
210-565-2540
-----Original Message-----
From: CHEN,JIN [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 08, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L
Subject: question on spfile and pfile
Hi there,
I found my SPFILE and PFILE are pointing to the same one that is
spfile<SID>.ora. Now, I want to multiplex control file and books
tell me to change in init<SID>.ora. I wonder how can create a
init<SID>.ora from SPFILE. I knew there is one in
$ORACLE_BASE/admin/<SID>/pfile when I created database. But I
might change some parameters by "alter database ..." or "alter
system ...", like changing to ARCHIVELOG and multiplexing redo
log. I am not sure if current spfile is different from that
init<SID>.ora.
Please help!
thanks,
Jin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: CHEN,JIN
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).