Question

I need help with how to programmatically backup a database

Oracle, Oracle backup, Database

I’m trying to programmatically backup a database using the following command:

expdp system/system_password
 directory=dir_exp job_name=jobexp
 SCHEMAS=my_schema
 

where "system_password" is the actual "system" password and "my_schema" is the name of the schema I want to export.

How can I verify in an automatic manner that the export was successful? Searching the log file for the "successfully completed at" line is not such a good idea...

The question remains for restore also: how can I check that the restore is successful?

read the log file is the unique way to verify wheter the export was successfull or not. You can write a second script to read the log file.