This content has been marked as final. Show 4 replies
Run crosscheck archivelog all
Crosscheck to make RMAN know that this file(s) is not available for backup anymore :
RMAN>crosscheck archivelog all;
Then try to run your backup again. Don't sleep until you have a good backup. Next time consider posting your exact Oracle version, OS version, the error's you are getting etc.
Also "space issue" is very vague. Space in your FRA? OS space in general? Both? Before trying a backup how much cleanup do you need to do and how do you plan on doing it?
One more tip. Posting anything as "Urgent" will generally get you nothing but negative feedback. Search the General forum for "urgent" and you'll see what I mean.
Edited by: mseberg on Dec 4, 2012 6:54 PM
Since you have provided no feedback or new information in the last 15 hours I'm finding this hard to believe.
Edited by: mseberg on Dec 5, 2012 9:41 AM
1) Fix your space issue
2) IMMEDIATELY EXECUTE a FULL BACKUP.
3) Any missing archivelogs are gone. Use the new full backup as your restore point.
4) Pray you don't need to restore back to 2-Nov.
5) If you do, you may also need to execute: alter DBA update resume;
the last statement because as a DBA, monitoring backups is imperative. It is NOT OPTIONAL and I would terminate a DBA that allowed failed backups to persist for > 1 month.
Even though I typically have a separate archivelog backup that executes, I also ensure that they are available at the OS level and ensure that there is a separate OS backup of the archivlog and backup destinations to tape for just such a scenario. Anything less is negligence.
With 11gR2 if you are on ASM, you can (as of 22.214.171.124) have your backups and archivelog destination on ACFS (in RAC environments). If Standalone ASM, then just make sure you have a sufficiently sized file system to accommodate your backups and archivelogs. Remember, doing proper database backups of all files via RMAN or COLD backup or whatever is NON-NEGOTIABLE. If your sys admin or management is skimping on storage, then they deserve the inevitable outcome - a corrupt and non-recoverable database.
With all due respect to you, but I think we should rethink when try to help (or spend time) some people in the forum.
If it's a technical matter...no problem, but if it's support with "urgent" matters should be completely ignored.
You're an awesome professional. In the business environment the help that you supply here has a very high cost ($$$) and you do this for free.
Let us value our knowledge ... that we take years to acquire it.
Are Oracle Discussion Forums for obtaining support from Oracle?
No; Oracle Discussion Forums are designed for peer-to-peer knowledge sharing only; people with urgent support matters should always use MetaLink. (There are rare exceptions: users of some free products, such as Oracle SQL Developer and Oracle Database XE, do in fact use Oracle Discussion Forums as their support channel.)
Thanks for the kind words and the feedback. Point taken.
If it helps boredom is a large part of it.