Get the log history information for the past 3 days
SQL> select * from v$log_history where first_time > sysdate - 3; no rows selected SQL> SQL> SQL>