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

系统环境：

操作系统： 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的初始化参数，创建过程省略，可以参考：http://tiany.blog.51cto.com/513694/1583444《 Oracle DG之--构建Physical Standby》

本文转自 客居天涯 51CTO博客，原文链接：http://blog.51cto.com/tiany/1583399，如需转载请自行联系原作者