Oracle Database Backupmode Control

We can check our database’s tablespace or datafile status is in BACKUPMODE or Not with the following sql syntax ;

SELECT t.name, d.file# as, b.status FROM V$DATAFILE d, V$TABLESPACE t, V$BACKUP b WHERE d.TS#=t.TS# AND b.FILE#=d.FILE#;

Example ;

backupmode

 

ACTIVE –> Tablespace / Datafile in BACKUPMODE state

INACTIVE –> Tablespace / Datafile NOT in backupmode state

 

 

Leave a Reply


five + 9 =

Blogroll