Differences

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

--- oracle [2026/07/03 05:19] – [EMCC] mduersch
+++ oracle [2026/07/14 10:24] (current) – [Dataguard related] mduersch
@@ Line 402: / Line 402: @@
    select * from v$block_change_tracking;
    select dest_id, destination, status, error, transmit_mode from v$archive_dest where destination is not null;
+   # Anfragen
+   col DB_UNIQUE_NAME for a10
+   col OPEN_MODE for a20
+   col DATABASE_ROLE for a20
+   col LOG_MODE for a10
+   set lines 200
+   select DBID,NAME,LOG_MODE,OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,DB_UNIQUE_NAME,RESETLOGS_TIME from V$database;
+   # Transport log
+   select process, pid, status from v$managed_standby where process='RFS';
    # Paramter abfragen
    ==========================