top of page

RESTORE DATABASE TO FLASHBACK RESTORE POINT | ORACLE DATABASE

Writer's picture: blkrishnaraoblkrishnarao

Updated: Apr 16, 2024

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;



1 view

Recent Posts

See All
bottom of page