DB_FLASHBACK_LOG_DEST

DB_FLASHBACK_LOG_DEST specifies the location for flashback database log storage.

Property Description
Parameter type String
Syntax

DB_FLASHBACK_LOG_DEST = { directory | disk group }
Default value There is no default value.
Modifiable

ALTER SYSTEM ... SID='*'

See "Modifying DB_FLASHBACK_LOG_DEST with ALTER SYSTEM" at the end of this section.
Modifiable in a PDB No
Basic No
Oracle RAC You must set this parameter for every instance, and multiple instances must have the same value.

This parameter allows you to specify a location for flashback database logs that is separate from the fast recovery area used by backups. For example, you could place flashback database logs in high-performance storage.

Before assigning a value to this parameter, you must set the DB_FLASHBACK_LOG_DEST_SIZE parameter to a nonzero value.

Modifying DB_FLASHBACK_LOG_DEST with ALTER SYSTEM

When modifying the DB_FLASHBACK_LOG_DEST parameter with the ALTER SYSTEM statement, you must disable and reenable flashback logging. For example:

SQL> alter database flashback off;

Database altered.


SQL> alter system set db_flashback_log_dest='/u01/oracle/dbs/ofba2';

System altered.


SQL> alter database flashback on;

Database altered.

Note: This parameter is available starting with Oracle AI Database 26ai.

See Also: