Hi, I have a complex shell scripting requirement. 1. I need to fetch last 7 days archived log files by querying database. 2.Then I have to compare the file names i got from querying oracle table with the file name existing in the file system directory. If anything is missing i need to send mail to DBA team. 3. If everything is fine. I need to send the count of files that are archieved for the past 7 days. 4. I will have to schedule it to run on monday morning so that I can report the summary for the last week. I can fetch list of file names from oracle tables and put it in a temp file. but i am wondering how to compare this list with list of file system files. I need to compare with the name of the file. If you need more details, let me know Can anyone help me? Thanks and regards Suresh H Thopaiah sureshht@yahoo.com

OK. Given a sample file that looks like this: Input file name "files.in" cygwin.tic dhcp.ksh gethost.exe junk.html junk1.html junk3.html keys.txt license.txt misc.txt numbers.txt output.lines trchkid.h united.txt And I want to find out if these files exist in the /home/Administrator directory, I'd do this: #!/bin/ksh Directory=/home/Administrator exec 3<files.in while read -u3 filename do if [[ -f $Directory/$filename ]] then print "File found" else print "File not found" fi done

Hi, Thanks for your reply. I am pulling list of archivelog files from database to a tempfile1. Also I am pulling directory archivelog path from database and putting in tempfile2. I want to go to the directory path (cd to) in the tempfile2. say tempfile2 has the path '/oracle/app/oracle/admin/sepmbx1/archive'. I want to go to this path and pump the list of files in the directory to a tempfile3. Then I want to compare the existance of entries from tempfile1 in the tempfile2. I dont know whether i am clear on what I want. Please let me know if any confusion Thanks and regards Suresh sureshht

Got several issues you need to resolve. Do the file names extracted from the database have a relative or absolute path? If they have an absolute path, they should have the form: /mydir/filename and if they have an relative path then they'll have the form: ./mydir/filename and finally, do they contain just a file name such as myfile Let me know and I'll cook something up for you.

I solved my issue with another one i filed: 'comparing 2 files with shell script' in this forum. Thanks for your assistance. Suresh sureshht