Starts managed recovery on all
It : Finds all running Oracle database instances (except ASM, MGMT, etc.) For each one : Connects as SYSDBA Starts Managed Standby Recovery This excludes :- +ASM → Oracle ASM instance Exadata → likely Exadata-related instances MGMT → management database the grep command itself
oraclebashhigh-availabilityv1.0.0
0 stars0 downloads31 views1 comments
By Mahmoud • Created
Code
(13 lines)12345678910111213
Vi sync.sh
for i in `ps -ef |grep pmon |grep -v +ASM |grep -v exadata |grep -v MGMT |grep -v grep |awk -F "ora_pmon_" '{print $2}' |grep -v print`
do
export ORACLE_SID=$i
echo $ORACLE_HOME
echo $ORACLE_SID
$ORACLE_HOME/bin/sqlplus -s / as sysdba <<EOF
def
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
exit;
EOF
done