Hi Jonathan, We are using rman to backup spfile. In case of a problem we can restore = the previous version of the spfile from RMAN. Sofar we have been using = this approach and its going fine ( we have restored the spfile on a few = occasions). Would like to know if listers are following a RMAN approach. = The other alternative being a version control software(RCS/PVCS) on = the spfile and treating the spfile as a program unit. Any thoughts on = this? Best Regards Sriram Kumar -----Original Message----- From: Jonathan Gennick [mailto:jonathan@xxxxxxxxxxx]=20 Sent: Thursday, February 19, 2004 4:27 AM To: oracle-l@xxxxxxxxxxxxx Subject: Shooting yourself in the spfile I just went through an episode in which I changed a parameter setting using scope=3Dspfile, attempted to bounce my instance, and found that I was hosed. Fortunately, I had an up-to-date text version of my parameter file (i.e. init.ora) that I was able to fall back on, and I easily used that to restart my instance. Now I have to recreate my server parameter file, because, having started my instance using init.ora, it won't let me change a parameter using scope=3Dspfile. Arg! All this has underscored the importance of backing myself up when it comes to parameter changes, and I'm wondering about best-practices. What do you all do to protect yourself here? I can think of two alternatives: * Follow each successful spfile change by creation of a new, text-based (init.ora) parameter file, to use in case you muck up your spfile in the future. * Make a copy of your binary spfile after each successful change, or before making a change, so that you can fall back by copying the last known-good spfile over the one you screwed up. Are there any alternatives that I've missed here? What approach is best, and why? Right now, I lean towards keeping a current, text-based parameter file, because that gives you the flexibility to go in with vi and tweak a parameter. In fact, I wonder why the server parameter file can't be text-based. If I have to constantly make text-based backups to protect myself, why not just make the spfile text-based to begin with? 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=20 email. To join, visit = http://four.pairlist.net/mailman/listinfo/oracle-article,=20 or send email to Oracle-article-request@xxxxxxxxxxx and=20 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 ----------------------------------------------------------------- DISCLAIMER: This message contains privileged and confidential information and is = intended only for the individual named.If you are not the intended = recipient you should not disseminate,distribute,store,print, copy or = deliver this message.Please notify the sender immediately by e-mail if = you have received this e-mail by mistake and delete this e-mail from = your system.E-mail transmission cannot be guaranteed to be secure or = error-free as information could be = intercepted,corrupted,lost,destroyed,arrive late or incomplete or = contain viruses.The sender therefore does not accept liability for any = errors or omissions in the contents of this message which arise as a = result of e-mail transmission. If verification is required please = request a hard-copy version. ---------------------------------------------------------------- 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 -----------------------------------------------------------------