ORA-02097: parameter cannot be modified because specified value is invalid-ORA-38775: cannot disable recovery area – flashback database is enabled

I try to disable db recovery file dest and get flashback error

SQL> alter system set db_recovery_file_dest='';
alter system set db_recovery_file_dest=''
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-38775: cannot disable recovery area - flashback database is enabled

Check if there are any restore point and flashback enabled

SQL> select * from v$restore_point;

       SCN DATABASE_INCARNATION# GUA STORAGE_SIZE
---------- --------------------- --- ------------
TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME                                                          PRE
--------------------------------------------------------------------------- ---
NAME
--------------------------------------------------------------------------------
PDB CLE PDB_INCARNATION# REP     CON_ID
--- --- ---------------- --- ----------
   2280294                     2 YES    209715200
28-JUL-21 09.43.50.000000000 PM
                                                                            YES

       SCN DATABASE_INCARNATION# GUA STORAGE_SIZE
---------- --------------------- --- ------------
TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME                                                          PRE
--------------------------------------------------------------------------- ---
NAME
--------------------------------------------------------------------------------
PDB CLE PDB_INCARNATION# REP     CON_ID
--- --- ---------------- --- ----------
GUA
NO  NO                 0 NO           0

Disable flashback

SQL> alter database flashback off;

Database altered.

Drop the restore point and try again

SQL> drop restore point GUA;

Restore point dropped.

It work

SQL> alter system set db_recovery_file_dest='';

System altered.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s