8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: recovery_status.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- 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