(SERVER = DEDICATED) (SERVICE_NAME = orclstd) (UR=A) ) ) orclstd1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orclstd1-vip)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclstd) (UR=A) ) ) orclstd2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orclstd2-vip)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclstd) (UR=A) ) ) 1.5 备库配置
1.5.1 创建备库pfile 参数文件
在主库生成pfile, 并复制备库节点上。并修改以下参数:
*.audit_file_dest='/oracle/app/oracle/admin/orcl/adump' *.audit_trail='db' *.cluster_database=true *.compatible='11.2.0.0.0' *.control_files='+DATA/orclstd/controlfile/current.256.869873351' *.db_block_size=8192 *.db_create_file_dest='+DATA' *.db_domain='' *.db_file_name_convert='+DATA','+DATA' *.db_name='orcl' *.db_unique_name='orclstd' *.diagnostic_dest='/oracle/app/oracle' *.fal_client='orclstd' *.fal_server='orcl' orcl1.instance_number=1 orcl2.instance_number=2 *.log_archive_config='DG_CONFIG=(orcl,orclstd)' *.log_archive_dest_1='LOCATION=+DATA DB_UNIQUE_NAME=orclstd' *.log_archive_dest_2='SERVICE=orcl DB_UNIQUE_NAME=orcl' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.log_archive_format='%t_%s_%r.arc' *.log_archive_max_processes=10 *.log_file_name_convert='+DATA','+DATA' *.open_cursors=300 *.pga_aggregate_target=156237824 *.processes=150 *.remote_listener='clusterstd-scan:1521' *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=469762048 *.standby_file_management='AUTO' orcl2.thread=2 orcl1.thread=1 orcl1.undo_tablespace='UNDOTBS1' orcl2.undo_tablespace='UNDOTBS2' ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
1.5.2 创建相关目录
在备库的两个节点上创建目录：
mkdir -p /oracle/app/oracle/admin/orcl/adump chmod 755 /oracle/app/oracle/admin/orcl/adump
1.5.3 创建密码文件
从主库节点对应复制密码文件到备库节点上
$cd $ORACLE_HOME/dbs $scp orapw* 192.168.0.21:/oracle/app/oracle/product/11.2.0/db_1/dbs $scp orapw* 192.168.0.22:/oracle/app/oracle/product/11.2.0/db_1/dbs --修改第二个节点的密码文件名 $mv orapworcl1 orapworcl2
1.5.4 设置DB的tnsnames.ora
orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cluster-scan)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) (UR=A) ) ) orcl1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl1-vip)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (UR=A) ) ) orcl2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl2-vip)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (UR=A) ) ) orclstd = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = clusterstd-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclstd) (UR=A) ) ) orclstd1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orclstd1-vip)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclstd) (UR=A) ) ) orclstd2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orclstd2-vip)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclstd) (UR=A) ) ) 1.5.5 配置监听
添加静态注册服务名
vi /oracle/app/11.2.0/grid/network/admin/listener.ora --添加： SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orclstd ) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1) (SID_NAME =orcl1) ) ) ADR_BASE_LISTENER = /oracle/app/grid ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent --重启监听器并查看： srvctl stop listener -n orclstd1 srvctl start listener -n orclstd1 lsnrctl status
1.5.6 创建ASM路径
$asmcmd cd data mkdir orclstd 1.5.7 启动备库
--使用修改好的参数文件启动standby实例到nomount状态 sqlplus \startup nomount pfile='/home/oracle/initorclstd.ora'