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 |