Différences
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente Prochaine révisionLes deux révisions suivantes | ||
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) ===== | ||
+ | |||
+ | < | ||
+ | [oracle@oda2db0host PHBIO1 dbhome_2]$ | ||
+ | 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. | ||
+ | |||
+ | Welcome to DGMGRL, type " | ||
+ | Password: | ||
+ | Connected to " | ||
+ | Connected as SYSDBA. | ||
+ | DGMGRL> show configuration | ||
+ | |||
+ | Configuration - dg_phbio | ||
+ | |||
+ | Protection Mode: MaxPerformance | ||
+ | Members: | ||
+ | p72hbio - Primary database | ||
+ | p21hbio - Physical standby database | ||
+ | |||
+ | Fast-Start Failover: | ||
+ | |||
+ | Configuration Status: | ||
+ | SUCCESS | ||
+ | |||
+ | DGMGRL> | ||
+ | |||
+ | Database - p21hbio | ||
+ | |||
+ | Role: | ||
+ | Intended State: | ||
+ | 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: | ||
+ | Instance(s): | ||
+ | PHBIO1 (apply instance) | ||
+ | PHBIO2 | ||
+ | |||
+ | Database Status: | ||
+ | SUCCESS | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
===== Voir ce qu'il se passe ===== | ===== Voir ce qu'il se passe ===== | ||
< | < | ||
- | [21/ | ||
set head off pages 0 lines 120 | set head off pages 0 lines 120 | ||
select | select |