儲存在FRA區中的與資料庫相關的file的視圖，frafile

儲存在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 sysdbaSQL*Plus: Release 11.1.0.7.0 - Production on Sun Aug 30 02:35:36 2015Copyright (c) 1982, 2008, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> 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                                     NUMBERSQL> 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                                         DATESQL> 

 

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。