Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > db_flashback_retention_target

db_flashback_retention_target


Oracle 11.1.0:

Parameter Name:db_flashback_retention_target
Description:Maximum Flashback Database log retention time in minutes.
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:db_flashback_retention_target
Description:Maximum Flashback Database log retention time in minutes.
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:db_flashback_retention_target
Description:Maximum Flashback Database log retention time in minutes.
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

No such parmeter in Oracle 9.2.0.

Oracle 8.1.7:

No such parmeter in Oracle 8.1.7.

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-38700: Limit of %s flashback database logs has been exceeded.
    Cause: The maximum number of flashback database log files was exceeded.

    Action: DB_FLASHBACK_RETENTION_TARGET may be set to high. Modify it to a smaller value.

ORA-38767: flashback retention target parameter mismatch

    Cause: The value of parameters DB_FLASHBACK_RETENTION_TARGET must be same in all instances. All databases must have same flashback retention target parameters.

    Action: Check DB_FLASHBACK_RETENTION_TARGET values in all instances.


This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ db_flashback_retention_target ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US