FLASHBACK DATABASE

 You can flashback the database at SQL prompt and also using RMAN.

SQL> flashback database to restore point restore_point_name;

SQL>flashback database to timestamp TO_TIMESTAMP( '2021-08-19 01:00:00','YYYY-MM-DD HH24:MI:SS');

RMAN > flashback database to time = "to_date('2021-08-19 01:00:00', 'YYYY-MM-DD HH24:MI:SS')";

Benefits using RMAN for flashback:  If below errors occurred in SQL prompt it means flashback required some archived logs which are not available at archive log destination but available at backup location(TAPE/external) then it will automatically restores required archived logs from backup location and applied to restore the database successfully.

ERROR at line 1:

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

ORA-38762: redo logs needed for SCN 1254285658 to SCN 1254285759

ORA-38761: redo log sequence 1694 in thread 1, incarnation 3 could not be

accessed

**We can create the restore point and restore the database to a restore point without turning on the FLASHBACK.