12c 闪回常用视图

SYS@orcl1> set lines 200
SYS@orcl1> col name for a50
SYS@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          0
REDO LOG                                 0                         0               0          0
ARCHIVED LOG                             0                         0               0          0
BACKUP PIECE                          1.86                         0               1          0
IMAGE COPY                               0                         0               0          0
FLASHBACK LOG                        14.94                         0               3          0
FOREIGN ARCHIVED LOG                     0                         0               0          0
AUXILIARY DATAFILE COPY                  0                         0               0          0

8 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          0

SYS@orcl1> select * from v$flashback_database_stat;

no rows selected

SYS@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

本文转自 roidba 51CTO博客，原文链接：http://blog.51cto.com/roidba/2058030，如需转载请自行联系原作者