Oracle Setting Flash Recovery Area Location and Size


The flash recovery area location and size are specified by the initialization parameters DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE.

To change the flash recovery area location and size:

  1. Using SQL Command Line, log in and connect to the database as SYSDBA.
  2. To change the size of the flash recovery area, enter the following command at the SQL Command Line prompt:
    ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = new_size;
    where new_size can be of the format nK (kilobytes), nM (megabytes) or nG (gigabytes).

    For example, to set the flash recovery area size to 20 gigabytes, enter the following command:

    ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G;
  3. To change the location of the flash recovery area, enter the following command at the SQL Command Line prompt:
    ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'new_path';
    where new_path is an absolute path to the new directory for the flash recovery area. The path must exist. (The ALTER SYSTEM command cannot create directories.)

    For example, in Windows, to set the flash recovery location to the FRA directory on the E: drive, enter the following command:

    ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'E:\FRA';

Leave a Reply

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