Find_stale_dr.sql finding stale physical DR..

col name format a50

col UNRECOVERABLE_CHANGE# format 999999999999999999999

col dt1 format a30

set lines 120 pages 200

SELECT NAME, UNRECOVERABLE_CHANGE#, TO_CHAR (UNRECOVERABLE_TIME,’DD-MON-YYYY HH:MI:SS’) dt1

FROM V$DATAFILE

WHERE UNRECOVERABLE_CHANGE# != 0;