flash_recovery_area full-- how do you use RMAN to delete directories of .arc files
Posted on 2008-11-09
About a week ago we turned archivelog mode on in an 11g oracle server. The flash_recovery_area is now full, and redo logs can't be archived, so the database won't open.
I need to delete some of the dated directories containing the .arc files using rman. What is the exact process for connecting using rman and for deleting these directories?
Also-- I use dbconsole to RMAN to backup the database to local disk, and Computer Associates Arcserve to backup to tape. I expected the archivelogs to be deleted (like they are truncated in MS SQL server) when a backup is done. Is this not a correct expectation?
I've read that one can also free up space by backing up components of the flash_recovery_area. I can only do this to disk. Anyone know exactly the complete correct syntax for rman?