12c 闪回常用视图

SYS@orcl1> set lines 200SYS@orcl1> col name for a50SYS@orcl1> select * from v$recovery_area_usage;FILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES     CON_ID----------------------- ------------------ ------------------------- --------------- ----------CONTROL FILE                          1.86                         0               1          0REDO LOG                                 0                         0               0          0ARCHIVED LOG                             0                         0               0          0BACKUP PIECE                          1.86                         0               1          0IMAGE COPY                               0                         0               0          0FLASHBACK LOG                        14.94                         0               3          0FOREIGN ARCHIVED LOG                     0                         0               0          0AUXILIARY DATAFILE COPY                  0                         0               0          08 rows selected.SYS@orcl1> select * from v$flashback_database_log;OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TIME   RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE     CON_ID-------------------- ----------------------- ---------------- -------------- ------------------------ ----------            11415989 05-JAN-2018 18:58:23                2880      157286400                        0          0SYS@orcl1> select * from v$flashback_database_stat;no rows selectedSYS@orcl1> select * from v$flashback_database_logfile;NAME                                                     LOG#    THREAD#  SEQUENCE#      BYTES FIRST_CHANGE# FIRST_TIME      TYPE           CON_ID-------------------------------------------------- ---------- ---------- ---------- ---------- ------------- ----------------------- --------- ----------+DATADG/ORCL/FLASHBACK/log_1.377.964637895                  1          1          1   52428800      11416042 05-JAN-2018 18:58:17    NORMAL              0+DATADG/ORCL/FLASHBACK/log_2.376.964637901                  2          1          2   52428800      11427835 05-JAN-2018 22:01:05    NORMAL              0+DATADG/ORCL/FLASHBACK/log_3.374.964648865                  3          1          1   52428800             0                 RESERVED            0