Oracle Datafile Recovery Status Report
Displays the recovery or backup status of each datafile in the Oracle database. Useful for checking whether datafiles are currently in backup mode or require recovery attention.
oraclesqlbackup-restorev1.0.0
0 stars0 downloads15 views0 comments
By OracleDba • Created
Code
(20 lines)1234567891011121314151617181920
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/recovery_status.sql
-- Author : Tim Hall
-- Description : Displays the recovery status of each datafile.
-- Requirements : Access to the V$ views.
-- Call Syntax : @recovery_status
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SET LINESIZE 500
SET PAGESIZE 500
SET FEEDBACK OFF
SELECT Substr(a.name,1,60) "Datafile",
b.status "Status"
FROM v$datafile a,
v$backup b
WHERE a.file# = b.file#;
SET PAGESIZE 14
SET FEEDBACK ON