RMAN-03002: failure of allocate command

I got “RMAN-03002: failure of allocate command ”  error in Oracle database.

 

RMAN-03002: failure of allocate command

 

Details of error are as follows.

RMAN-03002: failure of string command at string.

Cause: This message should be accompanied by other error message(s) indicating the cause of the error.

Action: Check the accompanying errors.

DB was dropped but backup is available on alternate disk.

Restore is been done on the same server.

Restore database gives message no backup available.

Cataloging   the backuppiece gives the below error:-
RMAN> catalog start with '/u01/app/oracle/fast_recovery_area/datastore/TEST/backupset/2016_04_03';

Starting implicit crosscheck backup at 04-APR-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=148 device type=DISK
Crosschecked 80 objects
Finished implicit crosscheck backup at 04-APR-16

Starting implicit crosscheck copy at 04-APR-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 04-APR-16

searching for all files in the recovery area
cataloging files...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================================================
RMAN-03002: failure of catalog command at 04/04/2016 10:52:54
ORA-03113: end-of-file on communication channel
Process ID: 98662
Session ID: 51 Serial number: 13999
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 04/04/2016 10:52:54
ORA-03113: end-of-file on communication channel
Process ID: 98662
Session ID: 51 Serial number: 13999

 

 

failure of catalog command

Since the Controlfile  restored is of type  backup controlfile , an implict reysnc is been done when the catalog command or any other rman command is been run  due to which it tries  to resync  files present in the FRA.

This Implict resync is encountering an issue and reporting 3113 error.

 

Issue is resolved using the following Workaround :-

 

If using Pfile

Comment out db_recovery_file_dest and db_recovery_file_dest and perform the catalog again.

 

If using Spfile

 

Alter system set db_recovery_file_dest='' ;


Alter system set db_recovery_file_dest_size='' ;


Rman> Connect target /

Rman> Catalog  start with '/u01/app/oracle/fast_recovery_area/datastore/TEST/backupset/2016_04_03';

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 483 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply