-
Error Message
I tried to run the delete obsolete commands, this is what Im getting:
RMAN> delete noprompt obsolete expired backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "expired": expecting one of: "device, high, orph
an, redundancy, recovery, ;, until"
RMAN-01007: at line 1 column 26 file: standard input
RMAN>
WHat is it looking for?
Paul
-
Hi Paul
Apologies please try
Code:
RMAN>DELETE NOPROMPT EXPIRED BACKUP ;
RMAN>DELETE NOPROMPT EXPIRED ARCHIVELOG ALL ;
RMAN>DELETE NOPROMPT EXPIRED COPY;
And please run your backupscript again and post the results if you get the error that you are getting
regards
Hrishy
-
Delete
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
-
Hi
Please try
Code:
allocate channel c1 for maintenance device type disk;
crosscheck backup;
delete noprompt obsolete;
and then run the
regards
Hrishy
-
Error
Tried to run that command and got an error:
RMAN> allocate channel c1 for maintenance device type disk;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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!
Paul
-
Hi Paul
Apologies again as i dont have a database to test my commands at the moment
Here is what you need to do
Code:
allocate channel for maintenance device type disk ;
crosscheck backup;
delete noprompt obsolete
-
Errors
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?
-
Hi
Please try
Code:
run {
allocate channel device type sbt;
delete force obsolete;
}
-
delete worked
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?
Paul
Last edited by pam61; 09-25-2007 at 09:28 AM.
Reason: Added info
-
Hi
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
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|