Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be learning how to Enable Flashback Database in Oracle.
1. We check the FRA area.
1 2 3 4 5 6 | [Primary-1] SQL> show parameter db_recovery_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string +FRA db_recovery_file_dest_size big integer 101G |
2. We check whether the database is in archive mode.
1 2 3 4 5 | [Primary-1] SQL> select log_mode from v$databasE; LOG_MODE ------------ ARCHIVELOG |
3. We check whether Flashback is enabled or not.
1 2 3 4 5 | [Primary-1] SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ NO |
4. We determine the Flashback Retention period.
1 2 3 4 5 | [Primary-1] SQL> show parameter db_flashback NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_flashback_retention_target integer 1440 |
5. Flashback is activated.
1 2 3 | [Primary-1] SQL> alter database flashback on; Database altered. |
6. We check whether the Flashback Writer process has occurred.
1 2 | [Primary-1] SQL> ! ps -ef |grep rvwr | grep -v grep oracle 29608 1 0 11:14 ? 00:00:00 ora_rvwr_primary1 |
