The database-Related file View stored in FRA, frafile

The database-Related file View stored in FRA, frafile

V $ controlfile; v $ logfile; v $ archived_log; v $ backup_piece; in the view above v $ datafile_copy, the value of the IS_RECOVERY_DEST_FILE column is YES, indicating ================ in 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 2015 Copyright (c) 1982,200 8, 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 verification -------- invalid STATUS VARCHAR2 (7) NAME VARCHAR2 (513) invalid VARCHAR2 (3) -------------> the value of this column is YES, which indicates BLOCK_SIZE NUMBER FILE_SIZE_BLKS NUMBERSQL> desc v $ logfile in FRA; name Null? Type reserved -------- ---------------------------- GROUP # number status VARCHAR2 (7) TYPE VARCHAR2 (7) MEMBER VARCHAR2 (513) IS_RECOVERY_DEST_FILE VARCHAR2 (3) -------------> if this column is set to YES, 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 second date sequence number FIRST_CHANGE # NUMBER FIRST_TIME DATE NEXT_CHANGE # NUMBER NEXT_TIME date blocks number BLOCK_SIZE number creator VARCHAR2 (7) REGISTRAR VARCHAR2 (7) Comment 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 required VARCHAR2 (3) -------------> if this value is YES, COMPRESSED VARCHAR2 (3) FAL VARCHAR2 (3) in FRA) END_OF_REDO_TYPE VARCHAR2 (10) BACKED_BY_VS S VARCHAR2 (3) SQL> desc v $ backup_piece; Name Null? Type verification -------- ---------------------------- 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 comment VARCHAR2 (3) -------------> the value of this column is YES, indicating that the comment NUMBER matches 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 ## NUMBER RECOVERY_FUZZY_CHANGE # NUMBER RECOVE RY_FUZZY_TIME DATE ONLINE_FUZZY VARCHAR2 (3) BACKUP_FUZZY VARCHAR2 (3) marked_0000upt NUMBER media_0000upt NUMBER comment number blocks number BLOCK_SIZE NUMBER comment 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 )-- -----------> If this column is set to YES, 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; ----> 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 Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.