Gunther Oracle APEX und Datenbank Wiki

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)

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!

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