Este script foi desenvolvido para simplificar a verificação do status do Oracle Data Guard Broker em todos os databases configurados em um mesmo servidor.
Em ambientes que hospedam diversas instâncias Oracle, realizar essa validação individualmente pode ser uma tarefa repetitiva e demorada. Para otimizar esse processo, este shell script automatiza a verificação do Data Guard Broker em todas as instâncias cadastradas, proporcionando maior agilidade, praticidade e eficiência na administração do ambiente.
Pré-requisito: Não é necessário configurar variáveis de ambiente. O script utiliza o arquivo oratab para identificar as instâncias Oracle; portanto, todos os databases devem possuir uma entrada válida nesse arquivo.
for ORACLE_SID in `ps -e -o "cmd" | grep smon|grep -v grep|awk '!/ASM/'| awk -F "_" '{print$3}'`
do
ORAENV_ASK=NO
export ORAENV_ASK
export ORACLE_SID
echo "Instancia: "$ORACLE_SID
. /usr/local/bin/oraenv >/dev/null 2>&1
#echo SID=$ORACLE_SID
dgmgrl / <<< 'show configuration;'
echo ""
echo "====================================================================================="
echo ""
doneOutput:
Instancia: MICORP1
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
Configuration - dg_micorp
Protection Mode: MaxPerformance
Databases:
micorpdg - Primary database
micorp - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> DGMGRL>
=====================================================================================
Instancia: MIDWPROD1
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
Configuration - dg_midwprod
Protection Mode: MaxPerformance
Databases:
midwproddg - Primary database
midwprod - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> DGMGRL>
=====================================================================================
Instancia: MIDEV1
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
Configuration - dg_midev
Protection Mode: MaxPerformance
Databases:
midevdg - Primary database
midev - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> DGMGRL>
=====================================================================================
Instancia: MIDRSEI1
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> Error:
ORA-16525: the Data Guard broker is not yet available
Configuration details cannot be determined by DGMGRL
DGMGRL> DGMGRL>
=====================================================================================
Instancia: MIECMHML1
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
Configuration - dg_miecmhml
Protection Mode: MaxPerformance
Databases:
miecmhmldg - Primary database
miecmhml - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> DGMGRL>
=====================================================================================
Instancia: MIPROD1
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
Configuration - dg_miprod
Protection Mode: MaxPerformance
Databases:
miproddg - Primary database
miprod - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> DGMGRL>
=====================================================================================
Instancia: MIHML1
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
Configuration - dg_mihml
Protection Mode: MaxPerformance
Databases:
mihmldg - Primary database
mihml - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> DGMGRL>
=====================================================================================
Espero que este script seja útil no seu dia a dia e contribua para simplificar a administração de ambientes Oracle com Oracle Data Guard Broker.