Enable the Flashback Recovery
Step 1: Add the initialization parameters
Open the init.ora file and add following parameters:
*.db_recovery_file_dest='/app/oracle/product/flash_recovery_area'
*.db_recovery_file_dest_size=2G
*.db_flashback_retention_target=10080 # Represents 7 days (60 minutes*24*7)
Note: DB_FLASHBACK_RETENTION_TARGET specifies the upper limit (in minutes) on how far back in time the database may be flashed back. How far back one can flashback a database depends on how much flashback data Oracle has kept in the flash recovery area.
