v$controlfile;
v$logfile;
v$archived_log;
v$backup_piece;
v$datafile_copy
以上视图中的IS_RECOVERY_DEST_FILE列的值为YES表示在FRA中
======================================================
v$flashback_database_logfile;
[oracle@hosta ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sun Aug 30 02:35:36 2015
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc v$controlfile;
Name Null? Type
----------------------------------------- -------- ----------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)------------->此列值为YES表示在FRA中
BLOCK_SIZE NUMBER
FILE_SIZE_BLKS NUMBER
SQL> desc v$logfile;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
STATUS VARCHAR2(7)
TYPE VARCHAR2(7)
MEMBER VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)------------->此列值为YES表示在FRA中
SQL> desc v$archived_log;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
NAME VARCHAR2(513)
DEST_ID NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
RESETLOGS_ID NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE
BLOCKS NUMBER
BLOCK_SIZE NUMBER
CREATOR VARCHAR2(7)
REGISTRAR VARCHAR2(7)
STANDBY_DEST VARCHAR2(3)
ARCHIVED VARCHAR2(3)
APPLIED VARCHAR2(9)
DELETED VARCHAR2(3)
STATUS VARCHAR2(1)
COMPLETION_TIME DATE
DICTIONARY_BEGIN VARCHAR2(3)
DICTIONARY_END VARCHAR2(3)
END_OF_REDO VARCHAR2(3)
BACKUP_COUNT NUMBER
ARCHIVAL_THREAD# NUMBER
ACTIVATION# NUMBER
IS_RECOVERY_DEST_FILE VARCHAR2(3)------------->此列值为YES表示在FRA中
COMPRESSED VARCHAR2(3)
FAL VARCHAR2(3)
END_OF_REDO_TYPE VARCHAR2(10)
BACKED_BY_VSS VARCHAR2(3)
SQL> desc v$backup_piece;
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
PIECE# NUMBER
COPY# NUMBER
DEVICE_TYPE VARCHAR2(17)
HANDLE VARCHAR2(513)
COMMENTS VARCHAR2(64)
MEDIA VARCHAR2(65)
MEDIA_POOL NUMBER
CONCUR VARCHAR2(3)
TAG VARCHAR2(32)
STATUS VARCHAR2(1)
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
DELETED VARCHAR2(3)
BYTES NUMBER
IS_RECOVERY_DEST_FILE VARCHAR2(3)------------->此列值为YES表示在FRA中
RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP NUMBER
COMPRESSED VARCHAR2(3)
BACKED_BY_VSS VARCHAR2(3)
ENCRYPTED VARCHAR2(3)
BACKED_BY_OSB VARCHAR2(3)
SQL> desc v$datafile_copy
Name Null? Type
----------------------------------------- -------- ----------------------------
RECID NUMBER
STAMP NUMBER
NAME VARCHAR2(513)
TAG VARCHAR2(32)
FILE# NUMBER
RFILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
INCREMENTAL_LEVEL NUMBER
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
ABSOLUTE_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_TIME DATE
ONLINE_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>