Search Results

Hello All,


I've written a script to collect all audit logs files; now i want to see only the files from it which contains certain x tablenames. I've stored all the tablenames in a log file and...

Hi all.

Am using the below command to get the database size for past two days..

grep total * |awk '{print $9/1024}'
560.746
1260.336

Now i want to see only the size in GB's which means...

Hi All,
I've written a script which reads all the systems backup information and saves it in a log file.

#!/bin/ksh
export ORACLE_SID=$1
export primaryhost=$2
export sid=`echo $ORACLE_SID| tr...

Hi All,

i've written script to collect the tablespaces and the datafiles related to each tablespaces with free space available and directed to two logfiles.. ( pasted below)

1....

When the dates are not matching... it could be a problem...


Guess this could not work...


Hope we have to find the current date and matching with the log file date.. and subtract and if...

Hi all,

I've written a script which gives the below information...

End Date&Time: 2008-10-21 10.54.37

Now i want to calculate this time with the current time.. and if its more than 48...

Hi all..


I've written a script which reads all system backup information.

#!/bin/ksh

export ORACLE_SID=$1
export primaryhost=$2
export sid=`echo $ORACLE_SID| tr ['A-Z'] ['a-z']`...

Hi All,

I've written a script which reads all the systems backup information and saves it in a log file.

ssh -l ora${sid} ${primaryhost} "tail -1...

Thank you... johnson..

Hi All,

I have a log file which is storing a backup time stamps information in it. (pasted below)

20081006210008 0 20081006211910
20081006222824 ...

Hi All,

I've written a script which reads all the systems backup information and saves it in a log file.


ssh -l ora${sid} ${primaryhost} "tail -2...

Hi vidyadhar... i actually wanted to dispaly the line which is above the last line..

Thanks you all...

Hi All..

I have a log file in which all the backup information is stored. Now i have written a script which get the last line in the backup log file..

ssh -l ora${sid} ${primaryhost} "tail -1...

Hi Guru's.... I've one log file in all my systems which writes the backup information..

I'have written a command like this:

ssh -l ora${sid} ${primaryhost} "tail -50...

Hi all, I've written a script which collects some information and sendsout a mail.. (code pasted below)

ssh -l ora${sid} ${primaryhost} "tail -50 /oracle/$ORACLE_SID/newbackup/END_BACKUP.log"...

Hi.. thank you very much for all experts... :-)
It really helped me.. however i could not figure out the exact figure to get the output..
Acutally iam greping for a last line in some log file......

Hi.. thank you very much for all experts... :-)

It really helped me.. however i could not figure out the exact figure to get the output..

Acutally iam greping for a last line in some log...

Hi all,

I have a log file which writes some information in it; now i've written a script to read particular line and print.. (shown below)
...

Hi i've written a script which reads last two line of the log file from N number of servers and send the mail by redirecting to a particular log file.

And the two lines is displayed below.
...

Hi Zaxxon, thanks it worked;however would like to know one more thing...

I've made it possible by using two scripts.

1.)test_ssh1.sh

#!/bin/ksh
RESULTFILE=/oracle/PC9/netbackup.log
if [[...

Hi All,

I've a log file call netbackup.log in all the 5 servers in location usr/netbackup.log. I dont want to login in each server and check the log file. So i wanted to have a script written to...