系统环境：
操作系统： 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，如需转载请自行联系原作者
