Setup Flashrecovery

Flash recovery for SBLDEV2

STEPS FOR SETTING UP FLASH RECOVERY

Set the parameters db_recovery_file_dest_size before setting db_recovery_file_dest in the init.ora file

DB_RECOVERY_FILE_DEST_SIZE=80G

DB_RECOVERY_FILE_DEST=/fra

SQL> alter system set db_recovery_file_dest_size=90 GB scope=both;

SQL>alter system set db_recoevry_file_dest=’/fra’ scope=both;

SQL>alter system set log_archive_dest_1=’location=’/oracle/oraarch’ scope=both

SQL>alter system set log_archive_dest_2=’location=USE_DB_RECOVERY_FILE_DEST’ scope=both