Differences

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

--- oracle [2025/12/15 08:24] – [SELECTS] mduersch
+++ oracle [2026/03/06 09:25] (current) – mduersch
@@ Line 358: / Line 358: @@
 ==== Dataguard related ====
+   SELECT DEST_ID, DESTINATION, STATUS, GAP_STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ#, FROM V$ARCHIVE_DEST_STATUS WHERE STATUS <> 'INACTIVE'
    select database_role, open_mode from v$database;
    select processm, status, sequence# from v$managed_standby;