— 步骤2：配置主库
# 编辑主库参数文件
vi /yashandb/fgdata/fgedudb/pfile.ora

# 添加以下参数
log_archive_dest_2 = ‘service=standby_db lgwr async valid_for=(all_logfiles,all_roles) db_unique_name=standby_db’
log_archive_config = ‘dg_config=(primary_db,standby_db)’
db_unique_name = ‘primary_db’
fal_server = ‘standby_db’
fal_client = ‘primary_db’

— 步骤3：配置备库
# 编辑备库参数文件
vi /yashandb/fgdata/standbydb/pfile.ora

# 添加以下参数
log_archive_dest_2 = ‘service=primary_db lgwr async valid_for=(all_logfiles,all_roles) db_unique_name=primary_db’
log_archive_config = ‘dg_config=(primary_db,standby_db)’
db_unique_name = ‘standby_db’
fal_server = ‘primary_db’
fal_client = ‘standby_db’
standby_file_management = ‘AUTO’

— 步骤4：创建密码文件
# 在主库上创建密码文件
orapwd file=/yashandb/app/dbs/orapwprimary_db password=sys123 force=y

# 复制密码文件到备库
scp /yashandb/app/dbs/orapwprimary_db oracle@192.168.1.101:/yashandb/app/dbs/orapwstandby_db

— 步骤5：配置网络
# 在主库和备库上配置tnsnames.ora
vi /yashandb/app/network/admin/tnsnames.ora

PRIMARY_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primary_db)
)
)

STANDBY_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby_db)
)
)

— 步骤6：启动备库到挂载状态
# 在备库上执行
startup mount;

— 步骤7：配置主从复制
# 在主库上执行
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

# 在备库上执行
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

— 步骤8：创建灾备自动化脚本
# 创建监控脚本
vi /yashandb/app/scripts/dr_monitor.sh

#!/bin/bash
# dr_monitor.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`

PRIMARY_HOST=”192.168.1.100″
STANDBY_HOST=”192.168.1.101″
PRIMARY_SID=”primary_db”
STANDBY_SID=”standby_db”
USERNAME=”sys”
PASSWORD=”sys123″

PRIMARY_STATUS=$(sqlplus -S ${USERNAME}/${PASSWORD}@${PRIMARY_HOST}:1521/${PRIMARY_SID} as sysdba << EOF SELECT status FROM v\$instance; EOF ) if [[ "${PRIMARY_STATUS}" != *"OPEN"* ]]; then echo "Primary database is down, initiating failover..." ssh oracle@${STANDBY_HOST} "sqlplus -S ${USERNAME}/${PASSWORD}@${STANDBY_SID} as sysdba << EOF ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; ALTER DATABASE OPEN; EOF " echo "Failover completed successfully" fi # 创建故障转移脚本 vi /yashandb/app/scripts/dr_failover.sh #!/bin/bash # dr_failover.sh # from:www.itpux.com.qq113257174.wx:itpux-com # web: `http://www.fgedu.net.cn` STANDBY_HOST="192.168.1.101" STANDBY_SID="standby_db" USERNAME="sys" PASSWORD="sys123" ssh oracle@${STANDBY_HOST} "sqlplus -S ${USERNAME}/${PASSWORD}@${STANDBY_SID} as sysdba << EOF ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; ALTER DATABASE OPEN; EOF " echo "Failover completed successfully" -- 步骤9：设置脚本执行权限 chmod +x /yashandb/app/scripts/dr_monitor.sh chmod +x /yashandb/app/scripts/dr_failover.sh -- 步骤10：创建定时任务 crontab -e # 每5分钟执行一次监控脚本 */5 * * * * /yashandb/app/scripts/dr_monitor.sh >> /yashandb/app/scripts/dr_monitor.log 2>&1

— 步骤11：测试灾备自动化
# 模拟主库故障
ssh oracle@192.168.1.100 “sqlplus -S sys/sys123@primary_db as sysdba << EOF SHUTDOWN ABORT; EOF " # 查看监控日志 cat /yashandb/app/scripts/dr_monitor.log -- 输出结果 Primary database is down, initiating failover... Failover completed successfully -- 验证备库成为主库 ssh oracle@192.168.1.101 "sqlplus -S sys/sys123@standby_db as sysdba << EOF SELECT status FROM v\$instance; EOF " -- 输出结果 STATUS ------------ OPEN

