RE: Inheriting a "interesting" recovery process

Oh my gosh, that's a HORRIFIC violation of OFA principles.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba
 
Hotsos Symposium 2007 / March 4-8 / Dallas
Visit www.hotsos.com for curriculum and schedule details...


-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse@xxxxxx] 
Sent: Friday, August 04, 2006 1:06 PM
To: Cary Millsap; Rodd.Holman@xxxxxxxxx
Cc: stephenbooth.uk@xxxxxxxxx; jkstill@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Inheriting a "interesting" recovery process

Bingo!

http://download-east.oracle.com/docs/html/B10163_01/orahome.htm#i1006306

Quoting:  "Database files are stored in ORACLE_BASE\ORADATA\DB_NAME"

Obviously, this recommendation is not according to the OFA that you
wrote, Cary.  Thanks for setting me straight on datafile placement and
OFA!

Rich
 

-----Original Message-----
From: Cary Millsap [mailto:cary.millsap@xxxxxxxxxx] 
Sent: Friday, August 04, 2006 12:58 PM
To: Rodd.Holman@xxxxxxxxx; Jesse, Rich
Cc: stephenbooth.uk@xxxxxxxxx; jkstill@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Inheriting a "interesting" recovery process

...Like I said in my prior post, the OFA (at least the one I wrote)
specifically specifies that you DO use a separate area (well, multiple
separate areas named so that a single wildcard expression can denote the
collection) for these files.

So, you would not breaking OFA by doing what you say.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba
 
Hotsos Symposium 2007 / March 4-8 / Dallas
Visit www.hotsos.com for curriculum and schedule details...


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rodd Holman
Sent: Friday, August 04, 2006 12:51 PM
To: Rich.Jesse@xxxxxx
Cc: stephenbooth.uk@xxxxxxxxx; jkstill@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Inheriting a "interesting" recovery process

Actually we do the same thing here only the archives are .arc.
We as DBA's are also closely integrated with the ifrastructure folks
though.  Half of them were former DBA's so they know better.

As far as mountpoints,  we break OFA there also and use a separate
area for data files/control files/redo logs/and archived logs.  That
way we can put the database on one backup schedule and the software on
another.  The oracle home doesn't normally change much so a nightly
backup of that is not nearly as critical as the backup of the oradata
stuff.

Rodd

Jesse, Rich wrote:
> Which is precisely why I break this OFA rule and name every Oracle DB
> file with a ".dbf" extension.  It eliminates the confusion of the dual
> meaning of the term "log" for the archived logs, making it a simple
rule
> to let the SAs know that ".dbf" files are important
> don't-touch-without-asking Oracle files.  Even before taking my first
> Oracle DBA class the ".log" naming jumped out at me.
> 
> As I've said before, I do like the vast majority of the structure of
> OFA, but this and having the datafile mountpoint under ORACLE_BASE (or
> is it ORACLE_HOME?) are two that I think are asking for trouble.
> 
> Rich
> 

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


Other related posts: