ORA-38708: not enough space for first flashback database log file

To switch on flashback on the database if FRA space is not sufficient to accomodate the flashback log files then,

SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38708: not enough space for first flashback database log file


SQL> !oerr ora 38708
38708, 00000, "not enough space for first flashback database log file"
// *Cause: An ALTER DATABASE FLASHBACK ON command failed because there
//         was not enough space in the Recovery Area for the first
//         flashback database log file.
// *Action: Make more space in the Recovery Area.  For example, this
//          can be done by increasing the value of
//          DB_RECOVERY_FILE_DEST_SIZE.

Increase FRA!

SQL> alter system set db_recovery_file_dest_size=10000M;

System altered.

SQL> alter database flashback on;

Database 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