And please run your backupscript again and post the results if you get the error that you are getting
09-19-2007, 08:14 AM
Ok, I ran the 3 commands to delete and they ran fine. But when I run the REPORT OBSOLETE command, it still lists a whole mess of stuff. So I ran DELETE OBSOLETE, and this failed. The error said: "no channel allocated for maintenance (of an appropriate type)". Could this be because it is trying to delete some of the BackupExec jobs? I see jobs listed in the report that have "BE_" in the front of the name. The report is still showing the "+FLASH" datafile copes also. Thanks
09-20-2007, 12:37 AM
allocate channel c1 for maintenance device type disk;
delete noprompt obsolete;
and then run the
09-20-2007, 03:45 PM
Tried to run that command and got an error:
RMAN> allocate channel c1 for maintenance device type disk;
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "for"
RMAN-01008: the bad identifier was: c1
RMAN-01007: at line 1 column 18 file: standard input
I've been in meetings all day, so I havent had a chance to look it up. I'll see if I can fix it later. I would much rather be learning more Oracle!
09-20-2007, 09:25 PM
Apologies again as i dont have a database to test my commands at the moment
Here is what you need to do
allocate channel for maintenance device type disk ;
delete noprompt obsolete
09-24-2007, 08:16 AM
I'm still getting a failure for the Delete Obsolete command. The other 2 worked, but when I run the delete it still says no cahannel allocated for maiintenance(of an appropriate type). I don't get that, it allocates the disk ok. Any thoughts?
09-25-2007, 12:43 AM
allocate channel device type sbt;
delete force obsolete;
09-25-2007, 09:16 AM
Hey thay worked! deleated a whole bunch of obsolete archive logs. Great! Thanks! Deleted 899 objects. I noticed it deleted the stuff on the +FLASH and some of the stuff from BE. HOw come allocating the SBT worked and not the disk?
09-26-2007, 12:59 AM
Did the folks before you leave some documentation behind ?
It worked because sbt channel was used earlier to make copies etc.You need to look at the earlier docs and all what those people gave you before you were there.
Can you please run the oracle reccommended backup strategy and then let us know if you are still hitting that error for which you started this thread