【【Data Guard for Oracle 11.2.3】】*****************************************************************************************************************************
【生产环境部署Phisycal Standby】
前提:
*安装操作系统并优化
*配置存储磁盘或RAID并划分LAN
*划分网络并配置双网卡绑定
一、部署Oracle
主库服务器部署Oracle软件,监听,Oracle数据库
备库服务器部署Oracle软件,监听
二、配置参数文件
配置Primary参数
alter system set db_unique_name='meitao_1' scope=spfile;
alter system set log_archive_config='DG_CONFIG=(meitao_1,meitao_2)' scope=spfile;
alter system set log_archive_dest_2='SERVICE=meitao_2 LGWR SYNC AFFIRM REOPEN=1800 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=meitao_2' scope=both
alter system set log_archive_dest_state_2='defer' scope=spfile;
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
alter system set fal_client='meitao_1' scope=spfile;
alter system set fal_server='meitao_2' scope=spfile;
alter system set standby_file_management='AUTO' scope=spfile;
shutdown immediate
startup mount
alter database archivelog;
alter database force logging;
alter database open;
添加Standby Redolog
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 11 ('/u01/app/oracle/oradata/meitao/redo11a.log','/u01/app/oracle/oradata/meitao/redo11b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 12 ('/u01/app/oracle/oradata/meitao/redo12a.log','/u01/app/oracle/oradata/meitao/redo12b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 13 ('/u01/app/oracle/oradata/meitao/redo13a.log','/u01/app/oracle/oradata/meitao/redo13b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 14 ('/u01/app/oracle/oradata/meitao/redo14a.log','/u01/app/oracle/oradata/meitao/redo14b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 15 ('/u01/app/oracle/oradata/meitao/redo15a.log','/u01/app/oracle/oradata/meitao/redo15b.l
【生产环境部署Phisycal Standby】
前提:
*安装操作系统并优化
*配置存储磁盘或RAID并划分LAN
*划分网络并配置双网卡绑定
一、部署Oracle
主库服务器部署Oracle软件,监听,Oracle数据库
备库服务器部署Oracle软件,监听
二、配置参数文件
配置Primary参数
alter system set db_unique_name='meitao_1' scope=spfile;
alter system set log_archive_config='DG_CONFIG=(meitao_1,meitao_2)' scope=spfile;
alter system set log_archive_dest_2='SERVICE=meitao_2 LGWR SYNC AFFIRM REOPEN=1800 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=meitao_2' scope=both
alter system set log_archive_dest_state_2='defer' scope=spfile;
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
alter system set fal_client='meitao_1' scope=spfile;
alter system set fal_server='meitao_2' scope=spfile;
alter system set standby_file_management='AUTO' scope=spfile;
shutdown immediate
startup mount
alter database archivelog;
alter database force logging;
alter database open;
添加Standby Redolog
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 11 ('/u01/app/oracle/oradata/meitao/redo11a.log','/u01/app/oracle/oradata/meitao/redo11b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 12 ('/u01/app/oracle/oradata/meitao/redo12a.log','/u01/app/oracle/oradata/meitao/redo12b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 13 ('/u01/app/oracle/oradata/meitao/redo13a.log','/u01/app/oracle/oradata/meitao/redo13b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 14 ('/u01/app/oracle/oradata/meitao/redo14a.log','/u01/app/oracle/oradata/meitao/redo14b.log') SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 15 ('/u01/app/oracle/oradata/meitao/redo15a.log','/u01/app/oracle/oradata/meitao/redo15b.l