Oracle Dataguard: differenze tra le versioni
Jump to navigation
Jump to search
Nessun oggetto della modifica |
|||
Riga 44: | Riga 44: | ||
DGMGRL> |
DGMGRL> |
||
</pre> |
</pre> |
||
=Cancellazione archivelog nel db secondario= |
|||
https://www.dbi-services.com/blog/archivelog-deletion-policy-for-standby-database-in-oracle-data-guard/ |
|||
[[Categoria:Database]] |
[[Categoria:Database]] |
Versione attuale delle 16:02, 28 nov 2023
Creazione dataguard
Dataguard Broker
Creazione della configurazione (da eseguire sul primario)
dgmgrl << EOF connect sys/password@SID01_P create configuration 'BROKER1' as primary database is 'SID01_P' connect identifier is 'SID01_P'; add database 'SID01_S' as connect identifier is 'SID01_S' maintained as physical; enable configuration; show configuration; exit; EOF
Verifica dello stato:
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>