|
|
Dear Erman,
we need your help.
Oracle database 2 node rac 19c
application R12.2.5
Unfortunately,my team mate deleted the flashback logs. We are unable to start the instance. We tried to drop the restore point but it errors out. This is UAT. Is there is anyway to bring up the database.
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38714: Instance recovery required.
SQL>
SQL> sho parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRADG
db_recovery_file_dest_size big integer 50G
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRADG
Oldest online log sequence 27
Next log sequence to archive 28
Current log sequence 28
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
RESTORE POINT ONLY
SQL> select NAME,SCN,GUARANTEE_FLASHBACK_DATABASE,DATABASE_INCARNATION# from v$restore_point;
NAME
--------------------------------------------------------------------------------
SCN GUA DATABASE_INCARNATION#
---------- --- ---------------------
CLEAN_DB
5.9978E+12 YES 2
SQL> drop restore point CLEAN_DB;
drop restore point CLEAN_DB
*
ERROR at line 1:
ORA-38780: Restore point 'CLEAN_DB' does not exist.
We have free space available. Not sure what else we can check.
Thanks,
Satish
|
Locked
