欢迎光临
我们一直在努力

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
赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。