DBA Data[Home] [Help]

VIEW: SYS.V_$BACKUP_SET

Source

View Text - Preformatted

select "RECID","STAMP","SET_STAMP","SET_COUNT","BACKUP_TYPE","CONTROLFILE_INCLUDED","INCREMENTAL_LEVEL","PIECES","START_TIME","COMPLETION_TIME","ELAPSED_SECONDS","BLOCK_SIZE","INPUT_FILE_SCAN_ONLY","KEEP","KEEP_UNTIL","KEEP_OPTIONS","MULTI_SECTION","FOR_XTTS","SAME_ENDIAN","INC_DMPFILE","CON_ID","GUID" from v$backup_set
View Text - HTML Formatted

SELECT "RECID"
, "STAMP"
, "SET_STAMP"
, "SET_COUNT"
, "BACKUP_TYPE"
, "CONTROLFILE_INCLUDED"
, "INCREMENTAL_LEVEL"
, "PIECES"
, "START_TIME"
, "COMPLETION_TIME"
, "ELAPSED_SECONDS"
, "BLOCK_SIZE"
, "INPUT_FILE_SCAN_ONLY"
, "KEEP"
, "KEEP_UNTIL"
, "KEEP_OPTIONS"
, "MULTI_SECTION"
, "FOR_XTTS"
, "SAME_ENDIAN"
, "INC_DMPFILE"
, "CON_ID"
, "GUID"
FROM V$BACKUP_SET