Differences

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

--- oracle [2025/12/09 14:24] – 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;
@@ Line 568: / Line 570: @@
    select LOG_MODE from v$database;
    select name from V$database;
+   # flashbackquery
+   select count(1) from somewhere
+                 AS OF TIMESTAMP TO_TIMESTAMP('2025-12-12 16:00', 'YYYY-MM-DD HH24:MI:SS')
+           where
+                 something is NULL;
 ==== GRANTS ====