Please try to add next lines in opt file
TDPO_TRACE_FLAGS ORCLEVEL0
TDPO_TRACE_FILE /usr/tivoli/tsm/client/oracle/bin64/tdpo.trc
to have trace file. It is better to touch trace file before backup and check
write permissions for Oracle HOME owner.
Grigori G. Solonovitch
Senior Technical Architect
Information Technology Bank of Kuwait and Middle East http://www.bkme.com
Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: G.Solonovitch AT bkme
DOT com
Please consider the environment before printing this Email
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Botelho, Tiago (External)
Sent: Wednesday, September 16, 2009 12:06 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TSM Dp for Oracle - rman command error
Hello,
I have a problem backing up the Oracle DB (Oracle 10g).
I received the following rman error log:
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 16 09:55:35
2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: HLSUTF (DBID=478657477)
RMAN> run {
2> allocate channel 'ch1' type 'SBT_TAPE' parms
3>
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4>
5>
6> allocate channel 'ch2' type 'SBT_TAPE' parms
7>
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
8>
9> backup incremental level 0
10> format 'ORACLE_BCK_L0_ENL_%s_%t_%p_%u.dbf'
11> database;
12>
13> sql 'alter system archive log current';
14>
15> backup
16> format 'ORACLE_ARC_ENL_%s_%t_%p_%u.dbf'
17> archivelog all
18> delete input;
19>
20> backup
21> format 'ORACLE_CFILE_ENL_%s_%t_%p_%u.dbf'
22> current controlfile;
23>
24> release channel ch1;
25> release channel ch2;
26> }
27>
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 ch1 channel at 09/16/2009
09:55:39
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
Additional info:
1.
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 2.0
(C) Copyright IBM Corporation 1997, 2009. All rights reserved.
Data Protection for Oracle Information
Version: 5
Release: 5
Level: 2
Sublevel: 0
Platform: 64bit TDP Oracle AIX
Tivoli Storage Manager Server Information
Server Name: ORACLE_GRID
Server Address: 10.81.35.29
Server Type: AIX-RS/6000
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: ORACLE_GRID_34
Node Type: TDP Oracle AIX
DSMI_DIR: /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /usr/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license
data
2.
lrwxrwxrwx 1 oracle dba 19 15 Set 17:04 libobk.a ->
/usr/lib/libobk64.a
3.
cat tdpo.opt
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /usr/tivoli/tsm/client/oracle/bin64/oracle_tsm.log
TDPO_FS oracle_grid
TDPO_NODE ORACLE_GRID_34
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1
TDPO_NUM_FMT 1
TDPO_TIME_FMT 1
Any help?
Thank you
Best regards
Tiago
Please consider the environment before printing this Email.
"This email message and any attachments transmitted with it may contain
confidential and proprietary information, intended only for the named
recipient(s). If you have received this message in error, or if you are not the
named recipient(s), please delete this email after notifying the sender
immediately. BKME cannot guarantee the integrity of this communication and
accepts no liability for any damage caused by this email or its attachments due
to viruses, any other defects, interception or unauthorized modification. The
information, views, opinions and comments of this message are those of the
individual and not necessarily endorsed by BKME."
|