Oracle 12c RMAN backup parent job is only partially successful if metadata collection is enabled

Article: 100014179
Last Published: 2017-11-17
Ratings: 0 1
Product(s): NetBackup & Alta Data Protection

Problem

The Oracle RMAN application backup jobs complete with status 0, but the metadata collection phase of the backup reports a failure.   The failures did not occur until after upgrading the Oracle instance to Oracle 12c.

The backup images are present in NetBackup and available for restore.

 

Error Message

These Job Details are for a backup initiated from an Oracle Intelligent Policy.  They confirm that the backup was successful and the image is restorable.  However, bprd reported a failure when attempting to catalog the metadata for use with the Guided Recovery feature.

23.09.2014 15:09:15 - Error bprd(pid=6892) Failed sending the results of the backup to DARS: The operation for version 12.1.0.1.0 of oracle is not supported.
23.09.2014 15:09:15 - Info bphdb(pid=29307) INF - Archive Log-Dateiname=/orabin/12.1.0.1/dbs/arch1_14_858352098.dbf RECID=14 STAMP=858608698
…snip…
23.09.2014 15:10:48 - Warning bpbrm(pid=77452) from client myclient: WRN - Metadata cataloging for a child job failed
23.09.2014 15:10:48 - Error bpbrm(pid=77452) from client myclient: ERR - bphdb exit status = 1: the requested operation was partially successful
23.09.2014 15:10:49 - Info bpbrm(pid=77452) validating image for client myclient
23.09.2014 15:10:49 - Info bphdb(pid=29307) done. status: 1: the requested operation was partially successful
23.09.2014 15:10:49 - end writing
the requested operation was partially successful(1)

 

Cause

Current versions of NetBackup for Oracle do not support metadata collection for Guided Recovery when backing up Oracle 12c. 

The status 1 on the backup reflects only the failure to collect the metadata; the backup images are saved and restorable.

 

Solution

NetBackup for Oracle supports backup and restore operations for Oracle 12c, but the restore must be initiated via Oracle Enterprise Manager, RMAN, restore scripts, or restore templates.   Guided Recovery may not be used due to the failure to collect the metadata during the backup.

To allow the backup operation to complete with status 0, instead of status 1, disable metadata collection for the backup.

The following methods can be used to disable metadata collection.

1. To disable collection, by default, for all jobs on the Oracle client (dbClient), send this configuration setting to the client from the master or media server.

server$ echo ORACLE_METADATA=NO | bpsetconfig -h dbClient

The bpsetconfig command is located in the install_path/netbackup/bin/admincmd directory.

2. To disable collection for a specific job, use the RMAN SEND command in the backup script.

ALLOCATE CHANNEL … ;
SEND ’NB_ORA_METADATA=NO’;
BACKUP … ;

Veritas Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned in this article.   Veritas Corporation is committed to product quality and satisfied customers.   There are currently no plans to address this issue by way of a patch or hotfix in the current or previous versions of the software.   If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Veritas Sales representative or the Veritas Sales group to discuss these concerns.   For information on how to contact Veritas Sales, please visit to the following Web link:

 https://www.veritas.com/business/

Applies To
NetBackup 7.6, 7.7, 8.0, 8.1 for Oracle
Oracle 12c
Any platform

 

Was this content helpful?