- 论坛徽章:
- 0
|
大家好!我的是ORACLE10G,但是我用rman备份到 TIVOLI上但是不能够删除,请大家帮我诊断一下:
我删除的时候总是提示错误,我怀疑是tivoli的tsm设置的参数问题,可是我不知道怎么加参数
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
12 B F A SBT_TAPE 19-JUL-06 1 1 NO TAG20060719T121911
13 B F A SBT_TAPE 19-JUL-06 1 1 NO TAG20060719T121911
14 B F A SBT_TAPE 19-JUL-06 1 1 NO TAG20060719T123527
17 B F A SBT_TAPE 19-JUL-06 1 1 NO TAG20060719T172130
18 B F A SBT_TAPE 19-JUL-06 1 1 NO TAG20060719T172130
RMAN> allocate channel for maintenance type 'sbt_tape' parms='ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=646 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Tivoli Data Protection for Oracle: version 5.2.0.0
RMAN> crosscheck backup;
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=df_596204351_26_1 recid=12 stamp=596204352
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=df_596204756_27_1 recid=13 stamp=596204757
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0thoinof_1_1 recid=14 stamp=596205327
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=11hoj8gq_1_1 recid=17 stamp=596222491
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=12hoj8ur_1_1 recid=18 stamp=596222939
Crosschecked 5 objects
RMAN> change backupset 12 delete;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
12 12 1 1 AVAILABLE SBT_TAPE df_596204351_26_1
Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at 08/23/2006 11:21:09
ORA-19509: failed to delete sequential file, handle="df_596204351_26_1", parms=""
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1126E (RC27) The file space cannot be deleted because this node does not have
permission to delete archived or backed up data. |
|