NetWorker: NMDA backup of Oracle control file failed
Summary: NMDA backup of Oracle control file fail with error
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
No change
NetWorker Server and client 8.2.1.7
NMDA 8.2
Oracle 11 G
Backup of database and archive logs are fine.
Backup of control file fail with the following error:
Starting Control File and SPFILE Autobackup at 04-FEB-16
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_SBT_TAPE_1 channel at 02/04/2016 18:39:24
ORA-19506: failed to create sequential file, name="c-3162925413-20160204-02", parms=""
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
RPC receive operation failed; errno = Bad file number (2:14:9)
RMAN backup script contain the following line:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'sbt_tape' TO '%F';
This also based Oracle show all command, the following listed:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
The same backup to disk works fine.
Index checked and started with fresh client index and same problem.
Issue observed only when "CONFIGURE CONTROLFILE AUTOBACKUP ON;"
NetWorker Server and client 8.2.1.7
NMDA 8.2
Oracle 11 G
Backup of database and archive logs are fine.
Backup of control file fail with the following error:
Starting Control File and SPFILE Autobackup at 04-FEB-16
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_SBT_TAPE_1 channel at 02/04/2016 18:39:24
ORA-19506: failed to create sequential file, name="c-3162925413-20160204-02", parms=""
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
RPC receive operation failed; errno = Bad file number (2:14:9)
RMAN backup script contain the following line:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'sbt_tape' TO '%F';
This also based Oracle show all command, the following listed:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
The same backup to disk works fine.
Index checked and started with fresh client index and same problem.
Issue observed only when "CONFIGURE CONTROLFILE AUTOBACKUP ON;"
Cause
The cause cannot be identified
Resolution
In RMAN, set the AUTOBACKUP to off:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP off;
The add the following line to the RMAN script:
backup current controlfile format 'CF_%d_%T_s%sp%pt%t';
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP off;
The add the following line to the RMAN script:
backup current controlfile format 'CF_%d_%T_s%sp%pt%t';
Article Properties
Article Number: 000056676
Article Type: Solution
Last Modified: 03 May 2024
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.