這裡展示的是透過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 --

【DataGuard】使用GC建立的物理DataGuard主備庫pfile比較

相關文章