Oracle11g平臺異構之LinuxToWindowsDataGuard安裝配置

1、Oraclellg平臺異構之LinuxToWindowsDataGuar姣裝配置1、環(huán)境介紹1.1、 主庫操作系統(tǒng)：RedHatEnterpriseLinux5.464bitIP地址：31數(shù)據庫版本：oracle64bit數(shù)據庫sid名：demo1數(shù)據庫名：demo1數(shù)據庫db_unique_namedemo231數(shù)據文件路徑：/oradata/demo1歸檔路徑：/oracle/arch1.2、 備庫操作系統(tǒng)：windowsserver200364bitIP地址：33數(shù)據庫版本：oracle數(shù)據庫sid名：dem

2、o1數(shù)據庫名：demo1數(shù)據庫db_unique_name:demo233數(shù)據文件路徑：c:oradatademo1歸檔路徑：c:oraclearch2、DG配置準備2.1、 主庫安裝oracle數(shù)據庫軟件并創(chuàng)建數(shù)據庫實例安裝oracle數(shù)據庫軟件（略）創(chuàng)建數(shù)據庫實例（略）創(chuàng)建監(jiān)聽（略）2.2、 備庫安裝oracle數(shù)據庫軟件安裝oracle數(shù)據庫軟件（略）創(chuàng)建數(shù)據庫實例，停止實例后刪除數(shù)據文件（如果不建實例，不能以sysdba連接），報錯如下創(chuàng)建監(jiān)聽（略）3、DG配置3.1、 將主庫設置為歸檔模式3.2、 設置主庫為強制歸檔模式SQL>alterdata

3、baseforcelogging;3.3、 主庫監(jiān)聽配置listener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=demo1)(ORACLE_HOME=/oracle/product/11.2.0/db_1)(SID_NAME=demo1)(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=/oracle/product/11.2.0/db_1)(PROGRAM=extproc)LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTO

4、COL=TCP)(HOST=dg231)(PORT=1521)(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)tnsnames.oraDEMO231=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=31)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=demo1)DEMO233=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=33)(PORT=1521)(CO

5、NNECT_DATA=(SERVICE_NAME=demo1)3.4、 備庫監(jiān)聽配置listener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=demo1)(ORACLE_HOME=C:oracleproduct/db_1)(SID_NAME=demo1)(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=C:oracleproduct/db_1)(PROGRAM=extproc)LISTENER=(DESCRIPTION_LIST=(DESCRIPTION

6、=(ADDRESS=(PROTOCOL=TCP)(HOST=ygdg)(PORT=1521)(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)tnsnames.oraDEMO231=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=31)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=demo1)DEMO233=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ygdg)(PORT=1521)(CONNECT_DAT

7、A=(SERVER=DEDICATED)(SERVICE_NAME=demo1)3.5、 主庫初始化參數(shù)修改生成pfile文件(createpfilefromspfile)修改生成的pfile文件，添加如下紅色部分內容demo1._db_cache_size=205520896demo1._ava_pool_size=4194304demo1._large_pool_size=4194304demo1._oracle_base='/oracle'#ORACLE_BASEsetfromenvironmentdemo1._pga_aggregate_target=218103808

8、demo1._sga_target=327155712demo1._shared_io_pool_size=0demo1._shared_pool_size=104857600demo1._streams_pool_size=0*.audit_file_dest='/oracle/admin/demo1/adump'*.audit_trail='db'*.compatible='.0'*.control_files='/oradata/demo1/control01.ctl','/oradata/demo1

9、/control02.ctl'*.db_block_size=8192*.db_domain=''*.db_name='demo1'*.diagnostic_dest='/oracle'*.dispatchers='(PROTOCOL=TCP)(SERVICE=demo1XDB)'*.log_archive_dest_1='LOCATION=/oracle/arch'*.log_archive_format='%t_%s_%r.dbf*.memory_target=545259520*.open_c

10、ursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.undo_tablespace='UNDOTBS1'*.db_unique_name=demo231*.log_archive_config='dg_config=(demo231,demo233)'*.log_archive_dest_1='location=/oracle/archVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=demo231'*.

11、log_archive_dest_2='SERVICE=demo233LGWRASYNCVALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)DB_UNIQUE_NAME=demo233'*.fal_server=demo233*.fal_client=demo231*.log_archive_dest_state_1=ENABLE*.log_archive_dest_state_2=ENABLE*.log_archive_max_processes=10*.standby_file_management=AUTO*.db_file_name_conve

12、rt='C:oradatademo1','/oradata/demo1'*.log_file_name_convert='C:oradatademo1',7oradata/demoT由pfile文件生成spfileSQL>shutdownimmediateSQL>createspfilefrompfile;SQL>startup3.6、 備庫初始化參數(shù)修改將主庫生成的pfile文件傳到備庫，修改如下紅色部分內容demo1._db_cache_size=205520896demo1._ava_pool_size=4194304de

13、mo1._large_pool_size=4194304demo1._oracle_base='C:oracle'#ORACLE_BASEsetfromenvironmentdemo1._pga_aggregate_target=218103808demo1._sga_target=327155712demol._shared_io_pool_size=0demol._shared_pool_size=104857600demol._streams_pool_size=0*.audit_file_dest='C:oracleadmindemo1adump'*.a

14、udit_trail='db'*.compatible='.0'*.control_files='C:oradatademo1control01.ctl','C:oradatademo1control02.ctl'*.db_block_size=8192*.db_domain=''*.db_name='demo1'*.diagnostic_dest='C:oracle'*.dispatchers='(PROTOCOL=TCP)(SERVICE=demo1XDB

15、)'*.log_archive_dest_1='LOCATION=C:oraclearch'*.log_archive_format='%t_%s_%r.dbf'*.memory_target=545259520*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*undo_tablespace='UNDOTBS1'*.db_unique_name=demo233*.log_archive_config='dg_config

