Solved

Oracle Agnentless Backups

  • 1 June 2023
  • 4 replies
  • 253 views

Badge +8

Hi All.

I am busy configuring agentless backups for Oracle.

The RMAN output is below.

RMAN> run

2> {

3> allocate channel ch1 type sbt PARMS="SBT_LIBRARY=/u01/app/commvault/cvpluginbin/libcvobk_thinlibrary.so";

4> allocate channel ch2 type sbt PARMS="SBT_LIBRARY=/u01/app/commvault/cvpluginbin/libcvobk_thinlibrary.so";

5> send "--cv-host zadr270cvltma01 --cv-port 8400 --cv-clientname rm01.corp.dsarena.com";

6> backup incremental level = 0 format='%d_%u' database plus archivelog;

7> }

 

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=43 device type=SBT_TAPE

channel ch1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

 

allocated channel: ch2

channel ch2: SID=848 device type=SBT_TAPE

channel ch2: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

 

sent command to channel: ch1

sent command to channel: ch2

 

 

Starting backup at 01-JUN-23

current log archived

channel ch1: starting archived log backup set

channel ch1: specifying archived log(s) in backup set

input archived log thread=1 sequence=20 RECID=1570 STAMP=1138366761

channel ch1: starting piece 1 at 01-JUN-23

RMAN-03009: failure of backup command on ch1 channel at 06/01/2023 12:59:22

ORA-19506: failed to create sequential file, name="DLPUAT03_g11tk699", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: non RMAN, but media manager or vendor specific failure, error text:

   sbtbackuppp2: Failed during execution of function cvbr_open  retCode = [-1] error code = -1 errorString = 0xFFFFFFFF:{CVBkpRstWrapper::Run(678)/Int.-1.0xFFFFFFFF}

channel ch1 disabled, job failed on it will be run on another channel

channel ch2: starting archived log backup set

channel ch2: specifying archived log(s) in backup set

input archived log thread=1 sequence=20 RECID=1570 STAMP=1138366761

channel ch2: starting piece 1 at 01-JUN-23

released channel: ch1

released channel: ch2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 06/01/2023 12:59:23

ORA-19506: failed to create sequential file, name="DLPUAT03_g21tk69a", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: non RMAN, but media manager or vendor specific failure, error text:

   sbtbackuppp2: Failed during execution of function cvbr_open  retCode = [-1] error code = -1 errorString = 0xFFFFFFFF:{CVBkpRstWrapper::Run(678)/Int.-1.0xFFFFFFFF}

 

RMAN> exit

 

The files were extracted as below:

/u01/app/commvault/cvpluginbin:

oracle:dlpuat03@rm01$ ls -l

total 15812

-rwxr-xr-x 1 oracle oinstall    31000 Apr  6  2019 CVBkpRstWrapper

-rw-r--r-- 1 oracle oinstall  3212702 May 29 17:38 CVOraclePlugin.tar.gz

-rwxr-xr-x 1 oracle oinstall    57632 Dec 22  2018 libcvobk_thinlibrary.so

-rwxr-xr-x 1 oracle oinstall 12843168 Apr  6  2019 libCVOpenBackupStatic.so

-rw-r--r-- 1 oracle oinstall     4347 Apr  9  2019 Readme.txt

 

 

I have deployed this in my lab environment where it works as expected.

Any ideas, please?

 

Thanks.

Ignes

 

 

icon

Best answer by Iggy 20 June 2023, 11:51

View original

4 replies

Userlevel 2
Badge +7

@Iggy - Based on the error message reading from bottom up it appears there is a possible permission issue. Followed by communication issue. Without all the logs it’s hard to tell, but would check permissions and then validate network connectivity between all host involved.

 

Mark

Badge +8

Hello Mark.

Can you elaborate on the permissions?

Would this be the oracle user that is required to connect to the database or some permission on a folder/file level within the OS?

Cheers.

Ignes

 

Userlevel 2
Badge +7

This thread goes into details on what to check. 

 

Badge +8

Hi,

The server is multi-homed so the connectivity back from Media Agent to the Oracle client was going to the incorrect interface.

Routing was corrected and is now working.

 

Regards,

Ignes

 

Reply