Search notes:

oradebug ffbegin

SQL> oradebug ffbegin
Although the instance is now frozen, the session that froze the instances can still execute sql statements:
SQL> select * from v$instance;
SQL> select dbms_flashback.get_system_change_number from dual;
SQL> select scn_to_timestamp(dbms_flashback.get_system_change_number) from dual;
Thaw the frozen instance:
SQL> oradebug ffresumeinst

See also

The background process VFTM (Virtual Keeper of Time).

Index