RE: Inheriting a "interesting" recovery process

From: Paul Vincent <Paul.Vincent_at_uce.ac.uk>
Date: Tue, 8 Aug 2006 14:56:05 +0100
Message-ID: <14C5F9616FF43F479F67E41A1DF4D94A0CDBD723@exchangeb.staff.uce.ac.uk>

Well, let's see...

Oracle Database Installation Guide, 10g Release 2 (10.2) for Microsoft Windows (32-Bit) B14316-02. Appendix C, Optimal Flexible Architecture. Page C-5, in the section "OFA Directory Naming Conventions":

"ORADATA Directory

Database files are stored in ORACLE_BASE\oradata\DB_NAME. Names and brief descriptions are:

CONTROL01.CTL  --control file 1
CONTROL02.CTL  --control file 2
CONTROL03.CTL  --control file 3
EXAMPLE01.DBF  --EXAMPLE tablespace data files
.

.
."

etc.

So I don't know which OFA spec Cary's referring to - his link was to a document dated 1995, so I think I'd be more inclined to put my faith in the Oracle publication from June 2006. Or is it a case of "well, there's OFA, then there's OFA..."?

Paul Vincent
Oracle DBA (but not a very hot one)
UCE Birmingham

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> Sent: 04 August 2006 18:59
> To: Cary Millsap; stephenbooth.uk_at_gmail.com; jkstill_at_gmail.com
> Cc: oracle-l_at_freelists.org
> Subject: RE: Inheriting a "interesting" recovery process
>
> Excellent! Coming from you, it's worth *tons*. I'm glad you
> replied, Cary, and I'm glad to finally see the de facto OFA paper.
>
> Now I just need to figure out where I've seen the "oradata"
> directory slapped under ORACLE_BASE or ORACLE_HOME.
>
> Thanks!
> Rich
>
>
>
> -----Original Message-----
> From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]
> Sent: Friday, August 04, 2006 12:51 PM
> To: Jesse, Rich; stephenbooth.uk_at_gmail.com; jkstill_at_gmail.com
> Cc: oracle-l_at_freelists.org
> Subject: RE: Inheriting a "interesting" recovery process
>
> I would agree that .log is a dangerous extension for files
> that you want
> *not* to get picked off by some SA's "find" command for deletion.
>
> And the OFA spec definitely does NOT put data files beneath
> ORACLE_BASE or ORACLE_HOME
> (http://www.hotsos.com/e-library/abstract.php?id=19).
>
> So I agree with you on both accounts.
>
> For what it's worth.
>
>
> Cary Millsap
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Aug 08 2006 - 08:56:05 CDT