Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

Archive for the 'Flashback' Category

How to use the flashback operation in Oracle database 19c

Posted by Mir Sayeed Hassan on 20th September 2025

How to use the flashback operation in Oracle database 19c Check the status of database SYS> select name, open_mode, version from V$instance, v$database; NAME OPEN_MODE VERSION ———————————— ORA19CDB READ WRITE 19.0.0.0.0 Check flashback is enable or not. SYS> select flashback_on from… Read more..

Tags:
Posted in Flashback | Comments Off on How to use the flashback operation in Oracle database 19c

How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0)

Posted by Mir Sayeed Hassan on 4th January 2020

How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0) Flashback in Oracle Database It’s a technology in Oracle database to perform restore the database to a particular point in past. In case if you have lost the data like DML & want to retrieve, you can retrieve the rollback operation through flashback without using… Read More

Posted in Flashback | Comments Off on How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0)