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

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

この記事は次に適用されます： この記事は次には適用されません： この記事は、特定の製品に関連付けられていません。 すべての製品パージョンがこの記事に記載されているわけではありません。
他のリソースを確認する

現象

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.

原因

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.

解決方法

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)';
文書のプロパティ
文書番号: 000216279
文書の種類: Solution
最終更新: 07 8月 2023
バージョン:  2
質問に対する他のDellユーザーからの回答を見つける
サポート サービス
お使いのデバイスがサポート サービスの対象かどうかを確認してください。