V$DATAFILE_COPY displays datafile copy information from the control file.
Column | Datatype | Description |
RECID | NUMBER | Datafile copy record ID |
STAMP | NUMBER | Datafile copy record stamp |
NAME | VARCHAR2(513) | Filename of the datafile copy. The maximum length of the name is OS dependent. |
TAG | VARCHAR2(32) | Datafile copy tag |
FILE# | NUMBER | Absolute datafile number |
RFILE# | NUMBER | Tablespace relative datafile number |
CREATION_CHANGE# | NUMBER | Datafile creation change# |
CREATION_TIME | DATE | Datafile creation timestamp |
RESETLOGS_CHANGE# | NUMBER | Resetlogs change number of the datafile when the copy was made |
RESETLOGS_TIME | DATE | Resetlogs timestamp of the datafile when the copy was made |
INCREMENTAL_LEVEL | NUMBER | The incremental level |
CHECKPOINT_CHANGE# | NUMBER | Checkpoint change number of the datafile when the copy was made |
CHECKPOINT_TIME | DATE | Checkpoint timestamp of the datafile when the copy was made |
ABSOLUTE_FUZZY_CHANGE# | NUMBER | Highest change seen when the datafile was copied |
RECOVERY_FUZZY_CHANGE# | NUMBER | Highest change written to the file by media recovery |
RECOVERY_FUZZY_TIME | DATE | Timestamp of the highest change written to the file by media recovery |
ONLINE_FUZZY | VARCHAR2(3) | (YES|NO) If set to YES, this is a copy taken using an operating system utility after a crash or offline immediate (or an invalid copy taken while datafile was online and the database open). Recovery will need to apply all redo up to the next crash recovery marker to make the file consistent. |
BACKUP_FUZZY | VARCHAR2(3) | (YES|NO) If set to YES, this is a copy taken using the BEGIN BACKUP/END BACKUP technique. Recovery will need to apply all redo up to the end backup marker to make this copy consistent. |
MARKED_CORRUPT | NUMBER | Number of blocks marked corrupt by this copy operation. That is, blocks that were not marked corrupted in the source datafile, but were detected and marked as corrupted during the copy operation. |
MEDIA_CORRUPT | NUMBER | Total number of media corrupt blocks. For example, blocks with checksum errors are marked media corrupt. |
LOGICALLY_CORRUPT | NUMBER | Total number of logically corrupt blocks. For example, applying redo for unrecoverable operations will mark affected blocks logically corrupt. |
BLOCKS | NUMBER | Size of the datafile copy in blocks (also the size of the datafile when the copy was made) |
BLOCK_SIZE | NUMBER | Block size of the datafile |
OLDEST_OFFLINE_RANGE | NUMBER | RECID of the oldest offline range record in this control file copy; 0 for datafile copies |
DELETED | VARCHAR2(3) | (YES|NO) If set to YES the datafile copy has been deleted or overwritten |
STATUS | VARCHAR2(1) | Identifies the status of this datafile copy. Possible values are: A - Available D - Deleted U - Unavailable X - Expired |
COMPLETION_TIME | DATE | Time when the copy was completed |
CONTROLFILE_TYPE | VARCHAR2(1) | B indicates normal copies S indicates standby copies |
KEEP | VARCHAR2(3) | (YES/NO) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy |
KEEP_UNTIL | DATE | If KEEP_UNTIL_TIME is specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires. |
KEEP_OPTIONS | VARCHAR2(10) | Lists additional retention options for this backup set. Possible values are: LOGS - The logs need to recover this backup are kept NOLOGS - The logs needed to recover this backup will not be kept |
SCANNED | VARCHAR2(3) | Indicates whether RMAN scanned the file (YES) or not (NO) |
IS_RECOVERY_DEST_FILE | VARCHAR2(3) | Indicates whether the file was created in the flash recovery area (YES) or not (NO) |
RMAN_STATUS_RECID | NUMBER | Owning V$RMAN_STATUS record ID |
RMAN_STATUS_STAMP | NUMBER | Owning V$RMAN_STATUS record stamp |
CONVERTED_FILE | VARCHAR2(3) | ??? |
SAME_ENDIAN | VARCHAR2(3) | ??? |
FOREIGN_DB | NUMBER | ??? |
PLUGGED_READONLY | VARCHAR2(3) | ??? |
PLUGIN_CHANGE# | NUMBER | ??? |
PLUGIN_RESETLOGS_CHANGE# | NUMBER | ??? |
PLUGIN_RESETLOGS_TIME | DATE | ??? |
BACKED_BY_VSS | VARCHAR2(3) | Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use. |
Oracle data dictionary views
Last updated: 2009-11-05 Thursday |
No comments:
Post a Comment