DBCS 12.2.0.1 (12.2.0.1.180116) Automatic and on-demand Backup Fail


SYMTHOMS

  1. Automatic backups are not performed
  2. 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 😉

IT

javier mugueta View All →

Me and my circumstance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: