PowerProtect Oracle Self-Service backups in a Data Guard environment fail or complete with exceptions if the database unique name has uppercase letters in its name

Summary: This article provides a workaround for Oracle self-service backups in a Data Guard environment.

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.
Check out other resources

Symptoms

Oracle Data Guard fails with the following message:
 
Data Guard error
  
Oracle Data Guard backups complete with exceptions if the parameter ALLOW_BACKUP=<instance_name> is set in <RMAN_AGENT__INSTALL>/config/rman_agent.cfg
 
Completed with Exceptions message

This article only applies if doing self-service backups in an Oracle Data Guard environment that is integrated with PowerProtect Data Manager.

There are two ways of confirming the issue:
  • The Database is using uppercase letter value of the "DB_UNIQUE_NAME"
  • If "ddbmcon" debug is enabled, the following message is seen:
Backup piece taken in session xxxx have backup tag mismatch.

Cause

The RMAN AGENT library ("libddobk.so") converts into lower case the value of argument DBUNIQUE_NAME coming from the RMAN script. It fails to find the database in the .app.settings file because the database name is written in uppercase.
 
NOTE: DBUNIQUE_NAME is a mandatory argument for self-service backups in an Oracle Data Guard environment. If the parameter is not set, the backup completes with exceptions.

Resolution

Fix:
  • Upgrade PowerProtect Data Manager and RMAN agent to version 19.5 or later.
Workaround:
  • Manually update the value of the "dbUniqueName" in the file "<RMAN_AGENT_INSTALL>/settings/.app.settings" into lowercase.
Example:
.app.settings show the database name in uppercase.  
 <asset>
                                        <dbUniqueName>ORCL21C</dbUniqueName>
                                        <name>2349776941</name>
Change the database name to lowercase and save the file. 
 <asset>
                                        <dbUniqueName>orcl21c</dbUniqueName>
                                        <name>2349776941</name>

Also, ensure that the RMAN script has the variable "DBUNIQUE_NAME" set when allocating the channel.
Example: 
ALLOCATE CHANNEL CH0 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=<boost_su>, BACKUP_HOST=<dd>, RMAN_AGENT_HOME=<RMAN_AGENT_INSTALL>, ORACLE_HOME=<oracle_install>, DBUNIQUE_NAME=ORCL21C)';
Article Properties
Article Number: 000216279
Article Type: Solution
Last Modified: 07 Aug 2023
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.