Différences

Ci-dessous, les différences entre deux révisions de la page.

--- informatique:base_de_donnees:tips [2019/10/21 14:53] – ben
+++ informatique:base_de_donnees:tips [2023/03/21 09:27] – ben
@@ Ligne 1: / Ligne 1: @@
+===== Switchover (Dataguard) =====
+<code>
+[oracle@oda2db0host PHBIO1 dbhome_2]$  dgmgrl sys@P72HBIO
+DGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Mar 21 09:27:07 2023
+Version 19.15.0.0.0
+Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
+Welcome to DGMGRL, type "help" for information.
+Password:
+Connected to "P72HBIO"
+Connected as SYSDBA.
+DGMGRL> show configuration
+Configuration - dg_phbio
+  Protection Mode: MaxPerformance
+  Members:
+  p72hbio - Primary database
+    p21hbio - Physical standby database
+Fast-Start Failover:  Disabled
+Configuration Status:
+SUCCESS   (status updated 17 seconds ago)
+DGMGRL>  show database p21hbio ;
+Database - p21hbio
+  Role:               PHYSICAL STANDBY
+  Intended State:     APPLY-ON
+  Transport Lag:      0 seconds (computed 1 second ago)
+  Apply Lag:          0 seconds (computed 1 second ago)
+  Average Apply Rate: 67.00 KByte/s
+  Real Time Query:    OFF
+  Instance(s):
+    PHBIO1 (apply instance)
+    PHBIO2
+Database Status:
+SUCCESS
+</code>
 ===== Voir ce qu'il se passe =====