Flash Recovery Area

Setting up a Flash Recovery Area

The recovery area is defined by setting two initialization parameters. These two parameters can be dynamically altered or disabled.

  • The db_recovery_file_dest_size sets the disk limit, expressed in bytes
  • The db_recovery_file_dest sets the location for the recovery area

Enabling a Flash Recovery Area

This statement sets the disk limit for recovery area to 100 GB:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST_SIZE = 100G

This statement sets the recovery area destination:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST = ‘/dba/backup/’;

Alter a Flash Recovery Area

This statement alters the size of the recovery area:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST_SIZE = 200G;

Disabling a Flash Recovery Area

This statement disables a recovery area:

SQL> ALTER SYSTEM
SET DB_RECOVERY_FILE_DEST = ‘ ’;

 

Other views that we can get information about redo logs;

-Live log information
SELECT * FROM v $ archived_log k ORDER BY k.first_time DESC;

-General redo log information (size, status etc.)
SELECT * FROM v $ log;

-Redo log directories
SELECT * FROM v $ logfile;

– Redo log history
SELECT * FROM v $ log_history

Hits: 2

Leave a Reply

Your email address will not be published. Required fields are marked *