Database-related file views stored in the FRA area

V$controlfile;v$logfile;v$archived_log;v$backup_piece;v$datafile_copy the value of the Is_recovery_dest_file column in the view above is yes for the FRA ======================================================v$flashback_database_logfile;

[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.1.0.7.0-production on Sun 02:35:36 2015Copyri  Ght (c) 1982, D, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition Release 11.1.0.7.0-productionwith The partitioning, OLAP, Data Minin G and Real application testing optionssql> desc v$controlfile;    Name Null?                                             Type-----------------------------------------------------------------------------STATUS                              VARCHAR2 (7) NAME VARCHAR2 (513) Is_recovery_dest_file VARCHAR2 (3)-------------> This column value is yes indicates block_size number F in FRA Ile_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)-------------> This column value is yes to indicate sql> desc v$archived_log in fra;    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 NUM BER CREATOR VARCHAR2 (7) Registrar Varc                                           HAR2 (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_de                                         St_file VARCHAR2 (3)-------------> This column value is yes for the FRA compressed                                   VARCHAR2 (3) FAL VARCHAR2 (3) End_of_redo_type VARCHAR2 (Ten) 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 (+) HANDLE VARCHAR2 (513) COMMENTS                                         VARCHAR2 (+) MEDIA VARCHAR2 (+) Media_pool                                                Number CONCUR VARCHAR2 (3) TAG                                         VARCHAR2 (+) STATUS VARCHAR2 (1) start_time                                    Date Completion_time Date Elapsed_seconds                                              Number DELETED VARCHAR2 (3) BYTES Number Is_recovery_dest_file VARCHAR2 (3)-------------> This column value is yes in FR    A medium 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$DATAF    Ile_copy Name Null?                                              Type-----------------------------------------------------------------------------RECID                                               Number STAMP number NAME                                              VARCHAR2 (513) TAG VARCHAR2 (+) 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 N Umber oldest_offline_range number DELETED VARCHAR             2 (3) STATUS                                VARCHAR2 (1) completion_time DATE Controlfile_type                                         VARCHAR2 (1) KEEP VARCHAR2 (3) Keep_until                                            DATE keep_options VARCHAR2 (one) scanned VARCHAR2 (3) Is_recovery_dest_file VARCHAR2 (3)------------->                                  This column value of Yes indicates rman_status_recid number in Fra 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# N Umber plugin_resetlogs_tIME DATE Backed_by_vss VARCHAR2 (3) sql> desc V$FLASHBA                  Ck_database_logfile; ----> This is the view of the flashback log.    Name Null?                                               Type-----------------------------------------------------------------------------NAME                                            VARCHAR2 (513) log# number thread#                                              Number sequence# number BYTES                                         Number first_change# number First_time  Datesql>

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Database-related file views stored in the FRA area