时间：2021-07-01 10:21:17 帮助过：9人阅读
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>
版权声明：本文为博主原创文章，未经博主允许不得转载。
存储在FRA区中的与数据库相关的file的视图
标签：