博客首页
注册
建议与交流
排行榜
加入友情链接
推荐
投诉
搜索：
帮助
吉祥嘻嘻
才华斗不过资本，资本斗不过行政，行政斗不过政治，政治斗不过潮流，潮流斗不过宇宙规律
hnnx.cublog.cn
管理博客
发表文章
留言
收藏夹
博客圈
音乐
相册
· 照片
· 宝贝女儿
文章
· 操作系统
}
· HPUX
· LINUX
· WINDOWS
· 工作文化
· 工作笔记
· 资源中心
· 数据库
}
· ORACLE
首页
关于作者
QQ:5728686 E_mail:hnnx_yue@126.com
||
<<
>>
||
我的分类
文章列表 - ORACLE
SQLPLUS 使用的一些技巧
查看全文
发表于:2008-06-25 ┆
阅读(195)
┆
评论(0)
Oracle 10g RAC 的部署6
<DIV> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">CONTROLFILE<SPAN> </SPAN><SPAN> </SPAN>.97<SPAN> </SPAN>0<SPAN> </SPAN>1</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">ONLINELOG<SPAN> </SPAN>20<SPAN> </SPAN>0<SPAN> </SPAN>6</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">ARCHIVELOG<SPAN> </SPAN>0<SPAN> </SPAN>0<SPAN> </SPAN>0</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">BACKUPPIECE<SPAN> </SPAN>0<SPAN> </SPAN><SPAN> </SPAN>0<SPAN> </SPAN>0</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">IMAGECOPY<SPAN> </SPAN>0<SPAN> </SPAN>0<SPAN> </SPAN>0</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">FLASHBACKLOG<SPAN> </SPAN>0<SPAN> </SPAN>0<SPAN> </SPAN>0</SPAN></P> <P><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG> </P> <P><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial">(9) </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">启动和停止应用程序资源。</SPAN></STRONG><SPAN></SPAN></P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">遵循以下步骤启动和停止单独的应用程序资源。</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black; FONT-FAMILY: Arial"> </SPAN></P><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>启动程序资源<SPAN></SPAN></FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl start nodeapps -n <node1 hostname> <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">在节点<SPAN>1</SPAN>启动<SPAN>nodeapps</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl start nodeapps -n <node2 hostname> <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">在节点<SPAN>2</SPAN>启动<SPAN>nodeapps</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl start asm -n <node1 hostname> <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">在节点<SPAN>1</SPAN>启动<SPAN>asm<B></B></SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl start asm -n <node2 hostname> <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">在节点<SPAN>2</SPAN>启动<SPAN>asm</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl start database -d <database name> //</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">启动<SPAN>database</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl start service -d <database name> -s <service name> //</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">启动数据库的服务<SPAN></SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">crs_stat –t<SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">确认程序资源的状态<SPAN></SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl stop service -d <database name> -s <service name> //</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">停止数据库的服务<SPAN></SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl stop database -d <database name> <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">停止数据库<SPAN></SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl stop asm -n <node1 hostname> <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">停止<SPAN>asm</SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>srvctl stop asm -n <node2 hostname> </FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl stop nodeapps -n <node1 hostname> <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">停止<SPAN>nodeapps</SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>srvctl stop nodeapps -n <node2 hostname> </FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">crs_stat -t <SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">确认程序资源的状态<SPAN></SPAN></SPAN></FONT></PRE> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><B><SPAN style="FONT-SIZE: 12pt"><FONT face="Times New Roman">11 </FONT></SPAN></B><B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体">透明故障切换</SPAN></B><B><SPAN style="FONT-SIZE: 12pt"><FONT face="Times New Roman"> (TAF)</FONT></SPAN></B></P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><SPAN style="COLOR: black; FONT-FAMILY: Arial">Oracle TAF </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">中的故障切换机制使任何失败的数据库连接能够重新连接到集群中的其他节点。故障切换对用户是透明的。</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></P> <P><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN> </P> <P><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">创建一个新的数据库服务。</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG></P> <P><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG> </P> <P><SPAN style="COLOR: black; FONT-FAMILY: 宋体">首先，创建一个名为</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> CRM </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">的新服务。可以使用</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> DBCA </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">或</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> srvctl </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">实用程序来创建数据库服务。</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在节点</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">1</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">上，以</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> oracle </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">用户身份执行</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> </SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$dbca</SPAN></P> <OL> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">欢迎页面：选择</SPAN><SPAN style="FONT-FAMILY: Arial"> <STRONG><SPAN>Oracle Real Application Clusters database</SPAN></STRONG></SPAN><SPAN style="FONT-FAMILY: 宋体">。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">操作：选择</SPAN><SPAN style="FONT-FAMILY: Arial"> <STRONG><SPAN>Services Management</SPAN></STRONG></SPAN><SPAN style="FONT-FAMILY: 宋体">。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">集群数据库列表：单击</SPAN><SPAN style="FONT-FAMILY: Arial"> <STRONG><SPAN>Next</SPAN></STRONG></SPAN><SPAN style="FONT-FAMILY: 宋体">。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">数据库服务：单击</SPAN><SPAN style="FONT-FAMILY: Arial"> <STRONG><SPAN>Add</SPAN></STRONG></SPAN><SPAN style="FONT-FAMILY: 宋体">。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN> <UL> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">添加服务：输入</SPAN><SPAN style="FONT-FAMILY: Arial">“CRM”</SPAN><SPAN style="FONT-FAMILY: 宋体">。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN> <UL> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">选择</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN><SPAN style="FONT-FAMILY: 宋体">节点</SPAN><SPAN style="FONT-FAMILY: Arial">1 </SPAN><SPAN style="FONT-FAMILY: 宋体">的</SPAN><SPAN style="FONT-FAMILY: Arial">gemni </SPAN><SPAN style="FONT-FAMILY: 宋体">作为首选实例。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">选择</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN><SPAN style="FONT-FAMILY: 宋体">节点</SPAN><SPAN style="FONT-FAMILY: Arial">2 </SPAN><SPAN style="FONT-FAMILY: 宋体">的</SPAN><SPAN style="FONT-FAMILY: Arial">gemni </SPAN><SPAN style="FONT-FAMILY: 宋体">作为可用实例。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: Arial">TAF </SPAN><SPAN style="FONT-FAMILY: 宋体">策略：选择</SPAN><SPAN style="FONT-FAMILY: Arial"> <STRONG><SPAN>Basic</SPAN></STRONG></SPAN><SPAN style="FONT-FAMILY: 宋体">。</SPAN><SPAN style="FONT-FAMILY: Arial"> </SPAN></LI></UL> <LI style="COLOR: black; TEXT-ALIGN: left"><SPAN style="FONT-FAMILY: 宋体">单击</SPAN><SPAN style="FONT-FAMILY: Arial"> <STRONG><SPAN>Finish</SPAN></STRONG></SPAN><SPAN style="FONT-FAMILY: 宋体">。</SPAN><SPAN style="FONT-FAMILY: Arial"></SPAN></LI></UL></LI></OL> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">数据库配置助手将在</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> tnsnames.ora </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">中创建以下</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> CRM </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">服务名项：</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">CRM =</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>(DESCRIPTION =</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST = ds1-vip)(PORT = 1521))</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN>(ADDRESS = (PROTOCOL = TCP)(HOST = ds2-vip)(PORT = 1521))</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN>(LOAD_BALANCE = yes)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>(CONNECT_DATA =</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN>(SERVER = DEDICATED)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN>(SERVICE_NAME = CRM)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN>(FAILOVER_MODE =</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN></SPAN><SPAN> </SPAN>(TYPE = SELECT)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN></SPAN><SPAN> </SPAN>(METHOD = BASIC)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN></SPAN><SPAN> </SPAN>(RETRIES = 180)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN></SPAN><SPAN> </SPAN>(DELAY = 5)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN>)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN>)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN><SPAN> </SPAN>)</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在节点<SPAN>1</SPAN>上<SPAN>> </SPAN></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> connect system/oracle@gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Connected.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> show parameter service</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">NAME<SPAN> </SPAN>TYPE<SPAN> </SPAN>VALUE</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------------------------ ----------- ------------------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">service_names<SPAN> </SPAN>string<SPAN> </SPAN>gemni, CRM</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在节点<SPAN>2</SPAN>上<SPAN>> </SPAN>没有<SPAN>CRM</SPAN>服务<SPAN></SPAN></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> connect system/oracle@gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Connected.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> show parameter service</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">NAME<SPAN> </SPAN>TYPE<SPAN> </SPAN>VALUE</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------------------------ ----------- ------------------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">service_names<SPAN> </SPAN>string<SPAN> </SPAN><SPAN> </SPAN>gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">使用</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"> CRM </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">服务连接第一个会话。</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">如果</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> failover_type </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">和</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> failover_mode </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">返回的输出为</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">“NONE”</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">，则验证是否在</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> tnsnames.ora </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">中正确配置了</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> CRM </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">服务。</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> </SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> connect system/oracle@crm</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Connected.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>instance_number instance#,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>3<SPAN> </SPAN>instance_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>4<SPAN> </SPAN>host_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>5<SPAN> </SPAN>status</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>6<SPAN> </SPAN>from v$instance;</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>INSTANCE# INSTANCE_NAME<SPAN> </SPAN>HOST_NAME<SPAN> </SPAN>STATUS</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">---------- ---------------- --------------------- ------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>1 gemni<SPAN> </SPAN>ds1.mycorpdomain.com <SPAN> </SPAN>OPEN</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>failover_type,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>3<SPAN> </SPAN>failover_method,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>4<SPAN> </SPAN>failed_over</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>5<SPAN> </SPAN>from v$session</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>6<SPAN> </SPAN>where username='SYSTEM';</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------- --------------- ----------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SELECT<SPAN> </SPAN>BASIC<SPAN> </SPAN>NO</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">从其他会话中关闭该实例。</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG></P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> CRM </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">实例上以</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> sys </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">用户身份连接，并关闭该实例。</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> </SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$export ORACLE_SID=gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$sqlplus / as sysdba</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>instance_number instance#,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>3<SPAN> </SPAN>instance_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>4<SPAN> </SPAN>host_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>5<SPAN> </SPAN>status</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>6<SPAN> </SPAN>from v$instance;</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>INSTANCE# INSTANCE_NAME<SPAN> </SPAN>HOST_NAME<SPAN> </SPAN>STATUS</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">---------- ---------------- --------------------- ------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>1 gemni<SPAN> </SPAN>ds1.mycorpdomain.com <SPAN> </SPAN>OPEN</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> shutdown abort;<SPAN> </SPAN>//</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">注意测试切换，需要用<SPAN>abort</SPAN></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">ORACLE instance shut down.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">验证会话已经完成故障切换。</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG></P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">从您先前打开的同一</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> CRM </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">会话执行以下查询，以验证该会话已经故障切换到其他实例。</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> </SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>instance_number instance#,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>3<SPAN> </SPAN>instance_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>4<SPAN> </SPAN>host_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>5 <SPAN> </SPAN>status</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>6<SPAN> </SPAN>from v$instance;</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">INSTANCE# INSTANCE_NAME<SPAN> </SPAN>HOST_NAME<SPAN> </SPAN>STATUS</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">---------- ---------------- --------------------- ------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2 gemni<SPAN> </SPAN>ds2.mycorpdomain.com<SPAN> </SPAN><SPAN> </SPAN>OPEN</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>failover_type,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>3<SPAN> </SPAN>failover_method,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>4<SPAN> </SPAN>failed_over</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>5<SPAN> </SPAN>from v$session</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>6<SPAN> </SPAN>where username='SYSTEM';</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------- --------------- ----------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SELECT<SPAN> </SPAN>BASIC<SPAN> </SPAN>YES</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">将</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"> CRM </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">服务重新定位到首选实例。</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG></P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">恢复</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">节点</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">1 </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">之后，</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">CRM </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">服务不会自动重新定位到首选实例。您必须手动将服务重新定位到</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> </SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">节点</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">1</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">。</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial"> <SPAN></SPAN></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: Arial"><</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在节点</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">1</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">上</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$export ORACLE_SID=gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$sqlplus / as sysdba</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> startup</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">ORACLE instance started.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Total System Global Area<SPAN> </SPAN>209715200 bytes</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Fixed Size<SPAN> </SPAN>1218556 bytes</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Variable Size<SPAN> </SPAN>104859652 bytes</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Database Buffers<SPAN> </SPAN>100663296 bytes</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Redo Buffers<SPAN> </SPAN>2973696 bytes</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Database mounted.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Database opened.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> show parameter service</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">NAME<SPAN> </SPAN>TYPE<SPAN> </SPAN>VALUE</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------------------------ ----------- ------------------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">service_names<SPAN> </SPAN><SPAN> </SPAN>string<SPAN> </SPAN>gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: Arial"><</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在节点</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">2</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">上</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$export ORACLE_SID=gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$sqlplus / as sysdba</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> show parameter service</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">NAME<SPAN> </SPAN>TYPE<SPAN> </SPAN>VALUE</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------------------------ ----------- ------------------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">service_names<SPAN> </SPAN><SPAN> </SPAN>string<SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN>gemni, CRM</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: Arial"><</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在节点</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">1</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">上</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">$srvctl relocate service -d gemni -s crm -i ds2 -t ds1</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> connect system/oracle@gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Connected.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> show parameter service</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">NAME<SPAN> </SPAN>TYPE<SPAN> </SPAN>VALUE</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------------------------ ----------- ------------------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">service_names<SPAN> </SPAN>string<SPAN> </SPAN>gemni, CRM</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: Arial"><</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">在节点</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">2</SPAN><SPAN style="COLOR: black; FONT-FAMILY: 宋体">上</SPAN><SPAN style="COLOR: black; FONT-FAMILY: Arial">></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> connect system/oracle@gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Connected.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> show parameter service</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">NAME<SPAN> </SPAN>TYPE<SPAN> </SPAN>VALUE</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">------------------------------ ----------- ------------------------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">service_names<SPAN> </SPAN>string<SPAN> </SPAN>gemni</SPAN></P></DIV> <DIV></DIV>
查看全文
发表于:2008-01-30 ┆
阅读(368)
┆
评论(0)
Oracle 10g RAC 的部署5
<DIV><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>---------------------------------------------------------------</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Agent Version<SPAN> </SPAN>: 10.1.0.4.1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>OMS Version<SPAN> </SPAN>: 10.1.0.4.0</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Protocol Version<SPAN> </SPAN>: 10.1.0.2.0</FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">Agent Home<SPAN> </SPAN>: /u01/app/oracle/product/10.2.0/db_1/ds1_</SPAN><FONT size=3><SPAN>gemni</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"></SPAN></FONT></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Agent binaries<SPAN> </SPAN>: /u01/app/oracle/product/10.2.0/db_1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Agent Process ID<SPAN> </SPAN>: 10263</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Parent Process ID : 8171</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Agent URL<SPAN> </SPAN>: http://ds1.mycorpdomain.com:3938/emd/main</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Started at<SPAN> </SPAN>: 2006-11-12 08:10:01</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Started by user<SPAN> </SPAN>: oracle</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Last Reload<SPAN> </SPAN>: 2006-11-12 08:20:33</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Last successful upload<SPAN> </SPAN>: 2006-11-12 08:41:53</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Total Megabytes of XML files uploaded so far :<SPAN> </SPAN>4.88</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Number of XML files pending upload<SPAN> </SPAN>:<SPAN> </SPAN>0</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Size of XML files pending upload(MB)<SPAN> </SPAN>:<SPAN> </SPAN>0.00</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Available disk space on upload filesystem<SPAN> </SPAN>:<SPAN> </SPAN>71.53%</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>---------------------------------------------------------------</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Agent is Running and Ready</FONT></SPAN></PRE> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><B><SPAN style="FONT-SIZE: 12pt"><FONT face="Times New Roman">10 <SPAN> </SPAN>RAC</FONT></SPAN></B><B><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体">环境</SPAN></B><B><SPAN style="FONT-SIZE: 12pt"></SPAN></B></P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><STRONG><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial">(1) </SPAN></STRONG><STRONG><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体">检查应用程序资源的状态。</SPAN></STRONG><SPAN></SPAN></P> <P><B><SPAN><FONT face="Times New Roman">csr_stat <SPAN> </SPAN>-t</FONT></SPAN></B><B><SPAN style="FONT-FAMILY: 宋体">命令</SPAN></B><B><SPAN></SPAN></B></P><PRE><FONT size=3><FONT face=宋体><SPAN>$</SPAN><SPAN style="COLOR: black">crs_stat –t<SPAN> </SPAN>//</SPAN><SPAN style="COLOR: black">显示<SPAN>crs</SPAN>的状态<SPAN></SPAN></SPAN></FONT></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Name<SPAN> </SPAN><SPAN> </SPAN>Type<SPAN> </SPAN>Target<SPAN> </SPAN>State<SPAN> </SPAN>Host</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>------------------------------------------------------------</FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora.gemni.db<SPAN> </SPAN>application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds1<SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">数据库，节点<SPAN>1</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora....b1.inst application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds1<SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">实例，节点<SPAN>1</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora....b2.inst application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds2<SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">实例，节点<SPAN>2</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora....SM1.asm application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds1<SPAN> </SPAN>//asm</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">实例，节点<SPAN>1</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora....C1.lsnr application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds1<SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">监听，节点<SPAN>1</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora.ds1.gsd<SPAN> </SPAN>application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds1<SPAN> </SPAN>//gsd</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">，节点<SPAN>1</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora.ds1.ons<SPAN> </SPAN>application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds1<SPAN> </SPAN>//ons</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">，节点<SPAN>1</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora.ds1.vip<SPAN> </SPAN>application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds1<SPAN> </SPAN>//vip</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">，节点<SPAN>1</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora....SM2.asm application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds2<SPAN> </SPAN>//asm</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">实例，节点<SPAN>2</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora....C2.lsnr application<SPAN> </SPAN>ONLINE<SPAN> </SPAN><SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds2<SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">监听，节点<SPAN>2</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora.ds2.gsd<SPAN> </SPAN>application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds2<SPAN> </SPAN>//gsd, </SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">节点<SPAN>2</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora.ds2.ons<SPAN> </SPAN>application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds2<SPAN> </SPAN>//ons, </SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">节点<SPAN>2</SPAN></SPAN></FONT></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">ora.ds2.vip<SPAN> </SPAN>application<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ONLINE<SPAN> </SPAN>ds2<SPAN> </SPAN>//vip, </SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">节点<SPAN>2</SPAN></SPAN></FONT></PRE> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><B><SPAN><FONT face="Times New Roman">srvctl status nodeapps –n</FONT></SPAN></B><B><SPAN style="FONT-FAMILY: 宋体">命令</SPAN></B><B><SPAN></SPAN></B></P><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">$srvctl status nodeapps -n ds1<SPAN> </SPAN>//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">节点的状态<SPAN></SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>VIP is running on node: ds1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>GSD is running on node: ds1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Listener is running on node: ds1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>ONS daemon is running on node: ds1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN></FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$srvctl status nodeapps -n ds2</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>VIP is running on node: ds2</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>GSD is running on node: ds2</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Listener is running on node: ds2</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>ONS daemon is running on node: ds2</FONT></SPAN></PRE> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><B><SPAN style="COLOR: black"><FONT face="Times New Roman">srvctl status asm –n </FONT></SPAN></B><B><SPAN style="COLOR: black; FONT-FAMILY: 宋体">命令</SPAN></B><B><SPAN></SPAN></B></P><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$srvctl status asm -n ds1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>ASM instance +ASM1 is running on node ds1.</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$srvctl status asm -n ds2</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>ASM instance +ASM2 is running on node ds2.<SPAN> </SPAN></FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><FONT face=宋体><B><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">srvctl status database –d</SPAN></B><B><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">命令<SPAN></SPAN></SPAN></B></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$srvctl status database -d gemni</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Instance gemni is running on node ds1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Instance gemni is running on node ds2</FONT></SPAN></PRE> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><B><SPAN><FONT face="Times New Roman">(2) </FONT></SPAN></B><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">检查</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"> Oracle </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">集群件的状态。</SPAN></STRONG><SPAN></SPAN></P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$crsctl check crs</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>CSS appears healthy</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>CRS appears healthy</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>EVM appears healthy</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$crsctl check crs</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>CSS appears healthy</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>CRS appears healthy</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>EVM appears healthy</FONT></SPAN></PRE> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial">(3) </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">列出</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"> RAC </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">实例</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"><BR><BR></SPAN></STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>instance_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>3<SPAN> </SPAN>host_name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>4<SPAN> </SPAN>archiver,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>5<SPAN> </SPAN>thread#,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>6<SPAN> </SPAN>status</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>7<SPAN> </SPAN>from gv$instance;</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">INSTANCE_NAME<SPAN> </SPAN>HOST_NAME<SPAN> </SPAN>ARCHIVE<SPAN> </SPAN>THREAD# STATUS</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">-------------- --------------------- ------- -------- ------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">gemni<SPAN> </SPAN>ds1.mycorpdomain.com STARTED<SPAN> </SPAN>1 OPEN</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">gemni <SPAN> </SPAN>ds2.mycorpdomain.com STARTED<SPAN> </SPAN>2 OPEN</SPAN></P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial">(4) </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">检查连接</SPAN></STRONG><SPAN></SPAN></P> <P><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">验证您能够连接到每个节点上的实例和服务。</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black; FONT-FAMILY: Arial"> </SPAN></P><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>sqlplus system@gemni</FONT></SPAN></PRE> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P> <P style="TEXT-INDENT: -18pt"><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"><SPAN>(5)<SPAN style="FONT: 7pt 'Times New Roman'"> </SPAN></SPAN></SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">检查数据库配置</SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN></STRONG></P> <P><SPAN><FONT face="Times New Roman"></FONT></SPAN> </P><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$export ORACLE_SID=gemni</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$sqlplus / as sysdba</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">显示<SPAN>sga</SPAN>参数<SPAN></SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>SQL> show sga</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Total System Global Area<SPAN> </SPAN>209715200 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Fixed Size<SPAN> </SPAN>1218556 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Variable Size<SPAN> </SPAN>104859652 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Database Buffers<SPAN> </SPAN>100663296 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Redo Buffers<SPAN> </SPAN>2973696 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">显示数据库物理文件的位置<SPAN></SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>SQL> select file_name,bytes/1024/1024 from dba_data_files;</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>FILE_NAME<SPAN> </SPAN>BYTES/1024/1024</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>------------------------------------------- ---------------</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>+DG1/gemni/datafile/users.259.606468449<SPAN> </SPAN>5</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>+DG1/gemni/datafile/sysaux.257.606468447<SPAN> </SPAN>240</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>+DG1/gemni/datafile/undotbs1.258.606468449<SPAN> </SPAN>30</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>+DG1/gemni/datafile/system.256.606468445<SPAN> </SPAN>480</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>+DG1/gemni/datafile/undotbs2.264.606468677<SPAN> </SPAN>25</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN></FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">显示<SPAN>redo</SPAN>文件的组和位置信息<SPAN></SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>SQL> select</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> 2<SPAN> </SPAN>group#,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> 3<SPAN> </SPAN>type,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> 4<SPAN> </SPAN>member,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> 5<SPAN> </SPAN>is_recovery_dest_file</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> 6<SPAN> </SPAN>from v$logfile</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>7<SPAN> </SPAN>order by group#;</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>GROUP# TYPE<SPAN> </SPAN>MEMBER<SPAN> </SPAN>IS_</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>------ ------- --------------------------------------------------- ---</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN><SPAN> </SPAN>1 ONLINE<SPAN> </SPAN>+RECOVERYDEST/gemni/onlinelog/group_1.257.606468581 YES</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>1 ONLINE<SPAN> </SPAN>+DG1/gemni/onlinelog/group_1.261.606468575<SPAN> </SPAN>NO</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN><SPAN> </SPAN>2 ONLINE<SPAN> </SPAN>+RECOVERYDEST/gemni/onlinelog/group_2.258.606468589 YES</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>2 ONLINE<SPAN> </SPAN>+DG1/gemni/onlinelog/group_2.262.606468583<SPAN> </SPAN>NO</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>3 ONLINE<SPAN> </SPAN>+DG1/gemni/onlinelog/group_3.265.606468865<SPAN> </SPAN>NO</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN><SPAN> </SPAN>3 ONLINE<SPAN> </SPAN>+RECOVERYDEST/gemni/onlinelog/group_3.259.606468875 YES</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>4 ONLINE<SPAN> </SPAN>+DG1/gemni/onlinelog/group_4.266.606468879<SPAN> </SPAN>NO</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN><SPAN> </SPAN>4 ONLINE<SPAN> </SPAN>+RECOVERYDEST/gemni/onlinelog/group_4.260.606468887 YES</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><FONT face=宋体><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">//</SPAN><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">显示<SPAN>asm</SPAN>实例的参数<SPAN></SPAN></SPAN></FONT></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$export ORACLE_SID=+ASM1</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$sqlplus / as sysdba</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>SQL> show sga</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Total System Global Area<SPAN> </SPAN>92274688 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Fixed Size<SPAN> </SPAN>1217884 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>Variable Size<SPAN> </SPAN>65890980 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>ASM Cache<SPAN> </SPAN>25165824 bytes</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>$show parameter asm_disk</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>NAME<SPAN> </SPAN>TYPE<SPAN> </SPAN>VALUE</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>------------------------------ ----------- ------------------------</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>asm_diskgroups<SPAN> </SPAN>string<SPAN> </SPAN>DG1, RECOVERYDEST</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>asm_diskstring<SPAN> </SPAN><SPAN> </SPAN>string</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>SQL> select</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>2<SPAN> </SPAN>group_number,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>3<SPAN> </SPAN>name,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>4<SPAN> </SPAN>allocation_unit_size alloc_unit_size,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>5<SPAN> </SPAN>state,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>6<SPAN> </SPAN>type,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>7<SPAN> </SPAN>total_mb,</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>8<SPAN> </SPAN>usable_file_mb</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>9<SPAN> </SPAN>from v$asm_diskgroup;</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>ALLOC<SPAN> </SPAN>USABLE</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> GROUP<SPAN> </SPAN>UNIT<SPAN> </SPAN>TOTAL<SPAN> </SPAN>FILE</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>NUMBER NAME<SPAN> </SPAN>SIZE STATE<SPAN> </SPAN>TYPE<SPAN> </SPAN>MB<SPAN> </SPAN>MB</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体>------ ------------ -------- ------- ------ ------ -------</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>1 DG1<SPAN> </SPAN>1048576 MOUNTED NORMAL<SPAN> </SPAN>6134<SPAN> </SPAN>1868</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体><SPAN> </SPAN>2 RECOVERYDEST<SPAN> </SPAN>1048576 MOUNTED EXTERN<SPAN> </SPAN>2047<SPAN> </SPAN>1713</FONT></SPAN></PRE><PRE><SPAN style="FONT-SIZE: 10.5pt; COLOR: black"><FONT face=宋体> </FONT></SPAN></PRE> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>name,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>3<SPAN> </SPAN>path,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>4<SPAN> </SPAN>header_status,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>5<SPAN> </SPAN>total_mb free_mb,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>6<SPAN> </SPAN>trunc(bytes_read/1024/1024) read_mb,</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>7<SPAN> </SPAN>trunc(bytes_written/1024/1024) write_mb</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>8<SPAN> </SPAN>from v$asm_disk;</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">NAME<SPAN> </SPAN>PATH<SPAN> </SPAN>HEADER_STATU<SPAN> </SPAN><SPAN> </SPAN>FREE_MB<SPAN> </SPAN>READ_MB<SPAN> </SPAN>WRITE_MB</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">----- ---------- ------------ ---------- ---------- ----------</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">VOL1<SPAN> </SPAN>ORCL:VOL1<SPAN> </SPAN>MEMBER<SPAN> </SPAN>3067<SPAN> </SPAN>229<SPAN> </SPAN>1242</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">VOL2<SPAN> </SPAN>ORCL:VOL2<SPAN> </SPAN>MEMBER<SPAN> </SPAN>3067<SPAN> </SPAN>164<SPAN> </SPAN>1242</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">VOL3<SPAN> </SPAN>ORCL:VOL3<SPAN> </SPAN>MEMBER<SPAN> </SPAN><SPAN> </SPAN>2047<SPAN> </SPAN>11<SPAN> </SPAN>354</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial">(6) </SPAN></STRONG><STRONG><SPAN style="COLOR: black; FONT-FAMILY: 宋体">创建表空间。</SPAN></STRONG><SPAN style="COLOR: black; FONT-FAMILY: Arial"> <SPAN></SPAN></SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: Arial"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> connect system/oracle@gemni</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Connected.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> create tablespace test_d datafile '+DG1' size 10M;</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">Tablespace created.</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"></SPAN> </P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体">SQL> select</SPAN></P> <P style="TEXT-ALIGN: left" align=left><SPAN style="COLOR: black; FONT-FAMILY: 宋体"><SPAN> </SPAN>2<SPAN> </SPAN>file_name,</SPAN></P> <P style="TEXT-ALIG
