DBA Data[Home] [Help]

VIEW: SYS.GV_$BACKUP_NONLOGGED

Source

View Text - Preformatted

select "INST_ID","RECID","STAMP","SET_STAMP","SET_COUNT","PIECE#","FILE#","BLOCK#","BLOCKS","NONLOGGED_CHANGE#","NONLOGGED_TIME","RESETLOGS_CHANGE#","RESETLOGS_TIME","OBJECT#","REASON","CON_ID" from gv$backup_nonlogged
View Text - HTML Formatted

SELECT "INST_ID"
, "RECID"
, "STAMP"
, "SET_STAMP"
, "SET_COUNT"
, "PIECE#"
, "FILE#"
, "BLOCK#"
, "BLOCKS"
, "NONLOGGED_CHANGE#"
, "NONLOGGED_TIME"
, "RESETLOGS_CHANGE#"
, "RESETLOGS_TIME"
, "OBJECT#"
, "REASON"
, "CON_ID"
FROM GV$BACKUP_NONLOGGED