Backup failed using TSM TDP on Oracle 12C

[Former Member]

Hi,

Our backup team has setup backup using TSM TDP  for SAP System running on Windows 2012 with Oracle 12C.

while using backup_dev_type =  rman_util  in init<SID>.sap backup failed with below error

RMAN> connect target *

connected to target database: YD3 (DBID=1176730714)

using target database control file instead of recovery catalog

RMAN> **end-of-file**

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

executing command: SET BACKUP COPIES

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

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

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

RMAN-03009: failure of allocate command on sbt_1 channel at 08/18/2015 08:45:38

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:

   Unable to open from register key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Prole.

RMAN>

but using backup_dev_type = util_file there is no error while taking backup.

we have other system running on Windows 2012 with oracle 11g where we are able to take backup using backup_dev_type =  rman_util with same setup.

has anybody aware of such issue ?

Thanks & Regards,

Kaushal

[Former Member]

Hi Kaushal,

Please check if orasbt.dll is available in the  ORALCE_HOME/bin folder.

If not , please copy it from the tsm installation folder to the oracle home bin folder.

Also check if any sbtio.log are written at user_dump_dest path.

Stop the service OracleServiceSID and restart it.

Test again . May be restart the oracle database as well.

Thanks

Amit

[Former Member]

Hi,

orasbt.dll in present in ORACLE_HOME /BIN ,

have check the sbtio.log but it does not contain any log entry.

Thanks & Regards,

Kaushal

[Former Member]

Kaushal,

Can you check if there are any logs with name dsierror.log in the directory specified with environment variable DSMI_LOG .

Also have you tried restarting the service or database. You need to make sure this dll is loaded by oracle.

Also if there is orasbt.dll available at any other path, just rename it except the one at the tsm installation path and one at the oracle home bin path

Also run this with sidadm user. It should successfully connect to TSM node.

backfm -p $ORACLE_HOME\database\init<SID>.utl

Thanks

Amit

[Former Member]

Hi,

We have restarted both Database and service several times.

No error has reported in dsierror.log.

backfm -p %ORACLE_HOME%\database\init<SID>.utl  executed successfully and connected to TSM server without any issue.

Thanks,

Kaushal

[Former Member]

Ok , what happens when you run backup directly from OS level and not from DB13, with the sidadm user ?

brbackup -u / -c force -t online -m full -p init<SID>.sap  (Full database online)

brbackup -u / -c force -t online -m full -p init<SID>.sap -a -c force -p init<SID>.sap -sd

(Full database online with redolog)

Please also check if the ProLE service is properly configured.  Please check with which user ProLE is running.

Also check as in the error ,the permissions of this path in the registery.

Unable to open from register key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Prole ,

Thanks

Amit