RMAN Katalog "aufräumen" zum Beispiel nach einem Umzug

Problem : Nach einem DB Umzug stehen die alten tape Library Treiber nicht mehr zur Verfügung

Ein „crosscheck“ führt zu folgenden Problem: 

RMAN-03002: failure of delete command at 12/18/2013 13:38:08
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

Lösung

Zuvor einen Dummy Tape Treiber laden.

Ablauf: 

rman
CONNECT target /
 
#first allocate dummy tape channel 
allocate channel FOR maintenance device TYPE sbt parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/tmp)';
 
#check 
CROSSCHECK BACKUP;  
CROSSCHECK BACKUP OF ARCHIVELOG ALL;
CROSSCHECK copy OF controlfile;
 
#delete
DELETE EXPIRED BACKUP;
DELETE EXPIRED ARCHIVELOG ALL;
DELETE EXPIRED copy OF controlfile;
 
#delete obsolte
DELETE obsolete;
 
#Release Channel
RELEASE CHANNEL;
 
 
 
# Allocate a Disk Channel FOR the rest OF the files
 
allocate channel FOR maintenance device TYPE DISK;
 
#old file backups
 
CROSSCHECK BACKUP;  
CROSSCHECK BACKUP OF ARCHIVELOG ALL;
CROSSCHECK copy OF controlfile;
 
DELETE EXPIRED BACKUP;
DELETE EXPIRED ARCHIVELOG ALL;
DELETE EXPIRED copy OF controlfile;
 
DELETE obsolete;
 
RELEASE CHANNEL;
 
 
#clean!

Quellen