16、=(demo233,demo231)'*.log_archive_dest_1='location=C:oraclearchVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=demo233'*.log_archive_dest_2='SERVICE=demo231LGWRASYNCVALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)DB_UNIQUE_NAME=demo231'*.fal_server=demo231*.fal_client=demo233*.log_archive

17、_dest_state_1=ENABLE*.log_archive_dest_state_2=ENABLE*.log_archive_max_processes=10*.standby_file_management=AUTO*.db_file_name_convert=7oradata/demo1','C:oradatademoT*log_file_name_convert=7oradata/demo1','C:oradatademo性成備庫spfile文件SQL>createspfilefrompfile="c:oracleinitdemo1

18、.ora'將備庫啟動到nomount狀態(tài)SQL>startupnomount3.7、 添加standby日志組SQL>alterdatabaseaddstandbylogfilegroup4>(/oradata/demo1/redo04.log)size50MSQL>alterdatabaseaddstandbylogfilegroup5>('/oradatdemo1/redo05.log')s0M;5SQL>alterdatabaseaddstandbylogfilegroup6>('/oradatdemo1/redo

19、06.log')§0M;SQL>alterdatabaseaddstandbylogfilegroup7>(/oradata/demo1/redo07.log)size50M;3.8、 在主庫上使用rman進行duplicate操作$rmantargetsys/oracleauxiliarysys/oracledemo233RMAN>DUPLICATETARGETDATABASEFORSTANDBYFROMACTIVEDATABASENOFILENAMECHECK;RMAN復完以后會自動將standby數(shù)據庫自動切換到mount狀態(tài)。3.9、 將備庫置于ADG模式下SQL>alterdatabaseopenreadonly;SQL>alterdatabaserecovermanagedstandbydatabaseusingcurrentlogfiledisconnectfromsession;3.10、 數(shù)據同步測試在主庫上以scott用戶執(zhí)行SQL>createtableemp_testasselect*fromemp;SQL>commit;在備