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@ha|
| | yscsg.com> |
| | |
| | 07/06/01 09:45|
| | AM |
| | Please respond|
| | to ORACLE-L |
| | |
|--------+------------------------>
>----------------------------------------------------------------------------|
| |
| To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> |
| 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
