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.
