Flash recovery area full. Need steps to clear and restart flash recovery without impacting DR?
Will need help clearing and reinitializing the flash recovery area. We do not mind missing flash back functional for for the time being.
400/430G is used
Have read a lot of articles , which recommended backing up to a tetiary device, turning flash on and off etc
We seem to have a lot of free space that has to be recovered .
select * from v$flash_recovery_area_usage;
CONTROL FILE | 0 | 0 | 0 | 0 |
REDO LOG | 0 | 0 | 0 | 0 |
ARCHIVED LOG | 2.09 | 2.06 | 174 | 0 |
BACKUP PIECE | 0 | 0 | 0 | 0 |
IMAGE COPY | 38.6 | 0 | 13 | 0 |
FLASHBACK LOG | 19.58 | 19.58 | 802 | 0 |
FOREIGN ARCHIVED LOG | 0 | 0 | 0 | 0 |
AUXILIARY DATAFILE COPY | 0 | 0 | 0 | 0 |