I have a "Oracle recommended backup" running on disk. It backsup to the FLASH recovery area. The job runs and it completes every time with this warning:
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile n
Where n= 1-19
I tried looking this error up but can't find much info on it. I found some info that said to use the LIST command and then allocate the proper type to stop the error. I'm a little new to Oracle. Where do I see what type needs to be allocated? And how do I change the allocation? I am using a combonation of command line and EM. Thanks for the help
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 1
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 2
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 3
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 4
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 5
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 6
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 7
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 8
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 9
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 10
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 11
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 12
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 13
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 14
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 15
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 16
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 17
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 18
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 19
Finished recover at 11-SEP-07
Starting Control File and SPFILE Autobackup at 11-SEP-07
piece handle=+FLASH/ax/autobackup/2007_09_11/s_632973901.2504.632973903 comment=NONE
Finished Control File and SPFILE Autobackup at 11-SEP-07
released channel: oem_disk_backup
exit;
SHow device type;
RMAN configuration parameters are:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
RMAN> show datafile backup copies;
RMAN configuration parameters are:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
I have Symantec Backup Exec running at other times, it backs up to tape. This backup that is failing is supposed to go to Disk. Thanks for your help!
using target database control file instead of recovery catalog
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
30 1 A 24-AUG-07 5011977798 23-AUG-07 +FLASH/ax/datafile/sys
tem.2130.631249999
32 2 A 24-AUG-07 5011977798 23-AUG-07 +FLASH/ax/datafile/und
otbs1.2123.631249633
23 3 A 24-AUG-07 5011977798 23-AUG-07 +FLASH/ax/datafile/sys
aux.2127.631249883
RMAN>
SYamntec BAckup Exec does backup files onto the tape unit. Thanks for your help!
Hi Hrishy;
I attached the files for those reports, as the outputs were long. The ASM instance is running fine and the FLASH disk group is available in ASM. Those obsolete files, is there something I have to do with those or does Oracle get rid of them. Thanks for all your help!
All 3 logs are in the zip file
Paul
How does your rman backup script look like is it similar to the one below.
Code:
run {
allocate channel oem_backup_disk1 type disk format 'd:\mad3_nightly_backups\%U';
backup incremental level 1 database include current controlfile;
recover copy of database;
backup as BACKUPSET tag 'mybackupset' archivelog all not backed up delete all input;
report obsolete;
crosscheck backup;
crosscheck copy;
report need backup;
report unrecoverable;
release channel oem_backup_disk1;
}
You can get rid of those obsolete copies using the following rman commands
This job was set up in EM. Here is the "Daily backup Script" it generated:
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
}
Am I better off deleting this job from EM and creating a new job in RMAN? I know RMAN gives more power/functionality than EM. Thanks again
Well logically speaking it shouldnt matter much since under the covers those fancy GUI widgets again call RMAN.
What i would like to try is this manually and see what happens
Code:
RMAN>DELETE NOPROMPT OBSOLETE EXPIRED BACKUP
RMAN>DELETE NOPROMPT OBSOLETE EXPIRED ARCHIVELOG ALL
RMAN>DELETE NOPROMPT OBSOLETE EXPIRED COPY
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
}