Linda,
Try ls -ltr /*/oradata/db_name1/*
Didn't think of that, didja.
It's actually pretty cool that (in Unix) you can actually reference
all your data/log/control files with one filespec. Doesn't work
well on NT, but it's better than non-OFA.
HTH,
Yosi
"Hagedorn, Linda" wrote:
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
--
Thanks,
Yosi
---------------------------------------------------------
Yosi Greenfield
Oracle Certified DBA
ygreenfield_at_compuserve.com
Received on Thu Jul 05 2001 - 21:53:19 CDT
