V$BACKUP: Online Datafiles Backup Status

Share this article :

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


File identifier


File status: NOT ACTIVE, ACTIVE (backup in progress), OFFLINE NORMAL, or description of an error. NOT ACTIVE indicates that the file is not currently in backup mode (that is, an ALTER TABLESPACE … BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP statement has not been issued), whereas ACTIVE indicates that the file is currently in backup mode.


System change number when backup started


Time the backup started


Related posts

Find Oracle User Created Time
Find the Oracle Alert Log
ORA-16038: log xx sequence# xxxxx cannot be archived
SP2-0750: You may need to set ORACLE_HOME to your Oracle
© 2017 ITsiti. All Rights Reserved
Powered by KEEM