Check backup status of a Database - Revision history

Ppapa at 01:11, 1 May 2014

2014-05-01T01:11:04Z

Ppapa at 01:10, 1 May 2014

2014-05-01T01:10:42Z

Ppapa: 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..."

2014-05-01T01:09:27Z

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..."

New page

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

← Older revision		Revision as of 01:11, 1 May 2014
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]

← Older revision		Revision as of 01:10, 1 May 2014
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#;
		+
		+	[https://communities.netapp.com/community/netapp-blogs/databases/blog/2009/09/24/checking-if-tablespaces-are-in-backup-mode-or-nothellip]