Oracle DG之--构建Physical Standby（一主库对应多备库）

134564

系统环境：

操作系统： RedHat EL6

Oracle:    Oracle 10.2.0.1.0

      如图所示，主库为bjdb（db_unique_name)，备库为shdb和gzdb。

案例分析：
一个主库，两个备库
主库初始化参数（pfile）：
[oracle@bjsrv dbs]$ cat initbj.ora

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

*.audit_file_dest='/u01/app/oracle/admin/prod/adump' *.background_dump_dest='/u01/app/oracle/admin/prod/bdump' *.compatible='10.2.0.1.0' *.control_files='/u01/app/oracle/oradata/prod/control01.ctl','/disk1/oradata/bj/control02.ctl','/disk2/oradata/bj/control03.ctl' *.core_dump_dest='/u01/app/oracle/admin/prod/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sh','/u01/app/oracle/oradata/prod','/u01/app/oracle/oradata/gz','/u01/app/oracle/oradata/prod' *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.instance_name='bj' *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/oracle/admin/prod/udump'

以下参数用于DG配置：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

*.db_name='prod' *.DB_UNIQUE_NAME='bjdb' *.FAL_CLIENT='bjdb' *.FAL_SERVER='shdb','gzdb' *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(bjdb,shdb,gzdb)' *.LOG_ARCHIVE_DEST_1='LOCATION=/disk3/arch_bj   VALID_FOR=(ALL_LOGFILES,ALL_ROLES)   DB_UNIQUE_NAME=bjdb'     *.LOG_ARCHIVE_DEST_2='SERVICE=shdb LGWR ASYNC   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=shdb'     *.LOG_ARCHIVE_DEST_3='SERVICE=gzdb LGWR ASYNC   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=gzdb'     *.LOG_ARCHIVE_DEST_STATE_1='ENABLE' *.LOG_ARCHIVE_DEST_STATE_2='ENABLE' *.LOG_ARCHIVE_DEST_STATE_3='ENABLE' *.log_archive_format='arch_%t_%s_%r.log' *.LOG_ARCHIVE_MAX_PROCESSES=3 *.LOG_FILE_NAME_CONVERT='/disk1/oradata/sh','/disk1/oradata/bj','/disk2/oradata/sh','/disk2/oradata/bj','/disk1/oradata/gz','/disk1/oradata/bj','/disk2/oradata/gz','/disk2/oradata/bj' *.STANDBY_FILE_MANAGEMENT='AUTO'

备库初始化参数pfile（shdb）：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

[oracle@shsrv dbs]$ cat initsh.ora *.audit_file_dest='/u01/app/oracle/admin/sh/adump' *.background_dump_dest='/u01/app/oracle/admin/sh/bdump' *.compatible='10.2.0.1.0' *.control_files='/u01/app/oracle/oradata/sh/std_control.ctl' *.core_dump_dest='/u01/app/oracle/admin/sh/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/prod','/u01/app/oracle/oradata/sh','/u01/app/oracle/gz','/u01/app/oracle/oradata/sh' *.instance_name='sh' *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/oracle/admin/sh/udump'

以下参数用于DG配置：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

*.db_name='prod' *.DB_UNIQUE_NAME='shdb' *.FAL_CLIENT='shdb' *.FAL_SERVER='bjdb','gzdb' *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(bjdb,shdb,gzdb)' *.LOG_ARCHIVE_DEST_1='LOCATION=/disk3/arch_sh   VALID_FOR=(ALL_LOGFILES,ALL_ROLES)   DB_UNIQUE_NAME=shdb'     *.LOG_ARCHIVE_DEST_2='SERVICE=bjdb LGWR ASYNC   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=bjdb'     *.LOG_ARCHIVE_DEST_3='SERVICE=gzdb LGWR ASYNC   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=gzdb'     *.LOG_ARCHIVE_DEST_STATE_1='ENABLE' *.LOG_ARCHIVE_DEST_STATE_2='ENABLE' *.LOG_ARCHIVE_DEST_STATE_3='ENABLE' *.log_archive_format='arch_%t_%s_%r.log' *.LOG_ARCHIVE_MAX_PROCESSES=3 *.LOG_FILE_NAME_CONVERT='/disk1/oradata/bj','/disk1/oradata/sh','/disk2/oradata/bj','/disk2/oradata/sh','/disk1/oradata/gz','/disk1/oradata/sh','/disk2/oradata/gz','/disk2/oradata/sh' *.STANDBY_FILE_MANAGEMENT='AUTO'

备库初始化参数pfile（gzdb）：
[oracle@gzsrv dbs]$ cat initgz.ora

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

*.audit_file_dest='/u01/app/oracle/admin/gz/adump' *.background_dump_dest='/u01/app/oracle/admin/gz/bdump' *.compatible='10.2.0.1.0' *.control_files='/u01/app/oracle/oradata/gz/gzstd_control.ctl' *.core_dump_dest='/u01/app/oracle/admin/gz/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/prod','/u01/app/oracle/oradata/gz','/u01/app/oracle/oradata/sh','/u01/app/oracle/oradata/gz' *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/oracle/admin/gz/udump' *.job_queue_processes=10

以下参数用于DG配置：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

*.db_name='prod' *.DB_UNIQUE_NAME='gzdb' *.FAL_CLIENT='gzdb' *.FAL_SERVER='bjdb','shdb' *.instance_name='gz' *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(bjdb,shdb,gzdb)' *.LOG_ARCHIVE_DEST_1='LOCATION=/disk3/arch_gz   VALID_FOR=(ALL_LOGFILES,ALL_ROLES)   DB_UNIQUE_NAME=gzdb'     *.LOG_ARCHIVE_DEST_2='SERVICE=bjdb LGWR ASYNC   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=bjdb'     *.LOG_ARCHIVE_DEST_3='SERVICE=shdb LGWR ASYNC   VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=shdb'     *.LOG_ARCHIVE_DEST_STATE_1='ENABLE' *.LOG_ARCHIVE_DEST_STATE_2='ENABLE' *.LOG_ARCHIVE_DEST_STATE_3='ENABLE' *.log_archive_format='arch_%t_%s_%r.log' *.LOG_ARCHIVE_MAX_PROCESSES=3 *.LOG_FILE_NAME_CONVERT='/disk1/oradata/bj','/disk1/oradata/gz','/disk2/oradata/bj','/disk2/oradata/gz','/disk1/oradata/sh','/disk1/oradata/gz','/disk2/oradata/sh','/disk2/oradata/gz' *.STANDBY_FILE_MANAGEMENT='AUTO'

---以上为构建一个主库2个Physical Standby的初始化参数，创建过程省略