Flashback was not enabled and due to that flashback logs were not generated to recover the database to previous scn. But there is a guaranteed restore point created without flashback logging.
SQL> flashback database to scn 999545; flashback database to scn 999545 * ERROR at line 1: ORA-38726: Flashback database logging is not on.
If i check the flashback status , it shows ‘ RESTORE POINT ONLY ‘
SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ RESTORE POINT ONLY
Only option is to restore the database to previous restore point rather than specification of scn clause
SQL> flashback database to restore point A; Flashback complete.
Open the database with resetlogs. Anyway you get the previous scn
SQL> alter database open resetlogs; Database altered. SQL> select current_scn from v$database; CURRENT_SCN ----------- 999935