Search This Blog

Sunday, September 18, 2011

How to Use Flash Recovery Area as your archivelog location

First set :
db_recovery_file_dest='/oracle/flashRecoveryArea'
db_recovery_file_dset_size=<90% of the size '/oracle/flashRecoveryArea'>
Second :
log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' ;