tsm-anr2579e ORA-19511 (Oracle Backup)

Environment: Oracle 10g for AIX systems
TSM5.4
IBM with Library LIB3584

Cause of the problem:

After migrating the database, after redeploying the TSM BA client and turning on the DSMC schedule process in the operating system where the new database resides

Q Event * *

Found in today's dispatch task, there is a dispatch failed 126

Problem Analysis:

1. Because the error is not miss, the judgment is not because there is no scheduling, but instead of scheduling the success of the dispatch.

2. Further analysis of the causes based on the TSM Actlog log reveals the following results:

Date/time: 1/16/2015 1:05:38
Message: anr2579e node ora_dbs01 the dispatch DATE for the domain ora_tape. SH failed (return code 126). (Session: 88)

3. The log error in Oracle Rman is:

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============
RMAN-00571: ===========================================================
rman-03009:failure of allocate command on T1 channel at 10/13/2009 09:47:43
Ora-19554:error allocating device, device Type:sbt_tape, device name:
ora-27000:skgfqsbi:failed to initialize storage subsystem (SBT) layer
IBM AIX RISC system/6000 error:106:reserved errno was encountered
Additional information:7011
Ora-19511:error received from Media Manager layer, Error text:
SBT error = 7011, errno = 106, sbtopen:system error
Recovery Manager complete.

4. Verify that the TSM BA client configuration file is correct

Five configuration files for TSM

/usr/tivoli/tsm/client/ba/bin64/dsm.sys

/usr/tivoli/tsm/client/ba/bin64/dsm.opt

/usr/tivoli/tsm/client/api/bin64/dsm.sys

/usr/tivoli/tsm/client/api/bin64/dsm.opt

/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt

are configured correctly.

5. Verify that the following paths have Oracle permissions (because they need to be called in the Rman script)

/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt

and the following content in the file

dsmi_orc_config/usr/tivoli/tsm/client/oracle/bin64/dsm.opt
Dsmi_log/usr/tivoli/tsm/client/oracle/bin
Tdpo_node ora_dbs01
Tdpo_pswdpath/usr/tivoli/tsm/client/oracle/bin64

Results:

These directories are root permissions

Modify Permissions

Chown-r Oracle:dba/usr/tivoli/tsm/client/oracle/bin

Chown-r/usr/tivoli/tsm/client/oracle/bin

Dispatch successfully again ...

This article from "Only" blog, declined reprint!

tsm-anr2579e ORA-19511 (Oracle Backup)