Question

  Asked: Apr 28 2008   2:10 PM GMT
  Asked by: OracleATE


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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle and Database.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register