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...") |
(No difference)
|
Revision as of 01:09, 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#;
