tsmadmin27
ADSM.ORG Member
Hello,
I need some help setting up TDP for Oracle 9.2.0.3.0 for the first time on Windows. I have read the sg246249.pdf from IBM's website but I am having difficulty running the backup command. I am not familar with Oracle and any help would be appreciated. Here is what I have gotton so far.
TSM Version 5.2.2.2
Windows Server 2000
TDP Client 5.20
Library 3584 with LTO2 drives (fibre channel attached)
D:\Program Files\Tivoli\TSM\AgentOBA>aobpswd
***************************************************************
* ADSMConnect Agent for Oracle Backup *
* Password file initialization/update program. *
***************************************************************
Enter your current password: ********
Enter your new password: ********
Enter your new password again: ********
Your new password has been accepted on the ADSM server.
D:\Program Files\Tivoli\TSM\AgentOBA>set ORACLE_SID=RCADMDEV
D:\Program Files\Tivoli\TSM\AgentOBA>rman nocatalog
Recovery Manager: Release 9.2.0.3.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target ********/*******@RCADMDEV
connected to target database: RCADMDEV (DBID=4234371729)
using target database controlfile instead of recovery catalog
RMAN> shutdown immediate
database dismounted
Oracle instance shut down
RMAN> startup force dba
Oracle instance started
database mounted
database opened
Total System Global Area 454106932 bytes
Fixed Size 454452 bytes
Variable Size 293601280 bytes
Database Buffers 159383552 bytes
Redo Buffers 667648 bytes
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 454106932 bytes
Fixed Size 454452 bytes
Variable Size 293601280 bytes
Database Buffers 159383552 bytes
Redo Buffers 667648 bytes
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms
3> 'ENV=(DSMO_DEBUG=49)';
4> backup (database);}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 12/13/2005 13:17:21
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
OSD-02512: Message 2512 not found; product=RDBMS; facility=SOSD
I need some help setting up TDP for Oracle 9.2.0.3.0 for the first time on Windows. I have read the sg246249.pdf from IBM's website but I am having difficulty running the backup command. I am not familar with Oracle and any help would be appreciated. Here is what I have gotton so far.
TSM Version 5.2.2.2
Windows Server 2000
TDP Client 5.20
Library 3584 with LTO2 drives (fibre channel attached)
D:\Program Files\Tivoli\TSM\AgentOBA>aobpswd
***************************************************************
* ADSMConnect Agent for Oracle Backup *
* Password file initialization/update program. *
***************************************************************
Enter your current password: ********
Enter your new password: ********
Enter your new password again: ********
Your new password has been accepted on the ADSM server.
D:\Program Files\Tivoli\TSM\AgentOBA>set ORACLE_SID=RCADMDEV
D:\Program Files\Tivoli\TSM\AgentOBA>rman nocatalog
Recovery Manager: Release 9.2.0.3.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target ********/*******@RCADMDEV
connected to target database: RCADMDEV (DBID=4234371729)
using target database controlfile instead of recovery catalog
RMAN> shutdown immediate
database dismounted
Oracle instance shut down
RMAN> startup force dba
Oracle instance started
database mounted
database opened
Total System Global Area 454106932 bytes
Fixed Size 454452 bytes
Variable Size 293601280 bytes
Database Buffers 159383552 bytes
Redo Buffers 667648 bytes
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 454106932 bytes
Fixed Size 454452 bytes
Variable Size 293601280 bytes
Database Buffers 159383552 bytes
Redo Buffers 667648 bytes
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms
3> 'ENV=(DSMO_DEBUG=49)';
4> backup (database);}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 12/13/2005 13:17:21
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
OSD-02512: Message 2512 not found; product=RDBMS; facility=SOSD