2.89 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"

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 Database 23ai.

See Also: