THE Wiki

User Tools

Site Tools

Trace: • python
oracle

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
oracle [2026/07/03 05:19] – [EMCC] mduerschoracle [2026/07/14 10:24] (current) – [Dataguard related] mduersch
Line 402: Line 402:
    select * from v$block_change_tracking;     select * from v$block_change_tracking; 
    select dest_id, destination, status, error, transmit_mode from v$archive_dest where destination is not null;    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    # Paramter abfragen
    ==========================    ==========================
oracle.txt · Last modified: by mduersch