Oracle DataGuard 一主多备配置

女爷i 2022-06-08 03:59 475阅读 0赞

之前已经写过关于oracle 11g的一主一备的Data Guard的配置，这里就不再赘述，详细请参考：

http://blog.csdn.net/shiyu1157758655/article/details/77973260

这里我们将介绍oracle 一主2备的配置过程(红色部分尤其注意）

Orcle 主库配置：pfile  
cebpm.\_\_db\_cache\_size=47085256704  
cebpm.\_\_java\_pool\_size=29360128  
cebpm.\_\_large\_pool\_size=33554432  
cebpm.\_\_oracle\_base='/u01/app/oracle'\#ORACLE\_BASE set from environment  
cebpm.\_\_pga\_aggregate\_target=34359738368  
cebpm.\_\_sga\_target=51539607552  
cebpm.\_\_shared\_io\_pool\_size=0  
cebpm.\_\_shared\_pool\_size=4093640704  
cebpm.\_\_streams\_pool\_size=8388608  
\*.audit\_file\_dest='/u01/app/oracle/admin/cebpm/adump'  
\*.audit\_trail='db'  
\*.compatible='11.2.0.4.0'  
\*.control\_files='/data1/oradata/cebpm/controlfile/control01.ctl','/data2/oradata/cebpm/controlfile/control02.ctl'  
\*.db\_block\_size=8192  
\*.db\_domain=''  
\*.db\_file\_name\_convert='/data/oradata/cebpmxc/datafile','/data1/oradata/cebpm/datafile','/data/oradata/cebpmxc/datafile','/data2/oradata/cebpm/datafile'  
\*.db\_name='cebpm'  
\*.db\_recovery\_file\_dest\_size=42949672960  
\*.db\_recovery\_file\_dest='/archivelog'  
\*.diagnostic\_dest='/u01/app/oracle'  
\*.dispatchers='(PROTOCOL=TCP) (SERVICE=cebpmXDB)'  
\*.fal\_client='cebpm'  
\*.fal\_server='cebpms,cebpmxc'  
\*.local\_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 132.237.0.202)(PORT = 1550))'  
\*.log\_archive\_config='DG\_CONFIG=(cebpm,cebpms,cebpmxc)'  
\*.log\_archive\_dest\_1='LOCATION=/archivelog/cebpm'

\*.log\_archive\_dest\_2='SERVICE=cebpms VALID\_FOR=(ONLINE\_LOGFILES,PRIMARY\_ROLE) DB\_UNIQUE\_NAME=cebpms'

\*.log\_archive\_dest\_3='SERVICE=cebpmxc VALID\_FOR=(ONLINE\_LOGFILES,PRIMARY\_ROLE) DB\_UNIQUE\_NAME=cebpmxc'  
\*.log\_archive\_dest\_state\_1='enable'

\*.log\_archive\_dest\_state\_2='enable'

\*.log\_archive\_dest\_state\_3='enable'  
\*.log\_archive\_format='%t\_%s\_%r.arc'  
\*.log\_file\_name\_convert='/data/oradata/cebpmxc/redo','/data1/oradata/cebpm/redo'  
\*.memory\_max\_target=214748364800  
\*.memory\_target=214748364800  
\*.open\_cursors=300  
\*.pga\_aggregate\_target=0  
\*.processes=150  
\*.remote\_login\_passwordfile='EXCLUSIVE'  
\*.sga\_max\_size=0  
\*.sga\_target=0  
\*.standby\_file\_management='AUTO'  
\*.undo\_tablespace='UNDOTBS1'

Oracle 备库1配置:pfile

