Avamar: Oracle Backups: All Concurrent Oracle Backups of Pluggable Databases May Fail if One of Those Backups Fail When a Taskfile is Used
Summary: This article provides a workaround for concurrent Oracle backup failures of pluggable databases.
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
In an Oracle Multi-Tenancy architecture a Customer may have multiple pluggable databases that can be backed up in parallel using different rman scripts. If one of the backups for a pluggable database fails, then all the other pluggable database backups that are running in parallel may likely fail as well. This condition only happens if a taskfile is used in the rman script.
Error message
Example
connect target /
run {
allocate channel t1 type sbt PARMS 'SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so' SEND '"--prefix=19c/PDB1/" "--flagfile=/home/oracle/flagfile.txt" "--taskfile=/home/oracle/taskflag1.txt" "--bindir=/usr/local/avamar/bin" "--cacheprefix=PDB1" "--vardir=/usr/local/avamar/var"' trace 5;
backup format "PDB1_%U" filesperset 4 incremental level 0 pluggable database PDB1;
}
Error message
channel t1: starting piece 1 at 13-APR-22 released channel: t1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 04/13/2022 11:15:11 ORA-27192: skgfcls: sbtclose2 returned error - failed to close file ORA-19511: non RMAN, but media manager or vendor specific failure, error text: sbtclose2: invalid response from avoracle
NOTE: This KB article does not apply if:
- The backup is scheduled from Avamar server.
- If there is NO --taskfile in the rman script used to do backups.
Cause
The product uses Oracle views to find the backup status. Queries to the Oracle views are repeated during the entire backup searching for FAILED/ERRORS/RMAN-03099 keywords in their output, if one of those keywords is found then the backup is marked as failed, if not the backup is marked as completed.
The problem happens during concurrent backups of two pluggable databases. For example PDB1 and PDB2, if PDB2 backup fails, PDB1 backup will also fail, as it is finding in the query output of the failure of PDB2.
The problem happens during concurrent backups of two pluggable databases. For example PDB1 and PDB2, if PDB2 backup fails, PDB1 backup will also fail, as it is finding in the query output of the failure of PDB2.
Resolution
Workaround
or
- Remove the taskfile from the rman script.
or
- Schedule the backup from Avamar Server/Scheduler.
Affected Products
Avamar Plug-in for OracleArticle Properties
Article Number: 000198426
Article Type: Solution
Last Modified: 14 Dec 2022
Version: 5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.