Shooting yourself in the spfile 2004-02-20 - By Grabowy, Chris
I believe DataGuard requires spfiles. Like CBO, I believe its just a
matter of time before more and more new features require spfile.
IMHO, if I have to make a change to a database, I want to do it from
within the database not from the OS. We have a couple hundred
databases, to manually update pfiles takes forever and is error prone,
but running a bunch of ALTER DATABASE commands is quick/easy. YMMV.
(slithering back into my lurker corner)
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Nuno Souto
Sent: Thursday, February 19, 2004 4:40 AM
To: oracle-l@(protected)
Subject: Re: Shooting yourself in the spfile
Fix the illness, not the symptom:
stop using the spfile. Totally unnecessary
feature.
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@(protected)
-- -- Original Message -- --
From: "Jonathan Gennick " <jonathan@(protected) >
To: <oracle-l@(protected) >
>
> 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:
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
