本文共 5973 字，大约阅读时间需要 19 分钟。
系统环境：
操作系统： 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》