dakota5
asked on
flash_recovery_area full-- how do you use RMAN to delete directories of .arc files
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.