My Oracle Support Banner

ORA-19511 and KBHS-01404 error during the restore from ZDLRA to other server (Doc ID 2360408.1)

Last updated on JANUARY 12, 2020

Applies to:

Zero Data Loss Recovery Appliance Software - Version 12.1.1.1.8 to 12.1.1.1.8
Information in this document applies to any platform.

Symptoms

On : 12.1.1.1.8.201705 version, Recovery from ZDLRA data loss

When attempting to restore the database db1 to other Exadata environment,
the following error occurs.

ERROR
-----------------------
released channel: t8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/14/2018 15:30:34
ORA-19870: error while restoring backup piece <BP_NAME>
ORA-27190: skgfrd: sbtread2 returned error

ORA-19511: Error received from media manager layer, error text:   KBHS-01404: See trace file /u01/app/oracle/diag/rdbms/xxx/xxxx/trace/sbtio_XXXXXXXX.log for details

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run {
allocate channel t1 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
allocate channel t2 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
allocate channel t3 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
allocate channel t4 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
allocate channel t5 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
allocate channel t6 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
allocate channel t7 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
allocate channel t8 device type 'SBT_TAPE' format '%U_%d' PARMS "SBT_LIBRARY=/u01/app/oracle/product/11.2.0.4/PATH/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/11.2.0.4/PATH/dbs/ra_wallet credential_alias=backupingest-scan.db1.com:1521/zdlra')";
set newname for database to '+<DB_NAME>';
restore database;
switch datafile all;
switch tempfile all;
}

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users cannot restore database <DB_NAME> to other Exadata environment properly due to this issue.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.