RE: OFA (Optimal Flexible Architecture) in practice

From: <MHately_at_etech-uk.com>
Date: Fri, 06 Jul 2001 01:34:13 -0700
Message-ID: <F001.00342838.20010706012554@fatcity.com>

Hi,
If you can cd to a single directory and list all of your files then it means that all of your files are in a single filesystem probably (unless you've been VERY clever) sharing the same disks.
I agree with the suggestion that you can create links to the datafiles from a "central" directory but that needs maintenance for each file added. If you have an OFA compliant structure then "ls /u*/oradata/db_name1/*.dbf" will give you the names of your datafiles.

Regards,

Mike Hately

|--------+------------------------>


|        |          "Lord, David -|

|        |          C&S"          |

|        |          <David.Lord_at_ha|

|        |          yscsg.com>    |

|        |                        |

|        |          07/06/01 09:45|

|        |          AM            |

|        |          Please respond|

|        |          to ORACLE-L   |

|        |                        |

|--------+------------------------>
  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  |
  |       cc:     (bcc: Mike Hately/ETECH)                                     |
  |       Subject:     RE: OFA (Optimal Flexible Architecture) in practice     |
  >----------------------------------------------------------------------------|

Well, you could always put a directory of symbolic links under your $ORACLE_BASE. Regards
David Lord

-----Original Message-----
Sent: 06 July 2001 01:25
To: Multiple recipients of list ORACLE-L

Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? e.g..

/u02/oradata/db_name1/userdata01.dbf
/u02/oradata/db_name2/userdata01.dbf
/u03/oradata/db_name1/userdata02.dbf
/u03/oradata/db_name2/userdata02.dbf

You cannot cd to a given subdirectory, ls -ltR | more to see all the datafiles associated with a given database. Instead, from / you have to ls -ltR | grep db_name1 to scan the full file system. Seems like there should be a better way.
Any input, pro or con, is appreciated.
Thanks, Linda

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: MHately_at_etech-uk.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jul 06 2001 - 03:34:13 CDT