Oracle Dataguard: differenze tra le versioni
Jump to navigation
Jump to search
Riga 2: | Riga 2: | ||
=Dataguard Broker= |
=Dataguard Broker= |
||
Creazione della configurazione (da eseguire sul primario) |
|||
<pre> |
|||
#-- 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 |
|||
</pre> |
|||
<pre> |
<pre> |
||
Versione delle 13:14, 31 gen 2023
Creazione 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>