===== 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:

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

=== Lösung ===

Zuvor einen Dummy Tape Treiber laden.

Ablauf:

<code sql>

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!

</code>


==== Quellen ====

  * http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta005.htm#RCMRF103