RE: Inheriting a "interesting" recovery process
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Rodd.Holman@xxxxxxxxx'" <Rodd.Holman@xxxxxxxxx>, Rich.Jesse@xxxxxx
- Date: Fri, 4 Aug 2006 18:57:56 +0100
I believe that Oracle's definition of OFA has changed since Cary Millsap's
original paper, which said you place data files on, e.g. /uNN/oradata/SID.
We use ".arc" for archived logs as well. I agree that anything but ".log"
(especially for online logs!) is preferable.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Rodd Holman
Sent: Friday, August 04, 2006 1: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
>
--
//www.freelists.org/webpage/oracle-l
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
