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

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

Revision as of 01:10, 1 May 2014 (view source) Ppapa (talk \| contribs) ← Older edit		Latest revision as of 01:11, 1 May 2014 (view source) Ppapa (talk \| contribs)
Line 5:		Line 5:
	WHERE d.TS#=t.TS# AND b.FILE#=d.FILE#;		WHERE d.TS#=t.TS# AND b.FILE#=d.FILE#;

−	[https://communities.netapp.com/community/netapp-blogs/databases/blog/2009/09/24/checking-if-tablespaces-are-in-backup-mode-or-nothellip]	+	Taken from [https://communities.netapp.com/community/netapp-blogs/databases/blog/2009/09/24/checking-if-tablespaces-are-in-backup-mode-or-nothellip here]