I need help with how to programmatically backup a database
I’m trying to programmatically backup a database using the following command:
Software/Hardware used:
expdp system/system_password directory=dir_exp job_name=jobexp SCHEMAS=my_schemawhere "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?
Software/Hardware used:
ASKED:
April 28, 2008 2:10 PM
UPDATED:
April 29, 2008 7:44 PM
RELATED QUESTIONS
- How do you restore and recover RMAN incremental backup on a new Host in different HDD partition?
- SQL Server 2008 Restore Fails - There is insufficient system memory in resource pool 'internal' to run this query
- Disabled DST password oncomplete system restore
- How to use 'Create index' statement in iSeries Navigator
- AIX backup and restore
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
