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@(protected)]
Sent: Thursday, February 19, 2004 4:27 AM
To: oracle-l@(protected)
Subject: Shooting yourself in the spfile
I just went through an episode in which I changed a
parameter setting using scope=spfile, 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=spfile. 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@(protected)
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@(protected) 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
