Oracle Dataguard: differenze tra le versioni
Jump to navigation
Jump to search
Nessun oggetto della modifica |
|||
Riga 4: | Riga 4: | ||
<pre> |
<pre> |
||
DGMGRL> show database |
DGMGRL> show database SID01_S |
||
Database - |
Database - SID01_S |
||
Role: PHYSICAL STANDBY |
Role: PHYSICAL STANDBY |
||
Riga 15: | Riga 15: | ||
Real Time Query: OFF |
Real Time Query: OFF |
||
Instance(s): |
Instance(s): |
||
SID01 |
|||
Database Error(s): |
Database Error(s): |
||
Riga 26: | Riga 26: | ||
ERROR |
ERROR |
||
DGMGRL> edit database |
DGMGRL> edit database SID01_S set state='apply-off'; |
||
Succeeded. |
Succeeded. |
||
DGMGRL> edit database |
DGMGRL> edit database SID01_S set state='apply-on'; |
||
Succeeded. |
Succeeded. |
||
DGMGRL> |
DGMGRL> |
Versione delle 16:39, 6 ott 2022
Creazione dataguard
Dataguard Broker
DGMGRL> show database SID01_S Database - SID01_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): SID01 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 SID01_S set state='apply-off'; Succeeded. DGMGRL> edit database SID01_S set state='apply-on'; Succeeded. DGMGRL>