— 步骤2：配置主库
# 编辑主库参数文件
vi /yashandb/fgdata/fgedudb/pfile.ora

# 添加以下参数
db_unique_name = ‘dc1_db’
log_archive_config = ‘dg_config=(dc1_db, dc2_db)’
log_archive_dest_2 = ‘service=dc2_db lgwr async valid_for=(all_logfiles,all_roles) db_unique_name=dc2_db’
fal_server = ‘dc2_db’
fal_client = ‘dc1_db’

— 步骤3：配置备库
# 编辑备库参数文件
vi /yashandb/fgdata/fgedudb/pfile.ora

# 添加以下参数
db_unique_name = ‘dc2_db’
log_archive_config = ‘dg_config=(dc1_db, dc2_db)’
log_archive_dest_2 = ‘service=dc1_db lgwr async valid_for=(all_logfiles,all_roles) db_unique_name=dc1_db’
fal_server = ‘dc1_db’
fal_client = ‘dc2_db’
standby_file_management = ‘AUTO’

— 步骤4：配置网络
# 在两个数据中心配置tnsnames.ora
vi /yashandb/app/network/admin/tnsnames.ora

DC1_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dc1_db)
)
)

DC2_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dc2_db)
)
)

— 步骤5：启动备库到挂载状态
# 在备库上执行
startup mount;

— 步骤6：配置主从复制
# 在主库上执行
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

# 在备库上执行
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

— 步骤7：配置多活
# 在备库上启用只读模式
ALTER DATABASE OPEN READ ONLY;

— 步骤8：创建多活监控脚本
vi /yashandb/app/scripts/multi_active_monitor.sh

#!/bin/bash
# multi_active_monitor.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`

DC1_HOST=”192.168.1.100″
DC2_HOST=”192.168.2.100″
DC1_SID=”dc1_db”
DC2_SID=”dc2_db”
USERNAME=”sys”
PASSWORD=”sys123″

# 检查数据中心1状态
DC1_STATUS=$(sqlplus -S ${USERNAME}/${PASSWORD}@${DC1_HOST}:1521/${DC1_SID} as sysdba << EOF SELECT status FROM v\$instance; EOF ) # 检查数据中心2状态 DC2_STATUS=$(sqlplus -S ${USERNAME}/${PASSWORD}@${DC2_HOST}:1521/${DC2_SID} as sysdba << EOF SELECT status FROM v\$instance; EOF ) # 检查复制状态 REPLICATION_STATUS=$(sqlplus -S ${USERNAME}/${PASSWORD}@${DC2_HOST}:1521/${DC2_SID} as sysdba << EOF SELECT status FROM v\$managed_standby; EOF ) # 输出监控结果 echo "Data Center 1 Status: ${DC1_STATUS}" echo "Data Center 2 Status: ${DC2_STATUS}" echo "Replication Status: ${REPLICATION_STATUS}" # 检查数据中心1是否故障 if [[ "${DC1_STATUS}" != *"OPEN"* ]]; then echo "Data Center 1 is down, promoting Data Center 2 to primary..." ssh oracle@${DC2_HOST} "sqlplus -S ${USERNAME}/${PASSWORD}@${DC2_SID} as sysdba << EOF ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; ALTER DATABASE OPEN; EOF " echo "Data Center 2 promoted to primary successfully" fi -- 步骤9：设置脚本执行权限 chmod +x /yashandb/app/scripts/multi_active_monitor.sh -- 步骤10：创建定时任务 crontab -e # 每5分钟执行一次监控脚本 */5 * * * * /yashandb/app/scripts/multi_active_monitor.sh >> /yashandb/app/scripts/multi_active_monitor.log 2>&1

— 步骤11：测试多活灾备
# 模拟数据中心1故障
ssh oracle@192.168.1.100 “sqlplus -S sys/sys123@dc1_db as sysdba << EOF SHUTDOWN ABORT; EOF " # 查看监控日志 cat /yashandb/app/scripts/multi_active_monitor.log -- 输出结果 Data Center 1 is down, promoting Data Center 2 to primary... Data Center 2 promoted to primary successfully -- 验证数据中心2成为主库 ssh oracle@192.168.2.100 "sqlplus -S sys/sys123@dc2_db as sysdba << EOF SELECT status FROM v\$instance; EOF " -- 输出结果 STATUS ------------ OPEN

