Difference between revisions of "Check backup status of a Database"
From Peter Pap's Technowiki
(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...") |
|||
| 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] | ||
Revision as of 01:10, 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#;
