top of page
  • Writer's pictureblkrishnarao

RESTORE DATABASE TO FLASHBACK RESTORE POINT | ORACLE DATABASE

Updated: Apr 16

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 view0 comments

Recent Posts

See All

Comments


bottom of page