— 步骤2：配置主库
# 编辑主库参数文件
vi /yashandb/fgdata/fgedudb/pfile.ora

# 添加以下参数
db_unique_name = ‘beijing_db’
log_archive_config = ‘dg_config=(beijing_db, shanghai_db)’
log_archive_dest_2 = ‘service=shanghai_db lgwr async valid_for=(all_logfiles,all_roles) db_unique_name=shanghai_db’
fal_server = ‘shanghai_db’
fal_client = ‘beijing_db’

— 步骤3：配置备库
# 编辑备库参数文件
vi /yashandb/fgdata/fgedudb/pfile.ora

# 添加以下参数
db_unique_name = ‘shanghai_db’
log_archive_config = ‘dg_config=(beijing_db, shanghai_db)’
log_archive_dest_2 = ‘service=beijing_db lgwr async valid_for=(all_logfiles,all_roles) db_unique_name=beijing_db’
fal_server = ‘beijing_db’
fal_client = ‘shanghai_db’
standby_file_management = ‘AUTO’

— 步骤4：配置网络
# 在两个区域配置tnsnames.ora
vi /yashandb/app/network/admin/tnsnames.ora

BEIJING_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = beijing_db)
)
)

SHANGHAI_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = shanghai_db)
)
)

— 步骤5：启动备库到挂载状态
# 在备库上执行
startup mount;

— 步骤6：配置主从复制
# 在主库上执行
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

# 在备库上执行
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

— 步骤7：创建跨区域灾备监控脚本
vi /yashandb/app/scripts/cross_region_dr_monitor.sh

#!/bin/bash
# cross_region_dr_monitor.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`

BEIJING_HOST=”10.0.1.100″
SHANGHAI_HOST=”10.0.2.100″
BEIJING_SID=”beijing_db”
SHANGHAI_SID=”shanghai_db”
USERNAME=”sys”
PASSWORD=”sys123″

# 检查北京区域状态
BEIJING_STATUS=$(sqlplus -S ${USERNAME}/${PASSWORD}@${BEIJING_HOST}:1521/${BEIJING_SID} as sysdba << EOF SELECT status FROM v\$instance; EOF ) # 检查上海区域状态 SHANGHAI_STATUS=$(sqlplus -S ${USERNAME}/${PASSWORD}@${SHANGHAI_HOST}:1521/${SHANGHAI_SID} as sysdba << EOF SELECT status FROM v\$instance; EOF ) # 输出监控结果 echo "Beijing Region Status: ${BEIJING_STATUS}" echo "Shanghai Region Status: ${SHANGHAI_STATUS}" # 检查北京区域是否故障 if [[ "${BEIJING_STATUS}" != *"OPEN"* ]]; then echo "Beijing region is down, promoting Shanghai region to primary..." ssh oracle@${SHANGHAI_HOST} "sqlplus -S ${USERNAME}/${PASSWORD}@${SHANGHAI_SID} as sysdba << EOF ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; ALTER DATABASE OPEN; EOF " echo "Shanghai region promoted to primary successfully" fi -- 步骤8：设置脚本执行权限 chmod +x /yashandb/app/scripts/cross_region_dr_monitor.sh -- 步骤9：创建定时任务 crontab -e # 每5分钟执行一次监控脚本 */5 * * * * /yashandb/app/scripts/cross_region_dr_monitor.sh >> /yashandb/app/scripts/cross_region_dr_monitor.log 2>&1

— 步骤10：测试跨区域灾备
# 模拟北京区域故障
ssh oracle@10.0.1.100 “sqlplus -S sys/sys123@beijing_db as sysdba << EOF SHUTDOWN ABORT; EOF " # 查看监控日志 cat /yashandb/app/scripts/cross_region_dr_monitor.log -- 输出结果 Beijing region is down, promoting Shanghai region to primary... Shanghai region promoted to primary successfully -- 验证上海区域成为主库 ssh oracle@10.0.2.100 "sqlplus -S sys/sys123@shanghai_db as sysdba << EOF SELECT status FROM v\$instance; EOF " -- 输出结果 STATUS ------------ OPEN