ITPub博客

11g 两个节点RAC 搭建单实例DG详细步骤以及注意事项

原创 作者:贺子_DBA时代 时间:2015-03-06 09:58:55 0 删除 编辑
<div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="font-size:22px;background-color:inherit;">环境介绍:</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> OS: 都是&nbsp;<span style="line-height:1.5;background-color:inherit;">[</span><a style="line-height:1.5;cursor:pointer;background-color:inherit;" href="mailto:root@java3">root@java3</a><span style="line-height:1.5;background-color:inherit;">&nbsp;~]#&nbsp;uname&nbsp;-a&nbsp;</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="line-height:1.5;background-color:inherit;">Linux&nbsp;java3&nbsp;2.6.18-308.el5&nbsp;#1&nbsp;SMP&nbsp;Tue&nbsp;Feb&nbsp;21&nbsp;20:06:06&nbsp;EST&nbsp;2012&nbsp;x86_64&nbsp;x86_64&nbsp;x86_64&nbsp;GNU/Linux</span>&nbsp; </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> 主库: &nbsp;数据库版本:11.2.0.3.0 &nbsp; 两个节点的RAC &nbsp;节点一:192.168.15.26 &nbsp; 节点二:192.168.15.27 </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> standby 数据库版本: &nbsp;11.2.0.3.0 &nbsp; &nbsp; &nbsp; IP 192.168.15.9 &nbsp; &nbsp; &nbsp;&nbsp;<span style="font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;background-color:#FFFFFF;">&nbsp; &nbsp;scan ip 192.168.15.99</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> 备库 只安装了数据库软件 &nbsp;没有建库 </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="font-size:22px;background-color:inherit;">具体步骤:</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> 一:在<span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">192.168.15.9 这台服务器上安装数据库软件,不多介绍。</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">二:修改主库参数</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">参数 可以<span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">11g官方手册 book list --DAT--</span><span style="text-align:left;color:#000000;font-family:Tahoma, sans-serif;font-size:small;font-style:normal;font-weight:normal;background-color:#FFFFFF;">Data Guard Concepts and Administration--</span><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">3.1&nbsp;Preparing the&nbsp;Primary Database for Standby Database Creation--3.1.4 &nbsp;中的例子中看到要在主库参数文件里面应该有的的参数(如果没有要添加),如下所示:</span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <br /> <pre style="text-align:left;color:#000000;font-family:monospace;font-size:14px;font-style:normal;font-weight:normal;background-color:#EEEEEE;"><span style="color:#222222;background-color:inherit;">DB_NAME=chicago #主库的数据库名 DB_UNIQUE_NAME=chicago #主库的数据库名备库 也有属于自己的唯一数据库名 LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)' #注意括号里主备库的位置 CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ctl' #这个参数主库不需要改,备库要改成自己存在的路径 </span><span style="color:#222222;background-color:inherit;"> LOG_ARCHIVE_DEST_1= #这个参数是制定本地(主库)归档日志文件的位置 'LOCATION=/arch1/chicago/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=chicago' # 这里是备库的数据库唯一名 LOG_ARCHIVE_DEST_2= #这个参数是说是作为主库的这一方要传递联机在线日志到数据库唯一名为boston的备库。 'SERVICE=boston LGWR SYNC #同步传输redo VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston' #此处填写备库数据库名, LOG_ARCHIVE_DEST_STATE_1=ENABLE #开启传输日志的服务 LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE #远程登录口令文件用于验证管理用户或重做传输会话时,必须设置成exclusive或shared LOG_ARCHIVE_FORMAT=%t_%s_%r.arc #设置归档日志文件的格式 ,</span><span style="background-color:inherit;color:#222222;white-space:normal;">设置归档日志文件的格式 如果是 arch 日志传输模式,也就是传归档,那要保证主备库格式一样,否则可以不改</span><span style="color:#222222;background-color:inherit;"> </span></pre> <br /> <pre style="text-align:left;color:#000000;font-family:monospace;font-size:14px;font-style:normal;font-weight:normal;background-color:#EEEEEE;"> <pre style="font-family:monospace;font-style:normal;background-color:#EEEEEE;"><span style="color:#222222;background-color:inherit;">FAL_SERVER=boston #此处是填写备库的数据库名,该参数只是作为standby数据库时才有用,意思是说备库把这里指定的主库的数据库名作为服务器端,并获取请求。针对这个参数,如果不打算主备库转换,没必要在主库设该参数。 DB_FILE_NAME_CONVERT= '/backup/','+data/jlprojct/datafile/' #该参数是个静态参数,其作用是在主库执行duplicate时的recovere过程根据主库的数据文件位置转换成这里指定的备库合适的位置,经测试是根据备库的这个参数转变,和主库没有关系,也就是说在主库执行duplicate会根据备库的这个参数指定的位置在备库产生数据文件。如果你在主库添加一个新的数据文件,你必须在备库相应位置建立相应的数据文件。 LOG_FILE_NAME_CONVERT= #类似于上一个参数,注意修改这个参数时,如果你的主库的日志文件有若干个不同路径,你都要写进来, '/arch1/boston/','/arch1/chicago/','/arch2/boston/','/arch2/chicago/' </span><span style="color:#FF0000;background-color:inherit;"></span><span style="color:#222222;background-color:inherit;"> </span></pre> <pre style="color:#222222;font-family:monospace;font-style:normal;background-color:#EEEEEE;">STANDBY_FILE_MANAGEMENT=AUTO #这个参数是说当你设置成auto后,你在主库添加或删除数据文件,会自动在备库做相应的操作,要注意不要覆写已经存在的数据文件。别起一样的名。</pre> </pre> <br /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">如果要求主数据库不能停机(也就是不能重启的话),那么你可以通过以下这些命令修改主库的参数。</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">SQL&gt; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='location=+arch/jlprojct/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=JLPROJCT';</span><br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">System altered.</span><br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=JLPROJCT3 &nbsp;ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=JLPROJCT3'; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=spfile; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; &nbsp;ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=spfile; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; &nbsp;ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE scope=spfile; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' scope=spfile; &nbsp; <pre style="font-size:14px;line-height:21px;background-color:#EEEEEE;"><span style="color:#222222;background-color:inherit;">#设置归档日志文件的格式 ,</span><span style="background-color:inherit;color:#222222;white-space:normal;">设置归档日志文件的格式 如果是 arch 日志传输模式,也就是传归档,那要保证主备库格式一样,否则可以不改</span></pre> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; ALTER SYSTEM SET FAL_CLIENT = JLPROJCT SCOPE=SPFILE; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; # &nbsp;<span style="line-height:1.5;background-color:#FFFFFF;">fal_client也是设置本身,fal_server是对方</span> </div> </span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#DFDFDF;"></span> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; ALTER SYSTEM SET FAL_SERVER = JLPROJCT3 SCOPE=SPFILE; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> SQL&gt; ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=SPFILE; &nbsp; &nbsp; &nbsp;&nbsp; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;background-color:#FFFFFF;">SQL&gt; ALTER SYSTEM SET DB_FILE_NAME_CONVERT=</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"></span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"><span style="background-color:inherit;">&nbsp;'</span></span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;">/backup/data/JLPROJCT/', '+data/&nbsp;</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;">jlprojct/datafile/'</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"></span><span style="font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;background-color:#FFFFFF;">&nbsp;scope =spfile; &nbsp; &nbsp;</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;">&nbsp;#静态参数,不重启,不起作用 ,如果不打算主备库换位置(failover),那么就可以不设置,因为备库的这个参数才起作用。</span> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="line-height:1.5;background-color:#FFFFFF;"><span style="font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;background-color:#FFFFFF;">SQL&gt; ALTER SYSTEM SET &nbsp;LOG_FILE_NAME_CONVERT='</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;">/backup/arch/', '+arch/jlprojct/</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;">archivelog/'</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"></span><span style="font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;background-color:#FFFFFF;">scope =spfile; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span><span style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;">&nbsp;#静态参数,不重启,不起作用 ,如果不打算主备库换位置(failover),那么就可以不设置,因为备库的这个参数才起作用</span></span> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> System altered. </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> 三 ;修改主库的监听和tnsname.ora 文件 </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> 1,主库监听listener.ora文件 添加 (如果有就不修改) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> LISTENER1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER1)))) &nbsp; &nbsp; &nbsp;&nbsp; </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1=ON&nbsp; </div> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> </div> </span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> 2.主库<span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">tnsname.ora 添加备库的相关信息。</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> JLPROJCT3 = &nbsp; &nbsp; &nbsp; #备库的相关信息 </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; (DESCRIPTION = </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; &nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.9)(PORT = 1521)) </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; &nbsp; (CONNECT_DATA = &nbsp; </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; &nbsp; &nbsp; (SERVER = DEDICATED) </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; &nbsp; &nbsp; (SERVICE_NAME = JLPROJCT3) </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; (INSTANCE_NAME = JLPROJCT3) </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; &nbsp; ) </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; ) </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> &nbsp;<span style="line-height:1.5;">JLPROJCT</span>= &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #主库相关信息 &nbsp; 执行duplicate之前 要rman 同时连接主库和备库,连接主库时,会用到这个连接字符串。 </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> &nbsp; (DESCRIPTION = </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> &nbsp; &nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.99)(PORT = 1521)) </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> &nbsp; &nbsp; (CONNECT_DATA = </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> &nbsp; &nbsp; &nbsp; (SERVER = DEDICATED) </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> &nbsp; &nbsp; &nbsp; (SERVICE_NAME = JLPROJCT) </div> <div> <br /> </div> </span></span></span> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"></span></span></span> </div> <br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> &nbsp; </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> 四:在主库用scp 把<span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">listener.ora &nbsp;,<span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">tnsname.ora ,initJLPROJCT1.ora,pfile.ora &nbsp;传给备库 然后进行相应的修改(参数文件不需要修改内容,但是要改名 和备库实例名相对应 :</span></span><span style="line-height:1.5;background-color:inherit;">[</span><a style="line-height:1.5;cursor:pointer;background-color:inherit;" href="mailto:oracle@java3">oracle@java3</a><span style="line-height:1.5;background-color:inherit;">&nbsp;dbs]$&nbsp;mv&nbsp;orapwJLPROJCT&nbsp;orapwJLPROJCT3&nbsp;</span><span style="line-height:1.5;background-color:#FFFFFF;">&nbsp;)</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="background-color:inherit;">&nbsp;</span></span></span></span><span style="line-height:1.5;background-color:inherit;">[</span><a style="line-height:1.5;cursor:pointer;background-color:inherit;" href="mailto:oracle@rac1">oracle@rac1</a><span style="line-height:1.5;background-color:inherit;">&nbsp;~]$&nbsp;</span><span style="line-height:1.5;background-color:#FFFFFF;">scp listener.ora tnsnames.ora initJLPROJCT1.ora &nbsp;&nbsp;</span><a style="line-height:1.5;cursor:pointer;background-color:#FFFFFF;" href="mailto:oracle@192.168.">oracle@192.168.</a><span style="line-height:1.5;background-color:#FFFFFF;">15.</span><span style="line-height:1.5;background-color:#FFFFFF;">:`pwd`; &nbsp; &nbsp; &nbsp;#冒号后面的pwd 意思是说要把文件传到备库的当前路径下(也就是此时在主机上 pwd 显示的路径)</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">把监听的信息改成备库的,tnaname.ora添加主库的相关信息。</span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">1.备库监听<span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">listener.ora 内容如下:</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">SID_LIST_LISTENER=</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; (SID_LIST=</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; (SID_DESC=</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp; (GLOBAL_DBNAME=JLPROJCT3)</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp; (ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1)</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp; (SID_NAME=JLPROJCT3)))</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"></span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"></span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">LISTENER =</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; (DESCRIPTION_LIST =</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; (DESCRIPTION =</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.9)(PORT = 1521)) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#主机IP</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp; (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; )</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; )</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">ADR_BASE_LISTENER = /opt/oracle</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">2.备库tnsname.ora 内容:</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">JLPROJCT = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #主库相关信息 &nbsp; 这里的连接字符串和主库tnsname.ora 里面的不一样,不影响,随便起的名字&nbsp;</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; (DESCRIPTION =</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.99)(PORT = 1521))</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; (CONNECT_DATA =</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp; (SERVER = DEDICATED)</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp; (SERVICE_NAME = JLPROJCT)</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> JLPROJCT3 = &nbsp; &nbsp; &nbsp; #备库的相关信息 &nbsp; &nbsp; &nbsp;如果仅仅是做standby 数据库,不填他自己这个也行。 &nbsp; &nbsp; &nbsp;&nbsp; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; (DESCRIPTION = </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; &nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.9)(PORT = 1521)) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; &nbsp; (CONNECT_DATA = &nbsp; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; &nbsp; &nbsp; (SERVER = DEDICATED) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; &nbsp; &nbsp; (SERVICE_NAME = JLPROJCT3) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; (INSTANCE_NAME = JLPROJCT3) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; &nbsp; ) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; ) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> 备库参数文件修改 : &nbsp; &nbsp; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> DB_NAME=JLPROJCT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #因为就一个数据库 &nbsp; 所以此处不变 </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> DB_UNIQUE_NAME=JLPROJCT3 &nbsp; &nbsp; #这里要写成了备库数据库唯一名,便于区分主备库,即使转换角色也不改名。 </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> LOG_ARCHIVE_CONFIG='DG_CONFIG=(JLPROJCT3,JLPROJCT)' &nbsp; &nbsp; &nbsp; #括号里面和主库括号里面的前后位置改变。 &nbsp; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> LOG_ARCHIVE_DEST_1= </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp;'location=/opt/oracle &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#填上备库有的目录,保证有空闲空间 ,以及有权限读写, &nbsp; &nbsp;&nbsp; </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; VALID_FOR=(ALL_LOGFILES,ALL_ROLES) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; DB_UNIQUE_NAME=JLPROJCT3' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#备库名字 </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> LOG_ARCHIVE_DEST_2= </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp;'SERVICE=JLPROJCT ASYNC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; #主库的名字 </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> &nbsp; DB_UNIQUE_NAME=JLPROJCT' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#主库名字 </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> LOG_ARCHIVE_DEST_STATE_1=ENABLE </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> LOG_ARCHIVE_DEST_STATE_2=ENABLE </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> LOG_ARCHIVE_FORMAT=%t_%s_%r.arc </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> FAL_SERVER=JLPROJCT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#主库名字 </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> DB_FILE_NAME_CONVERT='+data/jlprojct/datafile/','/backup/','+DATA/jlprojct/tempfile/','/backup/' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#等号后的两个路径相对于主库的换位置 </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> <span style="line-height:1.5;">LOG_FILE_NAME_CONVERT='+DATA/jlprojct/onlinelog/', '/backup/', '+ARCH/jlprojct/onlinelog/','/backup/','+ARCH/jlprojct/archivelog/','/backup/' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><span style="line-height:1.5;">#等号后的两个路径换位置</span> </div> <div style="background-color:#FFFFFF;font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;"> STANDBY_FILE_MANAGEMENT=AUTO </div> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> </div> 五:在备库上 把修改过后的pfile 创建成spfile,然后 改名 ,并把<span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">备库实例启动到nomount状态</span></span></span></span> </div> <a style="font:14px/21px 微软雅黑;text-align:left;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;cursor:pointer;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;" href="mailto:SYS@JLPROJCT3">SYS@JLPROJCT3</a><span style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;float:none;display:inline !important;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;">&gt;&nbsp;create&nbsp;&nbsp;pfile&nbsp;from&nbsp;spfile;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="line-height:1.5;background-color:inherit;">File&nbsp;created.</span><span style="line-height:1.5;background-color:#FFFFFF;"><span style="background-color:#FFFFFF;"><span style="background-color:#FFFFFF;">&nbsp; &nbsp; &nbsp;</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">六:在主库上添加standby 日志组 添加的个数为:(主库原来有的个数n+1)*线程数 ,这里所说的线程数可以理解为实例的个数,这里有10个日志组,所以要添加(10+1)*2=22组。大小和路径最好和原来的保持一致,<span style="color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#DFDFDF;"></span></span></span></span> </div> <span style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;">DG有两种传递日志的方式,一种是常见的archivr log,由ARCH的后台进程控制传递到standby数据库,还有一种是和redo log一样的传递方式,由产生redo log的后台进程LGWR控制,后者就需要standby log</span> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#DFDFDF;"></span></span></span></span><span style="line-height:1.5;background-color:#FFFFFF;">在最大可用和最大保护模式,因为是采用LGWR SYNC进行redo的传送,一定要用standby logfile,但是建议在最大性能模式也添加standby logfile,据说在失败切换时可以恢复更多的数据</span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">添加命令如下:</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">alter&nbsp;database&nbsp;add&nbsp;standby&nbsp;logfile&nbsp;group 15 ('+DATA/jlprojct/onlinelog/group_15')&nbsp;size 2000M;</span><br style="background-color:inherit;" /> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">六:在主库进行测试 &nbsp;成功后继续进行 &nbsp; ,打开主备库的监听,关闭防火墙,</span> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> [<a style="cursor:pointer;background-color:inherit;" href="mailto:oracle@rac1">oracle@rac1</a>&nbsp;~]$&nbsp;tnsping&nbsp;JLPROJCT3<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> TNS&nbsp;Ping&nbsp;Utility&nbsp;for&nbsp;Linux:&nbsp;Version&nbsp;11.2.0.3.0&nbsp;-&nbsp;Production&nbsp;on&nbsp;05-MAR-2015&nbsp;17:45:23<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Copyright&nbsp;(c)&nbsp;1997,&nbsp;2011,&nbsp;Oracle.&nbsp;&nbsp;All&nbsp;rights&nbsp;reserved.<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Used&nbsp;parameter&nbsp;files:<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Used&nbsp;TNSNAMES&nbsp;adapter&nbsp;to&nbsp;resolve&nbsp;the&nbsp;alias<br style="background-color:inherit;" /> Attempting&nbsp;to&nbsp;contact&nbsp;(DESCRIPTION&nbsp;=&nbsp;(ADDRESS&nbsp;=&nbsp;(PROTOCOL&nbsp;=&nbsp;TCP)(HOST&nbsp;=&nbsp;192.168.15.9)(PORT&nbsp;=&nbsp;1521))&nbsp;(CONNECT_DATA&nbsp;=&nbsp;(SERVER&nbsp;=&nbsp;DEDICATED)&nbsp;(SERVICE_NAME&nbsp;=&nbsp;JLPROJCT3)&nbsp;(INSTANCE_NAME&nbsp;=&nbsp;JLPROJCT3)))<br style="background-color:inherit;" /> OK&nbsp;(0&nbsp;msec) </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> [<a style="cursor:pointer;background-color:inherit;" href="mailto:oracle@rac1">oracle@rac1</a>&nbsp;~]$&nbsp;tnsping&nbsp;<span style="font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;background-color:#FFFFFF;">JLPROJCT</span><br style="background-color:inherit;" /> <br style="background-color:inherit;" /> TNS&nbsp;Ping&nbsp;Utility&nbsp;for&nbsp;Linux:&nbsp;Version&nbsp;11.2.0.3.0&nbsp;-&nbsp;Production&nbsp;on&nbsp;05-MAR-2015&nbsp;17:46:43<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Copyright&nbsp;(c)&nbsp;1997,&nbsp;2011,&nbsp;Oracle.&nbsp;&nbsp;All&nbsp;rights&nbsp;reserved.<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Used&nbsp;parameter&nbsp;files:<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Used&nbsp;TNSNAMES&nbsp;adapter&nbsp;to&nbsp;resolve&nbsp;the&nbsp;alias<br style="background-color:inherit;" /> Attempting&nbsp;to&nbsp;contact&nbsp;(DESCRIPTION&nbsp;=&nbsp;(ADDRESS&nbsp;=&nbsp;(PROTOCOL&nbsp;=&nbsp;TCP)(HOST&nbsp;=&nbsp;192.168.15.99)(PORT&nbsp;=&nbsp;1521))&nbsp;(CONNECT_DATA&nbsp;=&nbsp;(SERVER&nbsp;=&nbsp;DEDICATED)&nbsp;(SERVICE_NAME&nbsp;=&nbsp;JLPROJCT)))<br style="background-color:inherit;" /> OK&nbsp;(10&nbsp;msec) </div> 七:在主库用rman 同时连接主备库。</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> [<a style="cursor:pointer;background-color:inherit;" href="mailto:oracle@rac1">oracle@rac1</a>&nbsp;~]$&nbsp;&nbsp;rman&nbsp;target&nbsp;sys/<a style="cursor:pointer;background-color:inherit;" href="mailto:xxxxx@db26">xxxxx@<span style="font-family:微软雅黑;font-size:14px;line-height:21px;white-space:normal;background-color:#FFFFFF;">JLPROJCT</span></a>&nbsp;auxiliary&nbsp;sys/<a style="cursor:pointer;background-color:inherit;" href="mailto:xxxxx@JLPROJCT3">xxxxx@JLPROJCT3</a><br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Recovery&nbsp;Manager:&nbsp;Release&nbsp;11.2.0.3.0&nbsp;-&nbsp;Production&nbsp;on&nbsp;Thu&nbsp;Mar&nbsp;5&nbsp;17:51:23&nbsp;2015<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Copyright&nbsp;(c)&nbsp;1982,&nbsp;2011,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;&nbsp;All&nbsp;rights&nbsp;reserved.<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> connected&nbsp;to&nbsp;target&nbsp;database:&nbsp;JLPROJCT&nbsp;(DBID=2115662724)<br style="background-color:inherit;" /> connected&nbsp;to&nbsp;auxiliary&nbsp;database:&nbsp;JLPROJCT&nbsp;(not mounted )<br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> 八:在主库执行duplicate命令,最关键的一步,备份主库的控制文件,数据文件,日志文件,然后传给备库,并在备库recover ,如果没有报错的话,备库就会Open了。 </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">RMAN&gt;&nbsp;duplicate&nbsp;target&nbsp;database&nbsp;for&nbsp;standby&nbsp;from&nbsp;active&nbsp;database dorecover &nbsp;nofilenamecheck;</span><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> 九:read only &nbsp;的方式,打开备库数据库实例。 </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <a style="cursor:pointer;background-color:inherit;" href="mailto:SYS@JLPROJCT3">SYS@JLPROJCT3</a>&gt;&nbsp;alter&nbsp;database&nbsp;open&nbsp;read&nbsp;only;<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Database&nbsp;altered.<br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">十:在备库打开MRP进程 ,应用日志,重演变化。注意:一定要保证备库实例是在 read only 的方式下打开的,否则不能同步。</span></span></span></span> </div> <div style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"> <a style="cursor:pointer;background-color:inherit;" href="mailto:SYS@JLPROJCT3">SYS@JLPROJCT3</a>&gt;&nbsp;ALTER&nbsp;DATABASE&nbsp;RECOVER&nbsp;MANAGED&nbsp;STANDBY&nbsp;DATABASE&nbsp;DISCONNECT&nbsp;FROM&nbsp;SESSION;<br style="background-color:inherit;" /> <br style="background-color:inherit;" /> Database&nbsp;altered. </div> 十一:测试结果:在主库随便建立一个用户,并在这个用户下建立一个表,发现备库也会有,证明DG搭建成功。&nbsp;</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><br style="background-color:inherit;" /> </span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;"><span style="text-align:left;color:#000000;font-family:微软雅黑;font-size:14px;font-style:normal;font-weight:normal;background-color:#FFFFFF;">&nbsp;</span></span></span> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <br style="background-color:inherit;" /> </div> <div style="font:14px/21px 微软雅黑;text-align:left;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;font-size-adjust:none;font-stretch:normal;background-color:#FFFFFF;-webkit-text-stroke-width:0px;"> <br style="background-color:inherit;" /> </div> <br class="Apple-interchange-newline" />
请登录后发表评论 登录
全部评论

注册时间:2014-05-12

  • 博文量
    213
  • 访问量
    1479439