oracle主备库搭建,oracle DG 主备库为RAC及一个主库对多个从库的实验环境搭建

主库RAC：192.168.1.210node1192.168.1.211node2备库(1)RAC:&..

主库 RAC ：192.168.1.210 node1

192.168.1.211 node2

备库(1) RAC:    192.168.1.247 rac1

192.168.1.248 rac2

备库(2) 单实例：192.168.1.219 dataguard

以上均为ASM管理。

实验步骤：

修改备库的参数文件:

MECBS2.__db_cache_size=213909504

SMS2.__db_cache_size=213909504

SMS1.__db_cache_size=268435456

SMS2.__java_pool_size=4194304

SMS1.__java_pool_size=4194304

SMS2.__large_pool_size=16777216

SMS1.__large_pool_size=16777216

SMS2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

SMS1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

SMS2.__pga_aggregate_target=163577856

SMS1.__pga_aggregate_target=163577856

SMS2.__sga_target=486539264

SMS1.__sga_target=486539264

SMS2.__shared_io_pool_size=0

SMS1.__shared_io_pool_size=0

SMS2.__shared_pool_size=184549376

SMS1.__shared_pool_size=184549376

SMS2.__streams_pool_size=0

SMS1.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/SMS/adump'

*.audit_trail='DB'

*.cluster_database=TRUE

*.compatible='11.2.0.4.0'

*.control_file_record_keep_time=30

*.control_files='+DATA/sms/controlfile/control01','+RECO/sms/controlfile/control02'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain=''

*.db_file_name_convert='+DATA/mecbs','+DATA/sms'

*.db_name='MECBS'

*.db_unique_name='SMS'

*.deferred_segment_creation=FALSE

*.dg_broker_start=TRUE

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=SMSXDB)'

*.fal_client='SMS1'

*.fal_client='SMS2'

*.fal_server='MECBS1','MECBS2'

SMS1.instance_number=1

SMS2.instance_number=2

*.instance_number=1

*.log_archive_config='dg_config=(MECBS,SMS)'

*.log_archive_dest_1='location=+RECO VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=SMS'

*.log_archive_dest_3='SERVICE=MECBS LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=MECBS'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_3='enable'

*.log_archive_format='%t_%s_%r.dbf'

*.log_file_name_convert='+DATA/mecbs','+DATA/sms','+RECO/mecbs','+RECO/sms'

*.open_cursors=300

*.pga_aggregate_target=161480704

*.processes=150

*.remote_listener='scan.cowelldg.com:1521'

*.remote_login_passwordfile='exclusive'

*.service_names='SMS1'

*.sga_target=486539264

*.standby_file_management='AUTO'

SMS2.thread=2

SMS1.thread=1

SMS2.undo_tablespace='UNDOTBS2'

SMS1.undo_tablespace='UNDOTBS1'

SQL> startup mount pfile='/home/oracle/pfile_ok.ora';

ORACLE instance started.

Total System Global Area  484356096 bytes

Fixed Size      2254464 bytes

Variable Size    264243584 bytes

Database Buffers   209715200 bytes

Redo Buffers      8142848 bytes

Database mounted.

SQL> create spfile='+DATA/sms/spifleSMS.ora' from pfile='/home/oracle/pfile_ok.ora';

File created

[oracle@rac1 dbs]$ cat initSMS1.ora

spfile='+DATA/sms/spifleSMS.ora'

[oracle@rac2 dbs]$ cat initSMS2.ora

spfile='+DATA/sms/spifleSMS.ora'

把standby库添加到集群：

[oracle@rac2 dbs]$ srvctl add database -o /u01/app/oracle/product/11.2.0/db_1/ -p "+DATA/sms/spfileSMS.ora" -n MECBS -r physical_standby -s mount

PRKO-2082 : Missing mandatory option -d

[oracle@rac2 dbs]$ srvctl add database -d SMS -o /u01/app/oracle/product/11.2.0/db_1/ -p "+DATA/sms/spfileSMS.ora" -n MECBS -r physical_standby -s mount

PRCS-1007 : Server pool SMS already exists

PRCR-1086 : server pool ora.SMS is already registered

[oracle@rac2 dbs]$ srvctl add instance -d SMS -i SMS1 -n rac1

[oracle@rac2 dbs]$ srvctl add instance -d SMS -i SMS2 -n rac2

[oracle@rac2 dbs]$ srvctl status database -d SMS

Instance SMS1 is not running on node rac1

Instance SMS2 is not running on node rac2

[oracle@rac2 dbs]$ srvctl start database -d SMS

[oracle@rac2 dbs]$ srvctl status database -d SMS

Instance SMS1 is running on node rac1

Instance SMS2 is running on node rac2

ora.sms.db

1        ONLINE  ONLINE       rac1                     Open

2        ONLINE  ONLINE       rac2                     Open

在一个节点开启恢复进程：

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> select open_mode,name,instance_name from gv$database a ,gv$instance b where a.inst_id=b.inst_id;