Oracle Dataguard

Dataguard Broker

Creazione della configurazione (da eseguire sul primario)

#-- Create standby logs
${ORACLE_HOME}/bin/dgmgrl  << !EOF_BRO
connect sys/${2}@${ORACLE_SID}_P
create configuration 'BROKER1' as primary database is '${ORACLE_SID}_P' connect identifier is '${ORACLE_SID}_P';
add database '${ORACLE_SID}_S' as connect identifier is '${ORACLE_SID}_S' maintained as physical;
enable configuration;
show configuration;
exit;
!EOF_BRO

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>