Posts Tagged ‘Enable Flashback On Oracle Database’

Enabling And Checking the Status of Flashback On Database

February 6th, 2016, posted in Oracle Queries
Share

Enabling the FLASHBACK DATABASE on the standby database :Oracle : Size Of Database,Oracle,Size Of Database,Database,data files, redo log files, control files, temporary files,Oracle data files,Oracle  redo log files,Oracle  control files,Oracle  temporary files,Enabling And Checking the Status of Flashback On Database,Oracle Database,Oracle DBA,Enabling Flashback On Database,Checking the Status of Flashback On Database, Status of Flashback On Database, Enable Flashback On Database, Enabling Flashback On Database,Enable Flashback On Oracle Database, Enabling Flashback On Oracle Database,

SQL> alter database flashback on;
Database altered.

 

Checking the status of the flashback on the database :

SQL> select flashback_on from gv$database;

FLASHBACK_ON
——————

YES
YES

Share