Re[2]: Shooting yourself in the spfile
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: Adam Donahue <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Feb 2004 20:44:43 -0500
Wednesday, February 18, 2004, 8:27:34 PM, Adam Donahue (adonahue@xxxxxxxxxxx)
wrote:
AD> Are you sure about that?
I thought I was sure, but it turns out I didn't test
carefully enough. Shame on me.
AD> I just tested this on a couple local instances, and was
AD> able to create both a pfile from spfile, and spfile from
AD> pfile, on an idle instance.
Sure enough. I was wrong. It can be done:
SQL> connect system/sql8plus4 as sysdba;
Connected to an idle instance.
SQL> create pfile='c:\a\init.ora' from spfile='c:\oracle\ora10\database\SPFILEOR
CL.ORA'
2 ;
File created.
Knowing this, it now seems possible to recover from a
screwup without having to bother making backups each time I
change a parameter.
Life is good again.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request@xxxxxxxxxxx and
include the word "subscribe" in either the subject or body.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
