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 revisionNext revisionBoth sides next revision | ||
oracle:dataguard_mini-howto [2018/04/27 09:01] – dodger | dba:oracle:dataguard_mini-howto [2022/02/11 11:12] – ↷ Page moved from oracle:dataguard_mini-howto to dba:oracle:dataguard_mini-howto dodger | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== [HOWTO] Summary of Dataguard creation ====== | + | ====== [DOC] Summary of Dataguard creation ====== |
===== creation ===== | ===== creation ===== | ||
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 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 | COL CLIENT_DBID |
dba/oracle/docs/dataguard_mini-howto.txt · Last modified: 2023/01/31 08:22 by dodger