Home » RDBMS Server » Backup & Recovery » Backup ORACLE using TSM [tivoli storage manager]
icon8.gif  Backup ORACLE using TSM [tivoli storage manager] [message #167764] Sun, 16 April 2006 23:03
liulm
Messages: 2
Registered: April 2006
Junior Member
test222/home/oracle/rman>more *log

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: GASSUITE (DBID=867248025)
connected to recovery catalog database

RMAN> run{
2> allocate channel t1 device type sbt parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> sql 'alter system archive log current';
4> backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete input;
5> release channel t1;
6> }
7>
allocated channel: t1
channel t1: sid=25 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

sql statement: alter system archive log current

Starting backup at 16-APR-06
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=127 recid=257 stamp=587936181
input archive log thread=1 sequence=128 recid=260 stamp=587936193
input archive log thread=2 sequence=131 recid=258 stamp=587936185
input archive log thread=2 sequence=132 recid=259 stamp=587936194
channel t1: starting piece 1 at 16-APR-06
channel t1: finished piece 1 at 16-APR-06
piece handle=arch587936205_87_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:04:06
channel t1: deleting archive log(s)
archive log filename=/ora_archive1/1_127.dbf recid=257 stamp=587936181
archive log filename=/ora_archive1/1_128.dbf recid=260 stamp=587936193
archive log filename=/ora_archive2/2_131.dbf recid=258 stamp=587936185
archive log filename=/ora_archive2/2_132.dbf recid=259 stamp=587936194
Finished backup at 16-APR-06

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of release command on t1 channel at 04/16/2006 19:40:56
ORA-03113: end-of-file on communication channel

Recovery Manager complete.
...skipping...

what's going on ??help.

more details refer to http://www.itdata.cn
The best Chinese website : focus on Tivoli and TSM.

Previous Topic: script for hot backup
Next Topic: ORA-03113 and RMAN-03009, how to solve this matter?
Goto Forum:
  


Current Time: Sun Nov 24 10:50:26 CST 2024