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 )