存储在FRA区中的与数据库相关的file的视图，fra

存储在FRA区中的与数据库相关的file的视图，frafile

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> 

 

版权声明：本文为博主原创文章，未经博主允许不得转载。