\*.audit\_file\_dest='/u01/app/oracle/admin/cebpms/adump'  
\*.audit\_trail='db'  
\*.compatible='11.2.0.4.0'  
\*.control\_files='/data1/oradata/cebpms/controlfile/control01.ctl','/data2/oradata/cebpms/controlfile/control02.ctl'  
\*.db\_block\_size=8192  
\*.db\_cache\_size=4G  
\*.db\_domain=''  
\*.db\_file\_name\_convert='/data1/oradata/cebpm/datafile','/data1/oradata/cebpms/datafile','/data2/oradata/cebpm/datafile','/data2/oradata/cebpms/datafile','/data1/oradata/cebpm/tempfile','/data1/oradata/cebpms/tempfile'  
\*.db\_files=8192  
\*.db\_name='cebpm'  
\*.db\_recovery\_file\_dest\_size=42949672960  
\*.db\_recovery\_file\_dest='/data1/oradata/cebpms/flashback'  
\*.db\_unique\_name='cebpms'  
\*.db\_writer\_processes=16  
\*.diagnostic\_dest='/u01/app/oracle'  
\*.dispatchers='(PROTOCOL=TCP) (SERVICE=cebpmsXDB)'  
\*.fal\_client='cebpms'  
\*.fal\_server='cebpm'  
\*.job\_queue\_processes=50  
\*.large\_pool\_size=2G  
\*.local\_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 132.237.0.205)(PORT = 1550))'  
\*.log\_archive\_config='DG\_CONFIG=(cebpm,cebpms,cebpmxc)'  
\*.log\_archive\_dest\_1='LOCATION=/data1/oradata/cebpms/archivelog'  
\*.log\_archive\_dest\_2='SERVICE=cebpm VALID\_FOR=(ONLINE\_LOGFILES,PRIMARY\_ROLE) DB\_UNIQUE\_NAME=cebpm'  
\*.log\_archive\_dest\_state\_1='enable'  
\*.log\_archive\_dest\_state\_2='enable'  
\*.log\_archive\_dest\_state\_3='enable'  
\*.log\_archive\_format='%t\_%s\_%r.arc'  
\*.log\_buffer=268435456  
\*.log\_file\_name\_convert='/data1/oradata/cebpm/redo','/data1/oradata/cebpms/redo','/data2/oradata/cebpm/redo','/data2/oradata/cebpms/redo'  
\*.open\_cursors=1000  
\*.optimizer\_mode='choose'  
\*.pga\_aggregate\_target=6742343680  
\*.processes=4000  
\*.remote\_login\_passwordfile='EXCLUSIVE'  
\*.session\_cached\_cursors=200  
\*.sga\_max\_size=20229128192  
\*.sga\_target=20229128192  
\*.standby\_file\_management='AUTO'  
\*.undo\_retention=108000  
\*.undo\_tablespace='UNDOTBS1'

Oracle 备库2配置:pfile

\*.audit\_file\_dest='/ybs/app/oracle/admin/cebpmxc/adump'  
\*.audit\_trail='db'  
\*.compatible='11.2.0.4.0'  
\*.control\_files='/data/oradata/cebpmxc/controlfile/control01.ctl','/data/oradata/cebpmxc/controlfile/control02.ctl'  
\*.db\_block\_size=8192  
\*.db\_domain=''  
\*.db\_file\_name\_convert='/data1/oradata/cebpm/datafile','/data/oradata/cebpmxc/datafile','/data2/oradata/cebpm/datafile','/data/oradata/cebpmxc/datafile','/data1/oradata/cebpm/tempfile','/data/oradata/cebpmxc/datafile'  
\*.db\_name='cebpm'  
\*.db\_recovery\_file\_dest='/data/oradata/cebpmxc/flashback'  
\*.db\_recovery\_file\_dest\_size=42949672960  
\*.db\_unique\_name='cebpmxc'  
\*.diagnostic\_dest='/ybs/app/oracle'  
\*.dispatchers='(PROTOCOL=TCP) (SERVICE=cebpmxcXDB)'  
\*.fal\_client='cebpmxc'  
\*.fal\_server='cebpm'  
\*.log\_archive\_config='DG\_CONFIG=(cebpmxc,cebpm,cebpms)'  
\*.log\_archive\_dest\_1='LOCATION=/data/oradata/cebpmxc/archivelog'  
\*.log\_archive\_dest\_3='SERVICE=cebpm VALID\_FOR=(ONLINE\_LOGFILES,PRIMARY\_ROLE) DB\_UNIQUE\_NAME=cebpm'  
\*.log\_archive\_dest\_state\_1='enable'  
\*.log\_archive\_dest\_state\_2='enable'  
\*.log\_archive\_format='%t\_%s\_%r.arc'  
\*.log\_file\_name\_convert='/data1/oradata/cebpm/redo','/data/oradata/cebpmxc/redo','/data2/oradata/cebpm/redo','/data/oradata/cebpmxc/redo'  
\*.open\_cursors=300  
\*.pga\_aggregate\_target=6742343680  
\*.processes=150  
\*.remote\_login\_passwordfile='EXCLUSIVE'  
\*.sga\_target=20229128192  
\*.standby\_file\_management='AUTO'  
\*.undo\_tablespace='UNDOTBS1'