backup Windows

[Roshan]

Hello,
 
I am configuring RMAN backup for a database on Windows. Filesystem backup is also scheduled on Networker(tape)
 
I am getting the error below when launching RMAN backup on disk(archivelog backup)
 channel.png


 
How can I modify my script on windows to include
ALLOCATE CHANNEL FOR MAINTAINANCE DEVICE TYPE DISK;
 (Doc ID 567555.1)
 
bat file:
 
set oracle_sid=lfiche
rman target / cmdfile=E:\backuplfiche\backup_weekly_db1.cmd
log=E:\backuplfiche\log_full\backup_complete_db1_%date.log
 
 
CMD FILE(E:\backuplfiche\backup_weekly_db1.cmd )
run{
 
 
ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
 
 
ALLOCATE CHANNEL C2 DEVICE TYPE DISK;
 
 
ALLOCATE CHANNEL C3 DEVICE TYPE DISK;
 
 
ALLOCATE CHANNEL C4 DEVICE TYPE DISK;
 
sql 'alter system switch logfile';
crosscheck archivelog all;
backup format 'E:\backuplfiche\LF_al_%d_%U' archivelog all;
delete noprompt archivelog until  time 'sysdate-7';
delete noprompt obsolete;
 
 
}
 
Regards,
Roshan

[ErmanArslansOracleBlog]

To be able delete those backups add the maintanence type channel.

If those backupus are on disks -> allocate channel for maintenance type disk;
If those backupus are on tape -> allocate channel for maintenance device type 'sbt_tape' PARMS '...'; (contact your vendor(backup management software owner) to get the actual tape parameters and replace the  '...' .)

[ErmanArslansOracleBlog]

Just do these allocations before your rman delete commands;

Example:

RUN {
     ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
     ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
     DELETE BACKUPSET 1,2,3,4,5;
}