Oracle RMAN DELETE OBSOLETE operations fail when catalog backups are running.

Article: 100015746
Last Published: 2015-06-24
Ratings: 3 6
Product(s): NetBackup & Alta Data Protection

Problem

The Oracle RMAN> DELETE OBSOLETE command instructs RMAN to remove backup pieces that are no longer considered valuable, and when those backup pieces were taken with the SBT_TAPE channels, a request is sent to the NetBackup master server's bprd process to expire NetBackup backups which house the RMAN backup pieces.  If the master server is performing a catalog backup the request to expire a backup will fail reporting a NetBackup error code 125.

Error Message

Error observed from RMAN:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_SBT_TAPE_1 channel at 06/21/2015 19:19:29
ORA-19509: failed to delete sequential file, handle="c-1234567890-20150620-03", parms=""
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to remove, c-1234567890-20150620-03, from image catalog.


From the dbclient log on the Oracle server:
19:19:28.972 [8847526] <4> bsa_DeleteObject: INF - File to delete: /c-1234567890-20150620-03
19:19:28.972 [8847526] <4> BuildBprdRequest: entering BuildBprdRequest.
19:19:28.972 [8847526] <4> BuildBprdRequest: request_string=<7.6 aupadb08 aupadb08 *NULL* 4 1432181785 1432181785 /c-1234567890-20150620-03>
19:19:28.974 [8847526] <2> logconnections: BPRD CONNECT FROM 192.168.1.200.50339 TO 192.168.1.100.1556 fd = 28
19:19:29.114 [8847526] <16> dbc_DeleteImageRequest: Client type: 4, returning: 125 


From the master server's bprd log:
19:19:29.056 [17135] <2> delete_image_by_file: db_IMAGE() failed: a NetBackup catalog backup is in progress
19:19:29.056 [17135] <2> process_request: delete_image_by_file failed - status = a NetBackup catalog backup is in progress (125)
19:19:29.056 [17135] <2> process_request: EXIT STATUS 125

Cause

NetBackup catalog backups protect the integrity of the NetBackup catalog, the RMAN> DELETE OBSOLETE command would attempt to remove backups, these two operations are not permitted to run at the same time.

Solution

Two possible solutions exist, change the NetBackup catalog backup window to not co-inside with the Oracle operations, or cease running RMAN> DELETE OBSOLETE operations during NetBackup catalog backups.

Was this content helpful?