Check backup status of a Database: Difference between revisions

From Peter Pap's Technowiki
Jump to navigation Jump to 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..."
 
No edit summary
 
(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://peterpap.net/index.php?title=Check_backup_status_of_a_Database&oldid=576"