Oracle: Enable/Disable Flashback Database

Home /Soluții /Oracle: Enable/Disable Flashback Database

Configurare noua (How To)

Prerequisite is to have the database in archivelog mode.

Enable flashback database:

SQL> ALTER DATABASE FLASHBACK ON;

Disable flashback database:

SQL> ALTER DATABASE FLASHBACK OFF;

Check the status of flashback database:

SQL> SELECT flashback_on FROM v$database;

Set Retention time (in minutes) for 7 days:
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=10080 SCOPE=BOTH;

Permanent

Up Down

(5 din 8 persoane apreciaza acest articol)