?
存储在FRA区中的与数据库相关的file的视图(二)
INE_FUZZY VARCHAR2(3)
BACKUP_FUZZY VARCHAR2(3)
MARKED_CORRUPT NUMBER
MEDIA_CORRUPT NUMBER
LOGICALLY_CORRUPT NUMBER
BLOCKS NUMBER
BLOCK_SIZE NUMBER
OLDEST_OFFLINE_RANGE NUMBER
DELETED VARCHAR2(3)
STATUS VARCHAR2(1)
COMPLETION_TIME DATE
CONTROLFILE_TYPE VARCHAR2(1)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(11)
SCANNED VARCHAR2(3)
IS_RECOVERY_DEST_FILE VARCHAR2(3)------------->此列值为YES表示在FRA中
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
CONVERTED_FILE VARCHAR2(3)
SAME_ENDIAN VARCHAR2(3)
FOREIGN_DBID NUMBER
PLUGGED_READONLY VARCHAR2(3)
PLUGIN_CHANGE# NUMBER
PLUGIN_RESETLOGS_CHANGE# NUMBER
PLUGIN_RESETLOGS_TIME DATE
BACKED_BY_VSS VARCHAR2(3)
SQL>
desc v$flashback_database_logfile; ---->这是闪回日志的视图。
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(513)
LOG# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SQL>