05-30-2012 12:25 AM
we have backup exec 2010 agent for oracle,
when we are doing a bakup for the oracle database its giving the follwoing error :
The Database script returned an error. Refer to the Database script output section in job logs for ...
this error come before the RMAN logs and there is no error in the RMAN ,
looking for support ,
05-30-2012 01:43 AM
Please refer to the following technotes:
http://www.symantec.com/docs/TECH72297 : Oracle backups fail with error 0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details. ORA-09925: Unable to create audit trail file
http://www.symantec.com/docs/TECH66307 : Backup of Oracle RAC (Real Application Cluster) database(s) fails with the error "The Database script returned an error. Refer to the Database script output section in job logs for more details".
http://www.symantec.com/docs/TECH59661 : Backup of the Oracle server fails with "database script returned an error" and RMAN output section of job log shows "ORA-27211: Failed to load Media Management Library"
Thanks,
-Sush...
05-30-2012 03:13 AM
Sush,
thanks for your reply,
but all of these links pointing to error codes and errors in RMAN logs,
but in my case the error appear without error code or without any RMAN errors,
05-30-2012 03:16 AM
Then I suppose this would require some detail troubleshooting. Try to re-configure the Remote Agent for Oracle backups. If that does not help then I would suggest you to open a case with Symantec if you have a Support contract with Symantec.
Thanks,
-Sush...
05-31-2012 06:32 AM
Asking for logs and more information about the error.
once I receive the logs, I will update this thread
Thanks,
Lilavati
06-06-2012 11:29 PM
The logs that you sent me does not have sgmon log of remote machine (i.e. Oracle Server ) it is empty.
I checked your job log and from job log it seems that your backup job is completed successfully.
Can you please try one thing, open restore view and check if backup set is available or not for that particular backup job?
If yes, is it possible you to restore that backup set on another test machine, you can use redirect restore for restoring database on another machine steps are mentioned in the admin guide.
This is just to make sure that data is proper or not.
You can open the support case for this issue.