DBA Hub

📋Steps in this guide1/1

How far we can flashback

--How Far Back Can We Flashback To (Time)

oracle configurationintermediate
by OracleDba
12 views
1

How far we can flashback

--How Far Back Can We Flashback To (Time) --How Far Back Can We Flashback To (SCN)

Code/Command (click line numbers to comment):

1
2
3
4
select to_char(oldest_flashback_time,’dd-mon-yyyy hh24:mi:ss’) “Oldest Flashback Time”
from v$flashback_database_log;
col oldest_flashback_scn format 99999999999999999999999999
select oldest_flashback_scn from v$flashback_database_log;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!