Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:oracle:docs:dataguard_mini-howto

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
oracle:dataguard_mini-howto [2018/04/27 09:02] – dodgeroracle:dataguard_mini-howto [2018/07/11 15:13] – [Standby Apply process status] dodger
Line 264: Line 264:
 </code> </code>
  
 +
 +===== List of archived_log ordered =====
 +<code sql>
 +SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE# ;
 +</code>
 ===== Determine the most recently archived redo log file at each redo transport destination ===== ===== Determine the most recently archived redo log file at each redo transport destination =====
 <code sql> <code sql>
Line 284: Line 289:
 on any node on any node
 <code sql> <code sql>
 +COL FACILITY FORMAT A40;
 +COL SEVERITY FORMAT A30;
 COL MESSAGE FORMAT A120; COL MESSAGE FORMAT A120;
 SELECT * FROM V$DATAGUARD_STATUS ; SELECT * FROM V$DATAGUARD_STATUS ;
Line 291: Line 298:
 ===== Standby Apply process status ===== ===== Standby Apply process status =====
 <code sql> <code sql>
 +COL PID format A10;
 COL CLIENT_PID FORMAT A10 ; COL CLIENT_PID FORMAT A10 ;
 COL CLIENT_DBID  FORMAT A12 ; COL CLIENT_DBID  FORMAT A12 ;
dba/oracle/docs/dataguard_mini-howto.txt · Last modified: 2023/01/31 08:22 by dodger