SYMTHOMS
- Automatic backups are not performed
- Backups fail either launched manually from Oracle Database Cloud Service page or from rman command line:
RMAN> connect target connected to target database: ORCL (DBID=1502300872) using target database control file instead of recovery catalog RMAN> backup device type sbt current controlfile; Starting backup at 04-MAY-18 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 05/04/2018 21:20:17 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27023: skgfqsbi: media manager protocol error ORA-19511: non RMAN, but media manager or vendor specific failure, error text: KBHS-00715: HTTP error occurred 'oracle-error' KBHS-00712: ORA-29024 received from local HTTP service
FOUND IN
DBCS EE 12.2.0.1 180116
DBCS EE 12.2.0.2 180116
DIAGNOSTICS
[root@BRACDBPRO ~]# tail -f /var/opt/oracle/log/ORCL/obkup/obkup.log 2018-05-04 21:00:23 - cmd took 0 seconds 2018-05-04 21:00:23 - Output from cmd perl -p -i -e 's/^.*OBKUP.* //g' /etc/motd run on localhost is: 2018-05-04 21:00:23 - cmd took 0 seconds 2018-05-04 21:00:23 - Output from cmd echo -e '*** OBKUP::ERROR INFO *** OBKUP::ERROR Cannot complete the Archivelogs Backup to Cloud Storage OBKUP::ERROR KBHS-00715 HTTP CONNECTION ERROR OBKUP::ERROR An http error was detected please verify your connectivity *** OBKUP::ERROR END ***' >> /etc/motd run on localhost is: 2018-05-04 21:00:23 - cmd took 0 seconds
SOLUTION THAT WORKED FOR ME
vi /u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcORCL.ora OPC_HOST=https://mxlxxhxtxlsxntxrnxtxxnxl.eu.storage.oraclecloud.com/v1/Storage-mxlxxhxtxlsxntxrnxtxxnxl OPC_WALLET='LOCATION=file:/u01/app/oracle/admin/ORCL/opc_wallet CREDENTIAL_ALIAS=alias_opc' OPC_CONTAINER=BRACDBPRO # jmu 04/05/2018 _OPC_VALIDATE_CERT=TRUE
Perform whatever backup operation to put “things on his place”
[oracle@BRACDBPRO ~]$ rman Recovery Manager: Release 12.2.0.1.0 - Production on Fri May 4 22:58:34 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. RMAN> connect target connected to target database: ORCL (DBID=1502300872) RMAN> backup device type sbt current controlfile; Starting backup at 04-MAY-18 using target database control file instead of recovery catalog allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=1188 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=12.2.0.1 allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: SID=1173 device type=SBT_TAPE channel ORA_SBT_TAPE_2: Oracle Database Backup Service Library VER=12.2.0.1 allocated channel: ORA_SBT_TAPE_3 channel ORA_SBT_TAPE_3: SID=53 device type=SBT_TAPE channel ORA_SBT_TAPE_3: Oracle Database Backup Service Library VER=12.2.0.1 allocated channel: ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_4: SID=1186 device type=SBT_TAPE channel ORA_SBT_TAPE_4: Oracle Database Backup Service Library VER=12.2.0.1 allocated channel: ORA_SBT_TAPE_5 channel ORA_SBT_TAPE_5: SID=51 device type=SBT_TAPE channel ORA_SBT_TAPE_5: Oracle Database Backup Service Library VER=12.2.0.1 channel ORA_SBT_TAPE_1: starting full datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_SBT_TAPE_1: starting piece 1 at 04-MAY-18 channel ORA_SBT_TAPE_1: finished piece 1 at 04-MAY-18 piece handle=2pt235di_1_1 tag=TAG20180504T225858 comment=API Version 2.0,MMS Version 12.2.0.1 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03 Finished backup at 04-MAY-18 Starting Control File and SPFILE Autobackup at 04-MAY-18 piece handle=c-1502300872-20180504-0c comment=API Version 2.0,MMS Version 12.2.0.1 Finished Control File and SPFILE Autobackup at 04-MAY-18 RMAN>
Enjoy 😉
approaching off the bow 