Check backup status of a Database: Difference between revisions
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 |
||
| 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#;