set pagesize 2000
set lines 2000
col MESSAGE for a90
select message,timestamp from V$DATAGUARD_STATUS where timestamp > sysdate – 1/6;
MESSAGE TIMESTAMP
—————————————————————————————— ———
RFS[48]: No standby redo logfiles created 05-AUG-15
Media Recovery Log /uv1010/arch/MRSX/arch_MRSX_779539386_1_49481.log 05-AUG-15
Media Recovery Waiting for thread 1 sequence 49482 (in transit) 05-AUG-15
RFS[48]: No standby redo logfiles created 05-AUG-15
Media Recovery Log /uv1010/arch/MRSX/arch_MRSX_779539386_1_49482.log 05-AUG-15
Media Recovery Waiting for thread 1 sequence 49483 (in transit) 05-AUG-15

6 rows selected.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.