Forgot your password?
Document Actions
How to list the last BACKUP ONLINE for TABLESPACE
The last backup online for tablespace
col FILE_NAME format a65;
col STATUS format a20;
select A.TABLESPACE_NAME,
MIN(C.TIME) as INICIO,
C.STATUS
from DBA_TABLESPACES A,
DBA_DATA_FILES B,
V$BACKUP C
where A.TABLESPACE_NAME = B.TABLESPACE_NAME
and B.FILE_ID = C.FILE#
group by A.TABLESPACE_NAME,
C.STATUS
order by 1,3,2;
Hacker Rangers - Gamification for CyberSecurity