Database Backup and Recovery (MOSC)

MOSC Banner

flashback log file deletion

edited Feb 3, 2012 3:44AM in Database Backup and Recovery (MOSC) 10 commentsAnswered
1) how can i delete  old flashback log file dynamically?2) will it be problem to delete old flashback log file?
3) is it require to shutdown the database while deleting the old flashback log file.

we have set flash_recovery_area 550 GB we are facing space problem so we have to optimize it.

your expert suggestion will be of grate help


i have implemented the following things---

suppose today is 1st feb while running shell script it will remove flashback log 31stjan ...

i have set retention policy 1 days.

following is the my sh script
=====================

#!/bin/sh
#
# Daily Backup
#

. oraenv.oratest

export NLS_DATE_FORMAT="Dy DD-Mon-YYYY HH24:MI:SS"

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