VIEW: SYS.GV_$BACKUP_DATAFILE

Source

View Text - Preformatted

select "INST_ID","RECID","STAMP","SET_STAMP","SET_COUNT","FILE#","CREATION_CHANGE#","CREATION_TIME","RESETLOGS_CHANGE#","RESETLOGS_TIME","INCREMENTAL_LEVEL","INCREMENTAL_CHANGE#","CHECKPOINT_CHANGE#","CHECKPOINT_TIME","ABSOLUTE_FUZZY_CHANGE#","MARKED_CORRUPT","MEDIA_CORRUPT","LOGICALLY_CORRUPT","DATAFILE_BLOCKS","BLOCKS","BLOCK_SIZE","OLDEST_OFFLINE_RANGE","COMPLETION_TIME","CONTROLFILE_TYPE","USED_CHANGE_TRACKING","BLOCKS_READ","USED_OPTIMIZATION","FOREIGN_DBID","PLUGGED_READONLY","PLUGIN_CHANGE#","PLUGIN_RESETLOGS_CHANGE#","PLUGIN_RESETLOGS_TIME","SECTION_SIZE","UNDO_OPTIMIZED","BLOCKS_SKIPPED_IN_CELL","CON_ID","BACKED_BY_PDB","GUID" from gv$backup_datafile

View Text - HTML Formatted

SELECT "INST_ID"
, "RECID"
, "STAMP"
, "SET_STAMP"
, "SET_COUNT"
, "FILE#"
, "CREATION_CHANGE#"
, "CREATION_TIME"
, "RESETLOGS_CHANGE#"
, "RESETLOGS_TIME"
, "INCREMENTAL_LEVEL"
, "INCREMENTAL_CHANGE#"
, "CHECKPOINT_CHANGE#"
, "CHECKPOINT_TIME"
, "ABSOLUTE_FUZZY_CHANGE#"
, "MARKED_CORRUPT"
, "MEDIA_CORRUPT"
, "LOGICALLY_CORRUPT"
, "DATAFILE_BLOCKS"
, "BLOCKS"
, "BLOCK_SIZE"
, "OLDEST_OFFLINE_RANGE"
, "COMPLETION_TIME"
, "CONTROLFILE_TYPE"
, "USED_CHANGE_TRACKING"
, "BLOCKS_READ"
, "USED_OPTIMIZATION"
, "FOREIGN_DBID"
, "PLUGGED_READONLY"
, "PLUGIN_CHANGE#"
, "PLUGIN_RESETLOGS_CHANGE#"
, "PLUGIN_RESETLOGS_TIME"
, "SECTION_SIZE"
, "UNDO_OPTIMIZED"
, "BLOCKS_SKIPPED_IN_CELL"
, "CON_ID"
, "BACKED_BY_PDB"
, "GUID"
FROM GV$BACKUP_DATAFILE