这里展示的是通过Grid Control创建Data Guard的pfile和主库pfile的文件内容比较。
通过这个文件比较可以很方便的看到Grid Control在后台自动完成的调整内容。

[oracle@secdb1 dbs]$ diff initsecdb.ora initsecdg.ora
1,5c1,6
< secdb.__db_cache_size=205520896
< secdb.__java_pool_size=4194304
< secdb.__large_pool_size=4194304
< secdb.__shared_pool_size=96468992
< secdb.__streams_pool_size=0
---
> secdg.__db_cache_size=213909504
> secdg.__java_pool_size=4194304
> secdg.__large_pool_size=4194304
> secdg.__shared_pool_size=88080384
> secdg.__streams_pool_size=0
> *._log_deletion_policy='all'
7,11c8,11
< *.control_files='/u01/app/oracle/oradata/secdb/ora_control1.ctl','/u01/app/oracle/oradata/secdb/ora_control2.ctl','/u01/app/oracle/oradata/secdb/ora_control3.ctl'
< *.db_create_file_dest='/u01/app/oracle/oradata/secdb'
< *.db_create_online_log_dest_1='/u01/app/oracle/oradata/secdb'
< *.db_file_multiblock_read_count=8# SMALL
< *.db_files=80# SMALL
---
> *.control_files='/u01/app/oracle/oradata/SECDG/controlfile/o1_mf_661zgvkt_.ctl','/u01/app/oracle/flash_recovery_area/SECDG/controlfile/o1_mf_661zgvt2_.ctl'
> *.db_create_file_dest='/u01/app/oracle/oradata'
> *.db_file_multiblock_read_count=8
> *.db_files=80
13c13,18
< *.dg_broker_start=TRUE
---
> *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
> *.db_recovery_file_dest_size=2521M
> *.db_unique_name='secdg'
> *.dg_broker_start=true
> *.fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=secdg_XPT)(INSTANCE_NAME=secdg)(SERVER=dedicated)))'
> *.fal_server='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=secdb_XPT)(SERVER=dedicated)))'
16,23c21,25
< *.log_archive_config='dg_config=(secdg)'
< *.log_archive_dest=''
< *.log_archive_dest_1='location=dgarc1 mandatory valid_for=(online_logfile,all_roles)'
< *.log_archive_dest_2='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=secdb1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=secdg_XPT)(INSTANCE_NAME=secdg)(SERVER=dedicated)))"',' ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="secdg" register net_timeout=180 valid_for=(online_logfile,primary_role)'
< *.log_archive_dest_state_1='ENABLE'
< *.log_archive_dest_state_2='ENABLE'
< *.log_archive_duplex_dest=''
< secdb.log_archive_format='%t_%s_%r.dbf'
---
> *.log_archive_config='dg_config=(secdb)'
> *.log_archive_dest_1='LOCATION=use_db_recovery_file_dest','valid_for=(ALL_ROLES,ONLINE_LOGFILE)'
> *.log_archive_dest_2='LOCATION=use_db_recovery_file_dest','valid_for=(STANDBY_ROLE,STANDBY_LOGFILE)'
> *.log_archive_format='%t_%s_%r.dbf'
> secdg.log_archive_format='%t_%s_%r.dbf'
26,27c28,29
< secdb.log_archive_trace=0
< *.log_buffer=32768# SMALL
---
> secdg.log_archive_trace=0
> *.log_buffer=2927616
29,35c31,38
< *.max_dump_file_size='10240'# limit trace file size to 5 Meg each
< *.parallel_max_servers=5# SMALL
< *.processes=200# SMALL
< *.sga_max_size=300m
< *.sga_target=300m
< secdb.standby_archive_dest=''
< *.standby_file_management='AUTO'
---
> *.max_dump_file_size='10240'
> *.parallel_max_servers=5
> *.processes=200
> *.remote_login_passwordfile='exclusive'
> *.sga_max_size=314572800
> *.sga_target=314572800
> secdg.standby_archive_dest=''
> *.standby_file_management='MANUAL'

从这份比较文件中你能得到哪些有效的信息？

注意，此时standby_file_management这个参数为MANUAL，同时没有convert相关的参数。因此会出现添加数据文件后在备库中无法自动添加的问题。关于这个问题请参考《【DataGuard】由于备库参数设置不当导致数据文件无法添加的故障分析》（http://space.itpub.net/519536/viewspace-670703）。

Good luck.

secooler
10.09.05

-- The End --

ITPub博客

【DataGuard】使用GC创建的物理DataGuard主备库pfile比较

最新文章