FLASHBACK DATABASE TO SCN
- Posted by Arjun Raja
- On August 4, 2009
- 0 Comments
FLASHBACK DATABASE TO SCN Time to FLASHBACK DATABASE TO – 06:30 a.m on 31 July. Get oldest flashback time – SELECT OLDEST_FLASHBACK_SCN,to_char(OLDEST_FLASHBACK_TIME,'DD-MON-YYYY HH24:MI:SS') FROM V$FLASHBACK_DATABASE_LOG; If there are logs up until 06:30 on 31 Jul, you can flashback. Get the SCN number to flashback to – col first_change# format 99999999999 select first_change# ,to_char(first_time,'DD-MON-YYYY HH24:MI:SS'),sequence# from […]
Read More