UNIX for Dummies Questions & Answers

Hi,


We have a directory /oracle/UD1/sapdata1,since sapdata1 had no space we created a directory under /oracle/UD1/orarch/sapdata1 and soft linked /oracle/UD1/sapdata1 to /oracle/UD1/orarch/sapdata1 . Is there any way I can see if the files are being actually written to /oracle/UD1/orarch/sapdata1 or to /oracle/UD1/sapdata1,since I can see file under both the directory.

regards!!
Ravi

And of course you moved the content of /oracle/UD1/sapdata1 to /oracle/UD1/orarch/sapdata1, renamed /oracle/UD1/sapdata1 to e.g. /oracle/UD1/sapdata1_4_history in order to create your link to /oracle/UD1/orarch/sapdata1

Yes?
So now in /oracle/UD1/ you have a link called sapdata1, and you can [code] cd sapdata1
Yes?

Hi,

I am not aware,some one else has done it in the past,Is there any way to check if the files under sapdata1 is being written to /oracle/UD1/sapdata1 or /oracle/UD1/orarch/sapdata1? when I do ls -l on /oracle/UD1 the output is

lrwxrwxrwx 1 oraud1 dba 28 Oct 29 2010 sapdata2 -> /oracle/UD1/oraarch/sapdata2

---------- Post updated at 08:16 AM ---------- Previous update was at 08:14 AM ----------

Please ignore my earlier comment.the out put is

lrwxrwxrwx 1 oraud1 dba 28 Oct 29 2010 sapdata1 -> /oracle/UD1/oraarch/sapdata1

Did you try from /oracle/UD1 to

Code:

cd sapdata1

yet?
What do you see?

buddy1 how did you "see file under both the directory"? Did you do something like this:

Code:

ls -l /oracle/UD1/sapdata1/
ls -l /oracle/UD1/orarch/sapdata1/

Actually those commands show you the physically same files.
This looks like an SAP-system running against an Oracle-database. The best way to check what files are actually used is within those applications. I do not remember the exact SAP-transactioncode (maybe db03) but the commandline-tools brtools or sapdba should be able to tell you what datafiles your DB uses. Alternatively you can directly connect to the database and query its data-dictionary (the dba_data_files view holds this information).
As a final note: putting archivelogs and datafiles into the same filesystem is usually not recommended (given your database is in archivelog-mode).