Oracle 19.3 on Win2019
I was testing restore point functionality today. Everything went well, but flashback took a lot of space. I deleted flashback logs :-( and now I am having issues starting up database (Test). What are my options at this point?
------------------------------
SYS@MIMAS >select * from dual;
ADDR INDX INST_ID CON_ID D
---------------- ---------- ---------- ---------- -
00007FF655BFA43C 0 1 0 X
S
YS@MIMAS >alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SYS@MIMAS >select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
MIMAS MOUNTED
SYS@MIMAS >alter database flashback off;
Database altered.
SYS@MIMAS >alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database