Oracle 11g ADG（Active Data Guard）切换脚本的示例

以下是一个Oracle 11g ADG（Active Data Guard）切换脚本的示例，用于将ADG从当前主服务器切换到备用服务器。

#!/bin/bash

# Set Oracle environment variables
ORACLE_SID=<primary_database_sid>
ORACLE_HOME=<oracle_home>
export ORACLE_SID ORACLE_HOME

# Check if ADG is enabled
ADG_STATUS=`$ORACLE_HOME/bin/sqlplus -S / as sysdba << EOF
set heading off
set feedback off
select database_role from v\$database;
exit;
EOF`

if [ "$ADG_STATUS" != "PHYSICAL STANDBY" ]; then
  echo "Error: ADG is not enabled on this server"
  exit 1
fi

# Stop redo apply on standby server
$ORACLE_HOME/bin/sqlplus -S / as sysdba << EOF
alter database recover managed standby database cancel;
exit;
EOF

# Check if redo apply is stopped
REDO_APPLY_STATUS=`$ORACLE_HOME/bin/sqlplus -S / as sysdba << EOF
set heading off
set feedback off
select status from v\$archive_dest_status where dest_id=2;
exit;
EOF`

if [ "$REDO_APPLY_STATUS" != "DEFERRED" ]; then
  echo "Error: Failed to stop redo apply on standby server"
  exit 1
fi

# Switchover to standby server
$ORACLE_HOME/bin/sqlplus -S / as sysdba << EOF
alter database commit to switchover to standby with session shutdown;
exit;
EOF

# Start redo apply on new primary server
ssh <standby_server> "$ORACLE_HOME/bin/sqlplus -S / as sysdba << EOF
alter database recover managed standby database disconnect from session;
exit;
EOF"

# Check if switchover is successful
SWITCHOVER_STATUS=`$ORACLE_HOME/bin/sqlplus -S / as sysdba << EOF
set heading off
set feedback off
select database_role from v\$database;
exit;
EOF`

if [ "$SWITCHOVER_STATUS" != "PRIMARY" ]; then
  echo "Error: Failed to switch to standby server"
  exit 1
fi

echo "ADG switchover successful"
exit 0

在脚本中，首先设置Oracle环境变量，然后检查ADG是否已在当前服务器上启用。接着停止备用服务器上的重做应用，然后执行切换操作并将数据库切换到备用服务器上。最后，在新的主服务器上启动重做应用，并检查切换是否成功。
注意：在使用此脚本之前，请确保已备份所有相关的数据和文件，以及在测试环境中进行测试。