V$BACKUP

V$BACKUP displays the backup status of all online datafiles.

Column Datatype Description
FILE# NUMBER File identifier
STATUS VARCHAR2(18) File status: NOT ACTIVE, ACTIVE (backup in progress), OFFLINE NORMAL, or description of an error
CHANGE# NUMBER System change number when backup started
TIME DATE Time the backup started