Difference between revisions of "Check backup status of a Database"

From Peter Pap's Technowiki
Jump to: navigation, search
(Created page with "So you're wondering if your database is stuck in hot backup mode. This query will tell you if that is the case: SELECT t.name, d.file# as, b.status FROM V$DATAFILE d...")
 
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
 
   FROM V$DATAFILE d, V$TABLESPACE t, V$BACKUP b       
 
   FROM V$DATAFILE d, V$TABLESPACE t, V$BACKUP b       
 
   WHERE d.TS#=t.TS# AND b.FILE#=d.FILE#;
 
   WHERE d.TS#=t.TS# AND b.FILE#=d.FILE#;
 +
 +
Taken from [https://communities.netapp.com/community/netapp-blogs/databases/blog/2009/09/24/checking-if-tablespaces-are-in-backup-mode-or-nothellip here]

Latest revision as of 01:11, 1 May 2014

So you're wondering if your database is stuck in hot backup mode. This query will tell you if that is the case: 

  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#;

Taken from here

Retrieved from "https://www.peterpap.net/index.php?title=Check_backup_status_of_a_Database&oldid=576"