This script shows the status of your datafile backup.
REM LOCATION: Backup Recovery\Reports
REM FUNCTION: Show database datafile Archive status
REM TESTED ON: 7.3.3.5, 8.0.4.1, 8.1.5, 8.1.7, 9.0.1, 10.2.0.3, 11.1.0.6
REM PLATFORM: non-specific
REM REQUIRES: sys.v_$datafile, sys.v_$backup
REM
REM
REM************************* Oracle Administration *************************
COLUMN name format a43
COLUMN arc heading 'Backup Status'
SET lines 132 pages 59 feedback off
Ttitle "Database File Backup Status"
SELECT NAME, a.status, DECODE (b.status, 'Active', 'Backup', 'Normal') arc,
enabled, bytes, change#, TIME ARCHIVE
FROM sys.v_$datafile a, sys.v_$backup b
WHERE a.file# = b.file#;
CLEAR columns
TTITLE off
