论坛 › Oracle › oracle之DG搭建

scb0814 发表于 2011-12-22 08:54

oracle之DG搭建

<DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: calibri; mso-bidi-theme-font: minor-latin"><SPAN style="mso-list: ignore"><FONT face=Calibri size=3>1、</FONT><SPAN Times New Roman??>&nbsp; </SPAN></SPAN></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin"><FONT size=3>测试环境</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><FONT size=3><SPAN lang=EN-US><FONT face=Calibri>ORACLE</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">主库</SPAN><SPAN lang=EN-US><FONT face=Calibri>IP</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">：</SPAN><SPAN lang=EN-US><FONT face=Calibri>10.1.1.14<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>SID:YEYEAI</FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><FONT size=3><SPAN lang=EN-US><FONT face=Calibri>ORACLE </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">从库</SPAN><SPAN lang=EN-US><FONT face=Calibri>IP</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">：</SPAN><SPAN lang=EN-US><FONT face=Calibri>10.1.1.25<SPAN style="mso-spacerun: yes">&nbsp; </SPAN>SID:STANDBY</FONT></SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: calibri; mso-bidi-theme-font: minor-latin"><SPAN style="mso-list: ignore"><FONT face=Calibri size=3>2、</FONT><SPAN Times New Roman??>&nbsp; </SPAN></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">修改主库参数文件为：</SPAN><SPAN lang=EN-US><FONT face=Calibri>fuck.ora </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">（红色为修改的部分）</SPAN></FONT></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 15.75pt; mso-char-indent-count: 1.5"><SPAN lang=EN-US><FONT face=Calibri size=3>YEYEAI.__db_cache_size=88080384</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>YEYEAI.__java_pool_size=4194304</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>YEYEAI.__large_pool_size=4194304</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>YEYEAI.__shared_pool_size=67108864</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>YEYEAI.__streams_pool_size=0</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.audit_file_dest='/oracle/app/admin/YEYEAI/adump'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.background_dump_dest='/oracle/app/admin/YEYEAI/bdump'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.compatible='10.2.0.1.0'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.control_files='/oracle/app/oradata/YEYEAI/control01.ctl','/oracle/app/oradata/YEYEAI/control02.ctl','/oracle/app/oradata/YEYEAI/co</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>ntrol03.ctl'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.core_dump_dest='/oracle/app/admin/YEYEAI/cdump'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_block_size=8192</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_name='YEYEAI'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_domain=''</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_file_multiblock_read_count=16</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_recovery_file_dest='/oracle/app/flash_recovery_area'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_recovery_file_dest_size=2147483648</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.dispatchers='(PROTOCOL=TCP) (SERVICE=YEYEAIXDB)'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.job_queue_processes=10</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.open_cursors=300</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.pga_aggregate_target=16777216</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.processes=150</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.remote_login_passwordfile='EXCLUSIVE'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.sga_target=167772160</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.undo_management='AUTO'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.undo_tablespace='UNDOTBS1'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.user_dump_dest='/oracle/app/admin/YEYEAI/udump'</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>STANDBY_ARCHIVE_DEST='/oracle/app/flash_recovery_area/YEYEAI/archivelog'</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>db_unique_name='yeyeai'</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_ARCHIVE_CONFIG='DG_CONFIG=(yeyeai,standby)'</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/flash_recovery_area/YEYEAI/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=YEYEAI'</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_ARCHIVE_DEST_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>FAL_SERVER=standby</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>FAL_CLIENT=yeyeai</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>DB_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>STANDBY_FILE_MANAGEMENT=AUTO</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: calibri; mso-bidi-theme-font: minor-latin"><SPAN style="mso-list: ignore"><FONT face=Calibri size=3>3、</FONT><SPAN Times New Roman??>&nbsp; </SPAN></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">修改从库的配置文件为：</SPAN><SPAN lang=EN-US><FONT face=Calibri>fuck.ora</FONT></SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.audit_file_dest='/oracle/app/admin/STANDBY/adump'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.background_dump_dest='/oracle/app/admin/STANDBY/bdump'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.compatible='10.2.0.1.0'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.control_files='/oracle/oradata/STANDBY/control01.ctl','/oracle/oradata/STANDBY/control02.ctl','/oracle/oradata/STANDBY/control03.ctl'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.core_dump_dest='/oracle/app/admin/STANDBY/cdump'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_16k_cache_size=16777216</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_block_size=8192</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_domain=''</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_file_multiblock_read_count=16</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_recovery_file_dest='/oracle/app/flash_recovery_area'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_recovery_file_dest_size=2147483648</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.dispatchers='(PROTOCOL=TCP) (SERVICE=STANDBYXDB)'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.job_queue_processes=10</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.open_cursors=300</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.pga_aggregate_target=16777216</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.processes=150</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.remote_login_passwordfile='EXCLUSIVE'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.sga_target=167772160</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.undo_management='AUTO'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.db_name='YEYEAI'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.undo_tablespace='UNDOTBS2'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>*.user_dump_dest='/oracle/app/admin/STANDBY/udump'</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>DB_UNIQUE_NAME='YEYEAI'</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_ARCHIVE_CONFIG='DG_CONFIG=(yeyeai,standby)'</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>DB_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/flash_recovery_area/YEYEAI/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby'</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>LOG_ARCHIVE_DEST_2='SERVICE=yeyeai LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=YEYEAI'</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT face=Calibri size=3>FAL_SERVER=yeyeai</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>FAL_CLIENT=standby</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: 0cm; mso-char-indent-count: 0"><SPAN lang=EN-US style="COLOR: red"><FONT size=3><FONT face=Calibri>STANDBY_FILE_MANAGEMENT=AUTO</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: calibri; mso-bidi-theme-font: minor-latin"><SPAN style="mso-list: ignore"><FONT face=Calibri size=3>4、</FONT><SPAN Times New Roman??>&nbsp; </SPAN></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">修改主库的</SPAN><SPAN lang=EN-US><FONT face=Calibri>listener.ora</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">文件</SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>SID_LIST_LISTENER =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(SID_LIST =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(SID_DESC =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(GLOBAL_DBNAME = <SPAN style="COLOR: red">YEYEAI</SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SID_NAME = <SPAN style="COLOR: red">YEYEAI</SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>&nbsp;</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>LISTENER =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(DESCRIPTION =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST = <SPAN style="COLOR: red">10.1.1.14</SPAN>)(PORT = 1521))</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: 0cm; mso-char-indent-count: 0"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: calibri; mso-bidi-theme-font: minor-latin"><SPAN style="mso-list: ignore"><FONT face=Calibri size=3>5、</FONT><SPAN Times New Roman??>&nbsp; </SPAN></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">修改主库的</SPAN><SPAN lang=EN-US><FONT face=Calibri>tnsnames.ora</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">文件</SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>YEYEAI =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(DESCRIPTION =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST =10.1.1.14)(PORT = 1521))</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(CONNECT_DATA =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SERVER = DEDICATED)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SERVICE_NAME = YEYEAI)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>STANDBY =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(DESCRIPTION =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST =<SPAN style="COLOR: red">10.1.1.25</SPAN>)(PORT = 1521))</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(CONNECT_DATA =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SERVER = DEDICATED)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SERVICE_NAME = <SPAN style="COLOR: red">standby</SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>&nbsp;</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>ORCL =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(DESCRIPTION =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(CONNECT_DATA =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SERVER = DEDICATED)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SERVICE_NAME = orcl)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>&nbsp;</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>EXTPROC_CONNECTION_DATA =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(DESCRIPTION =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS_LIST =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(CONNECT_DATA =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SID = PL***tProc)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(PRESENTATION = RO)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: 0cm; mso-char-indent-count: 0"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: calibri; mso-bidi-theme-font: minor-latin"><SPAN style="mso-list: ignore"><FONT face=Calibri size=3>6、</FONT><SPAN Times New Roman??>&nbsp; </SPAN></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">修改从库的</SPAN><SPAN lang=EN-US><FONT face=Calibri>listener.ora</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">文件</SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>SID_LIST_LISTENER =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(SID_LIST =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(SID_DESC =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(GLOBAL_DBNAME = <SPAN style="COLOR: red">STANDBY</SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SID_NAME =<SPAN style="COLOR: red"> STANDBY</SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>&nbsp;</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face=Calibri size=3>LISTENER =</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(DESCRIPTION =</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST = <SPAN style="COLOR: red">10.1.1.25</SPAN>)(PORT = 1521))</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: 0cm; mso-char-indent-count: 0"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: calibri; mso-bidi-theme-font: minor-latin"><SPAN style="mso-list: ignore"><FONT face=Calibri size=3>7、</FONT><SPAN Times New Roman??>&nbsp; </SPAN></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">修改从库的</SPAN><SPAN lang=EN-US><FONT face=Calibri>tnsnames.ora</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-ascii-font-family: calibri; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: calibri; mso-hansi-theme-font: minor-latin">文件</SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: 0cm; mso-char-indent-count: 0"><SPAN lang=EN-US><FONT face=Calibri size=3>&nbsp;</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><FONT face=Calibri><SPAN lang=EN-US style="COLOR: red">yeyeai</SPAN><SPAN lang=EN-US> =</SPAN></FONT></FONT></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>(DESCRIPTION =</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS_LIST =</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST = <SPAN style="COLOR: red">10.1.1.14</SPAN>)(PORT = 1521))</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>(CONNECT_DATA =</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>(SERVICE_NAME = <SPAN style="COLOR: red">YEYEAI</SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face=Calibri><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face=Calibri><FONT size=3><SPAN style="mso-spacerun: yes">&nbsp; </SPAN>)</FONT></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-char-indent-count: 0; mso-list: l0 level1 lfo1"><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-bidi-font-family: 宋体; mso-bidi-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: ignore"><FONT size=3>8、</FONT><SPAN Times New Roman??> </SPAN></SPAN></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>主库和从库都启动监听：<SPAN lang=EN-US>lsnrctl start</SPAN></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">9</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">、设置服务器为归档模式<SPAN lang=EN-US></SPAN></SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>alter database archivelog</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 15.75pt; mso-char-indent-count: 1.5"><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>设置主数据库为日志强制写状态<SPAN lang=EN-US></SPAN></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>alter database force logging;</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>查看状态日志强制写状态为<SPAN lang=EN-US>YES</SPAN></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>select t.FORCE_LOGGING from v$database t</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">10</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">．主库的数据用<SPAN lang=EN-US>RMAN</SPAN>进行全备份：<SPAN lang=EN-US></SPAN></SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 4.5pt; TEXT-ALIGN: left; mso-para-margin-left: .43gd" align=left><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3><SPAN style="mso-spacerun: yes">&nbsp;</SPAN><SPAN style="mso-bidi-font-weight: bold">RMAN &gt; connect target / </SPAN></FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 4.5pt; TEXT-ALIGN: left; mso-para-margin-left: .43gd" align=left><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold"><FONT size=3>RMAN &gt;backup full database include current controlfile for standby;</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">11</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">．备份后将备份集传到从库（<SPAN style="COLOR: red">注意备份集的路径要相同</SPAN>）<SPAN lang=EN-US></SPAN></SPAN></FONT></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>主库：<SPAN lang=EN-US></SPAN></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><SPAN style="mso-spacerun: yes"><FONT size=3>&nbsp;&nbsp;&nbsp; </FONT></SPAN><SPAN style="mso-no-proof: yes"><FONT size=3></FONT></SPAN></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>从库：<SPAN lang=EN-US></SPAN></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-no-proof: yes"><FONT size=3></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">12</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">．在主库执行<SPAN lang=EN-US>RMAN</SPAN>恢复备库数据：<SPAN lang=EN-US></SPAN></SPAN></FONT></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 21pt; TEXT-INDENT: 0cm; TEXT-ALIGN: left; mso-char-indent-count: 0" align=left><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold"><FONT size=3>RMAN &gt; connect auxiliary sys/aiyeye@slave</FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 21pt; TEXT-INDENT: 0cm; TEXT-ALIGN: left; mso-char-indent-count: 0" align=left><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold"><FONT size=3>RMAN &gt; duplicate target database for standby nofilenamecheck; </FONT></SPAN></DIV>
<DIV class=MsoListParagraph style="MARGIN: 0cm 0cm 0pt 21pt; TEXT-INDENT: 0cm; TEXT-ALIGN: left; mso-char-indent-count: 0" align=left><SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: " YaHei Consolas Hybrid?,?sans-serif?; mso-ascii-font-family: mso-hansi-font-family: Consolas; mso-bidi-font-weight: bold?><FONT face=Tahoma>完毕后从库回自动到</FONT></SPAN><SPAN lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: consolas; mso-fareast-font-family: " YaHei Consolas mso-bidi-font-weight: bold? Hybrid?;>mount</SPAN><FONT face=Tahoma><SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: " YaHei Consolas Hybrid?,?sans-serif?; mso-ascii-font-family: mso-hansi-font-family: Consolas; mso-bidi-font-weight: bold?>状态</SPAN><SPAN lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: consolas; mso-fareast-font-family: " YaHei Consolas mso-bidi-font-weight: bold? Hybrid?;></SPAN></FONT></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left" align=left><SPAN lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: consolas; mso-fareast-font-family: " YaHei Consolas mso-bidi-font-weight: bold? Hybrid?;>13</SPAN><FONT face=Tahoma><SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: " YaHei Consolas Hybrid?,?sans-serif?; mso-ascii-font-family: mso-hansi-font-family: Consolas; mso-bidi-font-weight: bold?>．在从库执行自动恢复状态</SPAN><SPAN lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: consolas; mso-fareast-font-family: " YaHei Consolas mso-bidi-font-weight: bold? Hybrid?;></SPAN></FONT></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; TEXT-ALIGN: left; mso-char-indent-count: 2.0" align=left><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>alter database recover managed standby database disconnect from session;</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left" align=left><FONT size=3><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">14</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt">．主库执行：<SPAN lang=EN-US></SPAN></SPAN></FONT></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left" align=left><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3><SPAN style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN>select process from v$managed_standby;</FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; TEXT-ALIGN: left; mso-char-indent-count: 2.0" align=left><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold"><FONT size=3>查看进程，看有没有<SPAN lang=EN-US>LNS</SPAN>进程，如果没有<SPAN lang=EN-US></SPAN></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; TEXT-ALIGN: left; mso-char-indent-count: 2.0" align=left><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-no-proof: yes"><FONT size=3></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left" align=left><SPAN lang=EN-US style="FONT-SIZE: 9pt; FONT-FAMILY: consolas; mso-fareast-font-family: " YaHei Consolas mso-bidi-font-weight: bold? Hybrid?;>&nbsp;</SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left" align=left><SPAN style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold"><FONT size=3>测试数据库同步成功<SPAN lang=EN-US></SPAN></FONT></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-fareast-theme-font: major-fareast; mso-ascii-theme-font: major-fareast; mso-hansi-theme-font: major-fareast; mso-bidi-font-size: 10.5pt"><FONT size=3>&nbsp;</FONT></SPAN></DIV></DIV>

查看完整版本: oracle之DG搭建