When trying to take Oracle Database Cloud Backup using Cloud Backup AssistantI got the below errors.
Error:
-> API::ERROR KBHS-00715 HTTP CONNECTION ERROR
-> API::ERROR -Detail
-> API::ERROR KBHS-00715: HTTP error occurred 'oracle-error'
-> API::ERROR OBKUP:: ..... FAIL
-> API::ERROR ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
-> API::ERROR ORA-19554: error allocating device, device type: SBT_TAPE, device name:
-> API::ERROR ORA-27023: skgfqsbi: media manager protocol error
After some digging realized that this is a known issue with Oracle Cloud Backup Assistant.
[root@salesdev ~]#
/var/opt/oracle/bkup_api/bkup_api bkup_status
DBaaS Backup API V1.5
@2016 Multi-Oracle home
DBaaS Backup API V1.5
@2015 Multi-Oracle home
-> Action :
bkup_status
-> logfile:
/var/opt/oracle/bkup_api/log/bkup_api.log
Warning: unable to get current configuration
of: catalog
* Current backup
settings:
* Last registered
Bkup: 04-01 08:44 API::9070:: Starting dbaas backup process
* Bkup state: finished
**************************************************
* API History: API
steps
API:: NEW PROCESS 9070
API:: Starting dbaas backup process
* DBaaS Error trace:
-> API::ERROR An http error was detected please verify your
connectivity
-> API::ERROR Cannot complete the backup to cloud storage
-> API::ERROR KBHS-00715 HTTP CONNECTION ERROR
-> API::ERROR -Detail
-> API::ERROR KBHS-00715: HTTP error
occurred 'oracle-error'
-> API::ERROR OBKUP:: ..... FAIL
-> API::ERROR ORA-19511: non RMAN, but
media manager or vendor specific failure, error text:
-> API::ERROR ORA-19554: error allocating
device, device type: SBT_TAPE, device name:
-> API::ERROR ORA-27023: skgfqsbi: media
manager protocol error
-> API::ERROR RMAN-00569: ===============
ERROR MESSAGE STACK FOLLOWS ===============
-> API::ERROR RMAN-03002: failure of backup
command at 04/01/2018 04:45:18
-> Oracle Error
Codes found:
KBHS-00712: ORA-29024 received from
local HTTP service
ORA-27023: skgfqsbi: media manager
protocol error
ORA-19554: error allocating device,
device type: SBT_TAPE, device name:
ORA-19511: non RMAN, but media
manager or vendor specific failure, error text:
*
* RETURN CODE:1
Fix;
Include the variable _OPC_VALIDATE_CERT=TRUE
in the opc<SID>.ora configuration file under $ORACLE_HOME/dbs
[oracle@salesdev dbs]$
cat opcsalesdev.ora
OPC_HOST=https://shaiksameer.us.storage.oraclecloud.com/v1/Storage-shaiksameer
OPC_WALLET='LOCATION=file:/u01/app/oracle/admin/salesdev/opc_wallet
CREDENTIAL_ALIAS=alias_opc'
OPC_CONTAINER=dbbackups
_OPC_DEFERRED_DELETE=true
_OPC_VALIDATE_CERT=TRUE
Hope this will save some time in your troubleshooting efforts.
