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

ORA-28000: the account is locked
Set Column Size in SQLplus
Find the Location of Oracle SPFILE
RMAN: ORA-12154: TNS:could not resolve the connect identifier specified
© 2018 ITsiti. All Rights Reserved
Powered by KEEM