Database Backup and Recovery (MOSC)

MOSC Banner

Flash recovery area full. Need steps to clear and restart flash recovery without impacting DR?

edited Feb 17, 2016 8:28PM in Database Backup and Recovery (MOSC) 9 commentsAnswered

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 FILE0000
REDO LOG0000
ARCHIVED LOG2.092.061740
BACKUP PIECE0000
IMAGE COPY38.60130
FLASHBACK LOG19.5819.588020
FOREIGN ARCHIVED LOG0000
AUXILIARY DATAFILE COPY0000

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center