FLASHBACK ON / OFF [11g]

########## Flashback enable: [11g] ##########

[ reboot of database Not required for 11g]

SQL> select log_mode,flashback_on from v$database;

LOG_MODE     FLASHBACK_ON
------------ ------------------
ARCHIVELOG   NO

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=3G;
SQL> alter system set DB_RECOVERY_FILE_DEST='D:\recovery_area';
SQL> alter system set DB_FLASHBACK_RETENTION_TARGET=120;
SQL> alter database flashback on;
SQL> select log_mode,flashback_on from v$database;

LOG_MODE     FLASHBACK_ON
------------ ------------------
ARCHIVELOG   YES





########## Flashback disable: [11g] ##########

SQL> alter database flashback off;

SQL> select log_mode,flashback_on from v$database;

LOG_MODE     FLASHBACK_ON
------------ ------------------
ARCHIVELOG   NO

FLASHBACK ON / OFF [10g]

############## Flashback enable: [10g] ########################


SQL> select open_mode, log_mode, flashback_on from v$database;

OPEN_MODE            LOG_MODE     FLASHBACK_ON
-------------------- ------------ -------------
READ WRITE           ARCHIVELOG   NO

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=3G;
SQL> alter system set DB_RECOVERY_FILE_DEST='D:\app\Administrator\recovery_area';
SQL> alter system set DB_FLASHBACK_RETENTION_TARGET=120;
SQL> show parameter DB_RECOVERY_FILE_DEST
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database flashback on;
SQL> select * from v$bgprocess where name='RVWR';
SQL> alter database open;



############## Flashback disable: [10g]  ######################


SQL> select open_mode, log_mode, flashback_on from v$database;

OPEN_MODE            LOG_MODE     FLASHBACK_ON
-------------------- ------------ -------------
READ WRITE           ARCHIVELOG   YES

SQL> alter database flashback off;