博客首页
注册
建议与交流
排行榜
加入友情链接
推荐
投诉
搜索：
帮助
吉祥嘻嘻
才华斗不过资本，资本斗不过行政，行政斗不过政治，政治斗不过潮流，潮流斗不过宇宙规律
hnnx.cublog.cn
管理博客
发表文章
留言
收藏夹
博客圈
音乐
相册
· 照片
· 宝贝女儿
文章
· 操作系统
}
· HPUX
· LINUX
· WINDOWS
· 工作文化
· 工作笔记
· 资源中心
· 数据库
}
· ORACLE
首页
关于作者
QQ:5728686 E_mail:hnnx_yue@126.com
||
<<
>>
||
我的分类
文章列表 - 工作笔记
重建临时标空间
查看全文
发表于:2008-07-01 ┆
阅读(76)
┆
评论(0)
在线添加表空间
<DIV>先查询数据文件使用情况</DIV> <DIV>SQL>select name from v$datafile order by name；</DIV> <DIV>SQL>select name from v$tempfile order by name；</DIV> <DIV>然后把没有使用的数据文件添加到所要添加的表空间</DIV> <DIV>SQL>alter tablespace “HIS_TBS” add datafile</DIV> <DIV>SQL>‘/dev/vg_data04/rlv_data230’，</DIV> <DIV>SQL>‘/dev/vg_data04/rlv_data231’；</DIV>
查看全文
发表于:2008-06-20 ┆
阅读(95)
┆
评论(0)
修改EASYCON密码注意事项
<DIV>修改easycon密码注意事项：</DIV> <DIV>修改命令：SQL>alter user easycon identified by 新密码；</DIV> <DIV> </DIV> <DIV>注意事项：</DIV> <DIV>一、在单台数据库服务器上修改执行就可以了；</DIV> <DIV>二、easycon用户密码修改以后需要分别同步前置一上的hneasy1用户密码、前置二上的hneasy2用户密码、数据库服务器上的hneasy用户密码。方法是，分别用hneasy用户登录，然后执行set_passwd命令。</DIV> <DIV>三、修改密码以后，要同步修改反洗钱导表脚本的easycon密码，analyze脚本的easycon密码</DIV>
查看全文
发表于:2008-06-16 ┆
阅读(96)
┆
评论(0)
xp128报警信息
<DIV>上班第一天到机房检查,发现XP128报警灯亮,检查LOG信息,发现HDU-2 06块盘坏掉,需要更换硬盘.报800,派单更换.</DIV> <DIV>处理步骤:</DIV> <DIV>1,查看VIEW MODE 模式</DIV> <DIV>2,查看LOG</DIV> <DIV>LOG信息显示DRIVE ERROR</DIV> <DIV>3,到MAINTENANCE下检查有没有闪烁的信息,如果有,就表示该地方有硬件故障.</DIV> <DIV>4,确定故障以后报HP800.</DIV> <DIV> </DIV>
查看全文
发表于:2008-02-13 ┆
阅读(204)
┆
评论(0)
生产系统重起机器操作流程
<DIV align=left><FONT size=3><B><FONT face="Times New Roman">1</FONT></B><B>、停<FONT face="Times New Roman">hneasy1</FONT></B><B>、<FONT face="Times New Roman">hneasy2</FONT></B><B>、<FONT face="Times New Roman">hneasy</FONT></B><B>应用</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>Tmshutdown –y</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT></DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">2</FONT></B><B>、停<FONT face="Times New Roman">SZXSRV1</FONT></B><B>数据库</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>Sql>alter system checkpoint;</FONT></DIV> <DIV><FONT face="Times New Roman" size=3>Sql>Shutdown immediate;</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">3</FONT></B><B>、停<FONT face="Times New Roman">SZXSRV2</FONT></B><B>机数据库</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>Sql>alter system checkpoint;</FONT></DIV> <DIV><FONT face="Times New Roman" size=3>Sql>Shutdown immediate;</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">4</FONT></B><B>、停<FONT face="Times New Roman">SZXSRV1</FONT></B><B>机的<FONT face="Times New Roman">CRS</FONT></B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#[/sbin/init.d]./init.crs stop</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">5</FONT></B><B>、停<FONT face="Times New Roman">SZXSRV2</FONT></B><B>机的<FONT face="Times New Roman">CRS</FONT></B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#[/sbin/init.d]./init.crs stop</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">6</FONT></B><B>、停<FONT face="Times New Roman">SZXSRV1</FONT></B><B>机的<FONT face="Times New Roman">MC</FONT></B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#cmhaltcl –v –f</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">7</FONT></B><B>、停<FONT face="Times New Roman">SZXSRV2</FONT></B><B>机的<FONT face="Times New Roman">MC</FONT></B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#cmhaltcl –v –f </FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">8</FONT></B><B>、停两台前置机集群</B><FONT face="Times New Roman"> ---</FONT>停集群应该在单边机器停就可以了</FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#cmhaltcl –v –f</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">9</FONT></B><B>、重起<FONT face="Times New Roman">SZXSRV1</FONT></B><B>机器</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#Shutdown –r –y 0</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">10</FONT></B><B>、重起<FONT face="Times New Roman">SZXSRV2</FONT></B><B>机器</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#Shutdown –r –y 0</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">11</FONT></B><B>、重起<FONT face="Times New Roman">SZXQZ1</FONT></B><B>机器</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#Shutdown –r –y 0</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">12</FONT></B><B>、重起<FONT face="Times New Roman">SZXQZ2</FONT></B><B>机器</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#Shutdown –r –y 0</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">13</FONT></B><B>、起两台服务器的集群并检查包运行状态<FONT face="Times New Roman"> </FONT></B><FONT face="Times New Roman"> --</FONT>单边起应该就可以了</FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#cmruncl –v</FONT></DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">14</FONT></B><B>、起两台前置集群并检查包运行状态</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#cmruncl –v</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">15</FONT></B><B>、起<FONT face="Times New Roman">SZXSRV1</FONT></B><B>机的<FONT face="Times New Roman">CRS</FONT></B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#[/sbin/init.d]./init.crs start</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">16</FONT></B><B>、起<FONT face="Times New Roman">SZXSRV2</FONT></B><B>机的<FONT face="Times New Roman">CRS</FONT></B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>#[/sbin/init.d]./init.crs start</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">17</FONT></B><B>、起服务，并检查服务指向</B></FONT></DIV> <DIV><FONT size=3><FONT face="Times New Roman">$srvctl start service –d szxdb –s </FONT>“<FONT face="Times New Roman">SVC,SVC1,SVC</FONT><FONT face="Times New Roman">2</FONT>”</FONT></DIV> <DIV><FONT face="Times New Roman" size=3></FONT> </DIV> <DIV><FONT size=3><B><FONT face="Times New Roman">18</FONT></B><B>、重起<FONT face="Times New Roman">hneasy1</FONT></B><B>、<FONT face="Times New Roman">hneasy2</FONT></B><B>、<FONT face="Times New Roman">hneasy</FONT></B><B>应用</B></FONT></DIV> <DIV><FONT face="Times New Roman" size=3>Tmshutdown –y</FONT></DIV> <DIV><FONT face="Times New Roman" size=3>Tmboot –y</FONT></DIV>
查看全文
发表于:2008-02-01 ┆
阅读(246)
┆
评论(0)
生产系统重起数据库流程
<DIV> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>1、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">停前置业务：</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">Tmshutdown –y <o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><FONT size=3><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">Tmshutdown –s </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">业务名称</SPAN><SPAN style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman"> <SPAN lang=EN-US>–k<SPAN style="mso-spacerun: yes"> </SPAN>KILL<o:p></o:p></SPAN></FONT></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>2、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">停数据库：</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt; TEXT-INDENT: -36pt; mso-list: l1 level2 lfo1; tab-stops: list 57.0pt"><SPAN lang=EN-US style="mso-bidi-font-family: 宋体; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>（1）</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">停实例</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">、</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">2<o:p></o:p></FONT></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt; TEXT-INDENT: -36pt; mso-list: l1 level2 lfo1; tab-stops: list 57.0pt"><SPAN lang=EN-US style="mso-bidi-font-family: 宋体; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>（2）</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">停</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">crs<o:p></o:p></FONT></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">/sbin/init.d/init.crs stop<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>3、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">重启</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">crs<o:p></o:p></FONT></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">（</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">）启动</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">crs1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">、</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">2<o:p></o:p></FONT></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 69.75pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">/sbin/init.d/init.crs start<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>4、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">查看连接状态</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt; TEXT-INDENT: -36pt; mso-list: l1 level2 lfo1; tab-stops: list 57.0pt"><SPAN lang=EN-US style="mso-bidi-font-family: 宋体; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>（1）</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">查看</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">crs</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">状态</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">Su – oracle<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">Crs_stat –t<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt"><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">如都是</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">online</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">状态，则数据库正常</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt; TEXT-INDENT: -36pt; mso-list: l1 level2 lfo1; tab-stops: list 57.0pt"><SPAN lang=EN-US style="mso-bidi-font-family: 宋体; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>（2）</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">查看</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">svc</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">连接状态</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 57pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">Srvctl<SPAN style="mso-spacerun: yes"> </SPAN>status service –d szxdb –s svc\svc1\svc2<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 54.75pt; TEXT-INDENT: -27.75pt; mso-list: l0 level1 lfo2; tab-stops: list 54.75pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>(3)</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">手动启</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT face="Times New Roman">svc<o:p></o:p></FONT></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 54.75pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">Srvctl start service –d szxdb –s svc/svc1/svc2<o:p></o:p></FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l1 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>5、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">所有数据库状态正常后，重启前置业务</SPAN><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 42pt"><SPAN lang=EN-US style="mso-bidi-font-size: 10.5pt"><FONT size=3><FONT face="Times New Roman">Tmboot -y<o:p></o:p></FONT></FONT></SPAN></P></DIV> <DIV></DIV>
查看全文
发表于:2008-01-21 ┆
阅读(191)
┆
评论(0)
结息系统操作流程
<DIV> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><FONT size=3></FONT></SPAN> </P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>1、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在szxqz1机</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">上执行：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>su – hneasy1</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>tmshutdown –y</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>2、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在szxqz2机</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">上执行：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Su – hneasy2</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Tmshutdown –y</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>3、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">日结之后，在南阳</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">11.21.32.1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">上执行</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>Export HORCMINST=0</FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>Unset HORCC_MRCF</FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>Pairdisplay –g ora –fxc |more </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">察看是否同步，如果同步，则执行：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>Pairsplit –g ora</FONT></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>4、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">superdome2</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">上执行</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Su – oracle</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Sqlplus / as sysdba</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Shutdown immediate</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Srvctl status service –d szxdb –s “SVC ,SVC1,SVC2”</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>5、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">结息之后</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">,</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">superdome2</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">上</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Su – oracle </FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Sqlplus / as sysdba;</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Startup;</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Exit</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Srvctl status service –d szxdb –s “SVC,SVC1,SVC2”</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Srvctl relocate service –d szxdb –s SVC2 –i szxdb1 –t szxdb2</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>6、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在szxqz1机</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">上执行：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Su – hneasy1</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>tmboot –y</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman"><FONT size=3>7、</FONT><SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在szxqz2机</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">上执行</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Su – hneasy2</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>Tmboot –y</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><FONT size=3>测试应用</FONT></SPAN></P></DIV> <DIV></DIV>
查看全文
发表于:2008-01-21 ┆
阅读(181)
┆
评论(0)
每月底数据备份操作流程
<DIV> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">1、</FONT></SPAN></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">每月月底，前台签退完毕后，登陆到南阳容灾主机，将</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">bc</FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">断开，并启动数据库，更改</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">easycon</FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">密码，具体步骤如下：</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">export HORCMINST=1<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">export HORCC_MRCF=1<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">pairsplit -g ora-bc <o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">查看容灾状态：</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">pairdisplay -g ora-bc -fxc </FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">如果显示为</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman"> ssus psus </FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">状态</SPAN><SPAN style="FONT-SIZE: 12pt"><FONT face="Times New Roman"> </FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将卷组激活</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgcluster </FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">关闭：</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -c n /dev/vg_data01<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -c n /dev/vg_data02<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -c n /dev/vg_data03<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -c n /dev/vg_data04<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vg</FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">卷组激活：</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center" align=center><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -a y /dev/vg_data01<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -a y /dev/vg_data02<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -a y /dev/vg_data03<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">vgchange -a y /dev/vg_data04<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">启动数据库，并更改</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">easycon</FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">密码：</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">Alter user easycon identified by easycon<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 17.95pt; TEXT-INDENT: 6pt; mso-char-indent-count: .5; mso-para-margin-left: 1.71gd"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">2、</FONT></SPAN></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">运行</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman"> /tmp/chp/22.sh,</FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">也可手动执行以下命令建立数据泵：</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>create directory orabackup as '/oraexp/expfile';<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 24pt; mso-char-indent-count: 2.0"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">grant read,write on directory orabackup to easycon;<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 24pt; mso-char-indent-count: 2.0"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">grant exp_full_database to easycon;<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 24pt; mso-char-indent-count: 2.0"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><FONT face="Times New Roman"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore">3、</SPAN></SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt">expdp easycon/easycon DIRECTORY=orabackup DUMPFILE=easycon.dmp<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">4、</FONT></SPAN></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">第二天将导出数据压缩：</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">gzip –c easycon.dmp>easycon**.dmp.gz<o:p></o:p></FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">5、</FONT></SPAN></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">启动</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">dp</FONT></SPAN><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将压缩后的数据备份到带库中，记录备份信息</SPAN><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P></DIV> <DIV></DIV>
查看全文
发表于:2008-01-21 ┆
阅读(253)
┆
评论(0)
征信数据导出操作流程
<DIV> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、每月</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">21</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">日，前台签退完毕后，登陆到南阳容灾主机，将</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">bc</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">断开，并启动数据库，具体步骤如下：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>export HORCMINST=1</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>export HORCC_MRCF=1</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>pairsplit -g ora-bc </FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">查看容灾状态：</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">pairdisplay -g ora-bc -fxc </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">如果显示为</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"> ssus psus </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">状态</SPAN><FONT face="Times New Roman"> </FONT><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将卷组激活</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">vgcluster </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">关闭：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -c n /dev/vg_data01</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -c n /dev/vg_data02</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -c n /dev/vg_data03</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -c n /dev/vg_data04</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">vg</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">卷组激活：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -a y /dev/vg_data01</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -a y /dev/vg_data02</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -a y /dev/vg_data03</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>vgchange -a y /dev/vg_data04</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">启动数据库，并修改</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">easycon </FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">密码：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>alter user easycon identified by easycon;</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=3><SPAN lang=EN-US><FONT face="Times New Roman">2</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、将征信所需数据用</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">exp</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">工具导出：</SPAN></FONT></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>exp easycon/easycon tables='sdbrhtxxb' file=/oraexp/expfile/sdbrhtxxb.exp buffer=40960000</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>exp easycon/easycon tables='sdkhtxxb' file=/oraexp/expfile/sdkhtxxb.exp buffer=40960000</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>exp easycon/easycon tables='kkhb' file=/oraexp/expfile/kkhb.exp buffer=40960000</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>exp easycon/easycon tables='ffhz' file=/oraexp/expfile/ffhz.exp buffer=40960000</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>exp easycon/easycon tables='fdkfh'<SPAN style="mso-spacerun: yes"> </SPAN>file=/oraexp/expfile/fdkhf.exp buffer=40960000</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>exp easycon/easycon tables='fajdkfh'<SPAN style="mso-spacerun: yes"> </SPAN>file=/oraexp/expfile/fajdkfh.exp buffer=40960000</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><FONT size=3>或者</FONT></SPAN></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" size=3>exp easycon/easycon tables='sdbrhtxxb, sdkhtxxb , kkhb , ffhz, fdkfh , fajdkfh ' file=/oraexp/expfile/zxsj.exp buffer=40960000</FONT></SPAN></P></DIV> <DIV></DIV> <DIV></DIV>
查看全文
发表于:2008-01-21 ┆
阅读(187)
┆
评论(0)
清理交易日志表的操作步骤
<DIV> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">1、<SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">每月</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">28</FONT></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">日，交易封锁后，将</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">tjyrzb</FONT></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中数据导出</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">exp easycon/xxxx tables=’tjyrzb’ file=/lv_app01/yw_back/tjyrzb.exp buffer=40960000;<o:p></o:p></FONT></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">2、<SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">将导出的数据备份到带库中，备份时使用</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">tables_backup pool<o:p></o:p></FONT></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">3、<SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">清除</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">tjyrzb</FONT></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中数据，用</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">easycon</FONT></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用户连接数据库</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">执行：</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">truncate table tjyrzb;<o:p></o:p></FONT></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>Commit</FONT></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">；</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p><FONT face="Times New Roman"> </FONT></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'"><SPAN style="mso-list: Ignore"><FONT face="Times New Roman">4、<SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></FONT></SPAN></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">检查</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">tjyrzb</FONT></SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中数据是否被删除：</SPAN></B><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 18pt"><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 12pt"><FONT face="Times New Roman">select count(*) from tjyrzb;<o:p></o:p></FONT></SPAN></B></P></DIV> <DIV></DIV> <DIV></DIV>
查看全文
发表于:2008-01-21 ┆
阅读(184)
┆
评论(0)
