ORA-38757: Database must be mounted and not open to FLASHBACK.
While trying to flashback the database after a failure in open mode , below error got triggered
SQL> flashback database to scn 999545; flashback database to scn 999545 * ERROR at line 1: ORA-38757: Database must be mounted and not open to FLASHBACK.
Bounce the database to mount mode and issue the command again
SQL> shu immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 1553305600 bytes Fixed Size 2253544 bytes Variable Size 956304664 bytes Database Buffers 587202560 bytes Redo Buffers 7544832 bytes Database mounted.
It should work now
SQL> flashback database to scn 999545; SQL> alter database open resetlogs; Database altered.