Oracle Backup

     1.  Steps to configure Fast Recovery Area (FRA)

SQL> set ORACLE_SID=<ORACLE_SID_NAME> (this command not required if there is only one DB running on the server)

SQL> alter system set db_recovery_file_dest_size = 100G scope=both; (depends on the Disk space available)

SQL> alter system set db_recovery_file_deste = 'd:\fast_recovery_area' scope=both; (d:\fast_recovery_area must be created)

     2.  Steps to configure ARCHIVELOG mode

SQL> alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';

SQL>shutdown immediate

SQL>startup mount

SQL>alter database archivelog;

SQL> alter database flashback on;

SQL> alter database open;

SQL> archive log list;

SQL> alter system switch logfile; (this will create the archive log files in FRA)

     3. Steps to configure RMAN parameters;

C:\> rman target /

RMAN> show all;

RMAN> configure retention policy to recovery window of 3 days; (you can specify 3 or 7 days as per the policy)

RMAN> configure backup optimization on;

RMAN> configure controlfile autobackup on;

RMAN> show all;