dba:oracle:docs:dataguard_mini-howto
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
oracle:dataguard_mini-howto [2018/06/01 08:31] – [Standby Apply process status] dodger | dba:oracle:docs:dataguard_mini-howto [2023/01/31 08:22] (current) – ↷ Page moved from dba:oracle:dataguard_mini-howto to dba:oracle:docs:dataguard_mini-howto dodger | ||
---|---|---|---|
Line 264: | Line 264: | ||
</ | </ | ||
+ | |||
+ | ===== List of archived_log ordered ===== | ||
+ | <code sql> | ||
+ | SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE# ; | ||
+ | </ | ||
===== 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 293: | Line 298: | ||
===== Standby Apply process status ===== | ===== Standby Apply process status ===== | ||
<code sql> | <code sql> | ||
- | COL PID A10; | + | COL PID format |
COL CLIENT_PID FORMAT A10 ; | COL CLIENT_PID FORMAT A10 ; | ||
COL CLIENT_DBID | COL CLIENT_DBID |
dba/oracle/docs/dataguard_mini-howto.txt · Last modified: 2023/01/31 08:22 by dodger