Differences

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

--- oracle [2026/03/06 09:25] – mduersch
+++ oracle [2026/07/14 10:24] (current) – [Dataguard related] mduersch
@@ Line 1: / Line 1: @@
 ====== ORACLE ======
+==== EMCC ====
+  oracle@mytesthost:/oracle/product/agent/agent_24.1.0.0.0/bin # ./emctl control agent runCollection mytesthost:host   DiscoverTargets
+  Oracle Enterprise Manager 24ai Release 1
+  Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved.
+  ---------------------------------------------------------------
+  EMD runCollection completed successfully
+  oracle@mytesthost:/oracle/product/agent/agent_24.1.0.0.0/bin # ./emctl upload agent
+  Oracle Enterprise Manager 24ai Release 1
+  Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved.
+  ---------------------------------------------------------------
+  EMD upload completed successfully
 ==== CDB PDB ====
@@ Line 76: / Line 91: @@
          or network_service_banner like '%Crypto-checksumming service adapter%')
   and TYPE <> 'BACKGROUND';
+==== Audit Trail ====
+  SELECT os_username AS "OS User",
+       username AS "DB User",
+       userhost AS "Machine",
+       timestamp AS "Date",
+       returncode AS "Error Code"
+  FROM dba_audit_session
+  WHERE returncode != 0 ORDER BY timestamp DESC;
 ==== Grants by User ====
@@ Line 377: / 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
    ==========================