Oracle Dataguard: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con "<pre> DGMGRL> show database CAQ04601_S Database - CAQ04601_S Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed...") |
Nessun oggetto della modifica |
||
| Riga 1: | Riga 1: | ||
=Creazione dataguard= |
|||
=Dataguard Broker= |
|||
<pre> |
<pre> |
||
Versione delle 16:33, 6 ott 2022
Creazione dataguard
Dataguard Broker
DGMGRL> show database CAQ04601_S
Database - CAQ04601_S
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 1 second ago)
Apply Lag: 3 days 4 hours 38 minutes 27 seconds (computed 1 second ago)
Average Apply Rate: 27.00 KByte/s
Real Time Query: OFF
Instance(s):
CAQ04601
Database Error(s):
ORA-16766: Redo Apply is stopped
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
Database Status:
ERROR
DGMGRL> edit database CAQ04601_S set state='apply-off';
Succeeded.
DGMGRL> edit database CAQ04601_S set state='apply-on';
Succeeded.
DGMGRL>