Oracle 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> 

Cancellazione archivelog nel db secondario

https://www.dbi-services.com/blog/archivelog-deletion-policy-for-standby-database-in-oracle-data-guard/