set feedback off
set timing on
select decode(status, 'COMPLETED', 0,1) as STATUS
from v$RMAN_BACKUP_JOB_DETAILS
where session_key = (select max(session_key) from v$RMAN_BACKUP_JOB_DETAILS where START_TIME > sysdate-10 and input_type in('DB FULL', 'DB INCR'));
Nenhum comentário:
Postar um comentário