Oracle backup fails with an error 0xe0000340 "the database script returned an error", RMAN output show error ORA-00257

book

Article ID: 100030901

calendar_today

Updated On:

Description

Error Message

 "0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details." 

RMAN output shows error "RMAN-04004: error from recovery catalog database: ORA-00257: archiver error. Connect internal only, until freed."

Cause

This issue is caused because the Recovery Catalogs reported an error and are enabled under the Remote Agent Utility on the Oracle server.

Resolution

If the Recovery Catalogs are not to be used, follow the steps below. If you wish to use this option, contact Oracle support for further assistance, since the RMAN output is showing a potential problem in the Recovery Catalogs.

For Windows:

If the Recovery Catalogs are not to be used, open the Remote Agent Utility on the Oracle server and go to the "Oracle" tab. Disable the "Recovery Catalog" option, restart the Remote Agent service and retry the backup job.

For Linux:

Reconfigure the Remote Agent for Linux on the Oracle server and disable the Recovery Catalog option. For more information, refer Oracle Agent Configuration Options

 

 

Issue/Introduction

When running a backup using the Agent for Oracle, the operation fails with the error "0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details." The RMAN output shows error "RMAN-04004: error from recovery catalog database: ORA-00257: archiver error. Connect internal only, until freed."