Backup of an Oracle database fails with the error "The Database script returned an error. Refer to the Database script output section in job logs for more details"
| Article:TECH52429 | | | Created: 2007-01-26 | | | Updated: 2011-09-13 | | | Article URL http://www.symantec.com/docs/TECH52429 |
Problem
Backup of an Oracle database fails with the error "The Database script returned an error. Refer to the Database script output section in job logs for more details"
Error
Error A 1. The RMAN output reports the following:
RMAN-03002: failure of backup plus archivelog commandat <Date> <Time>
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file D:\ORA90\Archive1.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Error B. The RMAN output reports the following:
ORA-19566: exceeded limit of 0 corrupt blocks for file E:\ORA90\Database\tablespace.dbf
The Database script returned an error. Refer to the Database script output section in job logs for more details.
The Database script returned an error. Refer to the Database script output section in job logs for more details.
Cause
The above mentioned error occurs when the RMAN utility does not work properly while running the scripts.
Solution
Error A1 can be fixed by solution A1 and A2. Follow A1 and if not resolved, Follow A2.
Error A1 indicates that there are some Archive logs missing from the expected sequence of logs. To fix the discrepancy execute the following steps:
Solution A 1:
1. Go to the Oracle server. Launch the command prompt.
2. Type RMAN
3. Typeconnect target sys@SIDname
4. Once connected to RMAN prompt, run command:
crosscheck archivelog all;
5. Then run the command:
delete expired archivelog all;
6. Exit the command prompt.
7. Now run the backup job and verify that it is successful.
Solution A 2:
RMAN or the Oracle instance must be modified to agree on the validity of the archived log file listed in the output file. This can be accomplished by using either the Oracle catalog command or the RMAN resync command.
To update RMAN with the list of currently available archived log files.
1. Go to the Oracle server. Launch the command prompt.
2. Type RMAN
3. Type connect target sys@SIDname
4. Once connected to RMAN prompt, run command:
RMAN> resync catalog;
Please contact Oracle support for assistance in using the catalog and resync commands
Solution B
1. Go to the Oracle server. Launch the command prompt
2. Type RMAN
3. Type connect target sys@SIDname
4. Once connected to RMAN prompt, run command:
run {
backup tablespace tablespacename;
}
If the above command returns the same error, it indicates an issue with Oracle. Contact Oracle Support to resolve the corruption in the tablespaceThe resolution for this issue depends on the error logged in the RMAN output. Please refer to the RMAN OUTPUT section in the failed backup job log for an error.
|
|
| Source | Error Code |
| Value | 0xe0000340 |
| Description | The Database script returned an error. Refer to the Database script output section in job logs for more details. |
Legacy ID
289675
Article URL http://www.symantec.com/docs/TECH52429
Terms of use for this information are found in Legal Notices
Thank you.