Showing posts with label Archive. Show all posts
Showing posts with label Archive. Show all posts

Tuesday, May 8, 2012

Script to Report Datafile Archive Status

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