DB_FLASHBACK_RETENTION_TARGET

Property	Description
Parameter type	Integer
Default value	1440 (minutes)
Modifiable	ALTER SYSTEM ... SID='*'
Range of values	0 to 231 - 1
Basic	No

DB_FLASHBACK_RETENTION_TARGET specifies the upper limit (in minutes) on how far back in time the database may be flashed back. How far back one can flashback a database depends on how much flashback data Oracle has kept in the flash recovery area.

Note:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘DB_FLASHBACK_RETENTION_TARGET’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_flashback_retention_target	1440	TRUE	FALSE	IMMEDIATE	FALSE	FALSE	Maximum Flashback Database log retention time in minutes.

Oracle initializatoin parameters