The following opinions expressed in this post are my own and in no way connected to my employer.
SELECT NAME FROM V$RESTORE_POINT;
SELECT CHECKPOINT_CHANGE#,CHECKPOINT_TIME,UNRECOVERABLE_CHANGE#,UNRECOVERABLE_TIME FROM V$DATAFILE;
FLASHBACK DATABASE TO RESTORE POINT TEST_APOINT;
SELECT * FROM V$FLASHBACK_DATABASE_LOG;
SELECT * FROM V$FLASHBACK_DATABASE_STAT;
Comments