0

We have several oracle 19c servers with daily exports. I would like to find a way to run a command to read the export log file to find the success message for the day. e.g. I would like to putty into the linux server have a command I can copy and paste that will read the daily export log file and tell me in one command/output that the export was successful or not? or any better ideas to automate reporting that daily exports are successful on 40+ servers?

1
  • Take a look at ansible. This is the kind of automation it was designed for.
    – pmdba
    Jan 8, 2023 at 12:30

2 Answers 2

0

Assume that you always start your export log files with 'expdp_' and always end them with '.log'. Then

egrep -c '(^Job)(?!(successfully))' expdp_*.log

will give you a listing of the log filenames and the number of times 'Job' but not 'successfully' occured in that file. Get a zero count and the export was successful, get a non-zero count and the export had a problem.

0

I admit that it is not a command line solution but datapump has control tables and these could be analyzed with SQL

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.