V$BACKUP: Online Datafiles Backup Status



Share this article :

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

FILE#

File identifier

STATUS

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.

CHANGE#

System change number when backup started

TIME

Time the backup started

Tags:

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