The database-Related file View stored in FRA, frafile

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.