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 |
