Configure FRA (flash recovery area) Practical

Configure FRA (flash recovery area)

DATABASE = prod

~]$ sqlplus / as sysdba

SQL> show parameter db_recovery_file_dest         (no VALUE)

SQL> exit

~]$ cd prod/

prod]$ mkdir fra

prod]$ cd fra/

fra]$ pwd

fra]$ sqlplus / as sysdba

SQL> alter system set db_recovery_file_dest_size=4g scope=both;

SQL> alter system set db_recovery_file_dest='/u01/home/prod/fra' scope=both;

SQL> show parameter db_recovery_file_dest      (VALUE)

VIEWS:-

db_recovery_file_dest