===== 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 ====
* http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta005.htm#RCMRF103