News

  1. Home
  2. All posts
All posts, Backup by Team Ajara

RMAN-03002: failure of delete command

RMAN-03002: failure of delete command .

Error received while trying to delete failed backups.

 

RMAN> run
2> {
allocate channel t1 type ‘SBT_TAPE’ parms=’ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCLP.opt)’;
delete noprompt force BACKUPSET 72314,72318;
}3> 4> 5>using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=412 device type=SBT_TAPE
channel t1: Data Protection for Oracle: version 7.1.3.0released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

RMAN>

Reason for error:

wrong command .Not given “allocate channel for maintenance” in run block

correct command.

rman target /
run
{
allocate channel for maintenance device type ‘SBT_TAPE’ parms=
‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_ORCLP.opt)’;
delete noprompt force BACKUPSET 72317, 72318;
}

 

why should not we connect to recovery catalog?

  • Backup is taken while connecting to catalog site.
  • Backupset 72314 and 72318 will be referred when connected to controlfile not when connected to recovery catalog.
    so we should not  connect to catalog database,

See also