Configure Database for Flashback Technology

Configure Database for Flashback Technology
Configuring your database for flashback technology
· Configuring Your Database for Automatic Undo ManagementUNDO_TABLESPACECreate undo tablespace with enough space to keep require undo data for flashback operations
UNDO_MANAGEMENTSet AUTO for automatic undo management
UNDO_RETENTIONRetention period will automatically set by system and we can check current undo retention through below querySelect tuned_undoretention from v$undostat;Value return in SECONDs
· Configuring Your Database for Flashback Transaction QueryEnsure database is running with 10.x compatibilityEnable Supplemental loggingSQL> alter database add supplemental log data;NOTE: user must have DBA role to enable supplemental logging.
· Configuring Your Database for Flashback TransactionDatabase must be running in ARCHIVELOG modeEnable supplemental logging
· Enabling Flashback Operations on Specific LOB ColumnsSpecify RETENTION period for LOB tables
· Granting Necessary PrivilegesFlashback or select privilege for flashback query or flashback query versionSelect any transaction privilege for flashback transaction querySYSDBA or flashback archive privilege for flashback data archive (11g new feature)