Oracle backups fail 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 the error : "RMAN-06428: recovery catalog is not installed".

Article:TECH76717  |  Created: 2009-01-12  |  Updated: 2011-07-12  |  Article URL http://www.symantec.com/docs/TECH76717
Article Type
Technical Solution


Issue



Oracle backups fail 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 the error : "RMAN-06428: recovery catalog is not installed".


Error



The RMAN Output in the Job log shows the error below.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 11/08/2009 14:03:37
RMAN-06428: recovery catalog is not installed

Recovery Manager complete.


Cause



- The recovery catalog is not installed.

- The database to be backed up is not registered.
 


Solution



- First create a user to hold the recovery catalog.
 
- Then create the recovery catalog.
 
- Each database to be backed up by RMAN must be registered before attempting a backup.
 
NOTE: Contact the Oracle Support or Oracle DBA for assistance in following the steps above or use the examples below to perform the steps.
 

 
Create a user to hold the recovery catalog:
 
CONNECT sys/password@InstanceName AS SYSDBA
 

 
-- Create tablepsace to hold repository
 
CREATE TABLESPACE "RMAN"
 
DATAFILE 'C:\ORACLE\ORADATA\W2K1\RMAN01.DBF' SIZE 6208K REUSE
 
AUTOEXTEND ON NEXT 64K MAXSIZE 32767M
 
EXTENT MANAGEMENT LOCAL
 
SEGMENT SPACE MANAGEMENT AUTO;
 

 
-- Create rman schema owner
 
CREATE USER rman IDENTIFIED BY rman
 
TEMPORARY TABLESPACE temp
 
DEFAULT TABLESPACE rman
 
QUOTA UNLIMITED ON rman;
 

 
--GRANT connect, resource, recovery_catalog_owner TO rman;
 

 
Create the recovery catalog:
 
C:>rman catalog=rman/rman@InstanceName
 

 
Recovery Manager: Release 9.2.0.1.0 - Production
 

 
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
 

 
connected to recovery catalog database
 
recovery catalog is not installed
 

 
RMAN> create catalog tablespace "RMAN";
 

 
recovery catalog created
 

 
RMAN> exit
 

 
Recovery Manager complete.
 

 

 
Register Database
 
Each database to be backed up by RMAN must be registered:
 
C:>rman catalog=rman/rman@InstanceName target=sys/password@InstanceName
 

 
Recovery Manager: Release 9.2.0.1.0 - Production
 

 
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
 

 
connected to target database: InstanceName (DBID=1371963417)
 
connected to recovery catalog database
 

 
RMAN> register database;
 

 
database registered in recovery catalog
 
starting full resync of recovery catalog
 
full resync complete
 

Supplemental Materials

SourceUMI
ValueV-79-57344-832
Description

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


SourceError Code
Value0xe0000340
Description

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


Legacy ID



337121


Article URL http://www.symantec.com/docs/TECH76717


Terms of use for this information are found in Legal Notices