{"id":814,"date":"2013-04-08T23:38:42","date_gmt":"2013-04-08T15:38:42","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=814"},"modified":"2013-04-08T23:38:42","modified_gmt":"2013-04-08T15:38:42","slug":"dg%e5%85%b3%e4%ba%8easm%e7%9b%ae%e5%bd%95%e5%90%8c%e6%ad%a5%e7%9a%84%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=814","title":{"rendered":"DG\u5173\u4e8eASM\u76ee\u5f55\u540c\u6b65\u7684\u95ee\u9898"},"content":{"rendered":"

DG\u5173\u4e8eASM\u76ee\u5f55\u540c\u6b65\u7684\u95ee\u9898
\n\u7b2c\u4e00\u79cd\uff1a\u5728sql*plus\u4e2d\u4f7f\u7528sql\u521b\u5efa\u76ee\u5f55\uff0c\u67e5\u770b\u662f\u5426\u540c\u6b65\u5230\u5907\u5e93<\/strong>
\n\u4e3b\u5e93<\/p>\n

\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/users01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/datafile\/yallonking.432.812066619\r\n+DATA\/racdb\/yallonking_2.dbf\r\n\r\n7 rows selected.\r\n<\/pre>\n
\u5907\u5e93<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\n\/u01\/app\/oracle\/oradata\/datafile\/yallonking.432.812066619\r\n\/u01\/app\/oracle\/oradata\/yallonking_2.dbf\r\n\r\n7 rows selected.\r\n\r\n<\/pre>\n
\u4e3b\u5e93\u64cd\u4f5c<\/p>\n
\r\nSQL> create tablespace cfca datafile '+DATA\/racdb_p\/yallonking_2.dbf' size 1m;\r\ncreate tablespace cfca datafile '+DATA\/racdb_p\/yallonking_2.dbf' size 1m\r\n*\r\nERROR at line 1:\r\nORA-01119: error in creating database file '+DATA\/racdb_p\/yallonking_2.dbf'\r\nORA-17502: ksfdcre:4 Failed to create file +DATA\/racdb_p\/yallonking_2.dbf\r\nORA-15173: entry 'racdb_p' does not exist in directory '\/'\r\n\r\n\r\nSQL> alter diskgroup data add directory '+data\/racdb_p';\r\n\r\nDiskgroup altered.\r\n\r\nSQL> create tablespace cfca datafile '+DATA\/racdb_p\/yallonking_2.dbf' size 1m;\r\n\r\nTablespace created.\r\n\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n------------------------------------------------------------------------------------------------------------------------------------\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/users01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/datafile\/yallonking.432.812066619\r\n+DATA\/racdb\/yallonking_2.dbf\r\n+DATA\/racdb_p\/yallonking_2.dbf\r\n\r\n8 rows selected.\r\n<\/pre>\n
\u5907\u5e93\u67e5\u770b<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n------------------------------------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\n\/u01\/app\/oracle\/oradata\/datafile\/yallonking.432.812066619\r\n\/u01\/app\/oracle\/oradata\/yallonking_2.dbf\r\n\/u01\/app\/oracle\/oradata_p\/yallonking_2.dbf\r\n\r\n8 rows selected.\r\n\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u6b64\u5904\u5728\u4e3b\u5e93\u901a\u8fc7sql\u521b\u5efa\u7684asm\u76ee\u5f55\u540e\uff0c\u4f1a\u81ea\u52a8\u540c\u6b65\u5230\u5907\u5e93\u5e76\u5728\u5907\u5e93\u521b\u5efa\u76f8\u5173\u76ee\u5f55\u3002<\/p>\n
\u7b2c\u4e8c\u79cd\uff1a\u5728ASM\u4e2d\u4f7f\u7528ASMCMD\u547d\u4ee4\u521b\u5efa\u76ee\u5f55\uff0c\u67e5\u770b\u662f\u5426\u540c\u6b65\u5230\u5907\u5e93<\/strong>
\n\u4e3b\u5e93<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/users01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/datafile\/yallonking.432.812066619\r\n+DATA\/racdb\/yallonking_2.dbf\r\n\r\n7 rows selected.\r\n\r\n<\/pre>\n
\u5907\u5e93<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\n\/u01\/app\/oracle\/oradata\/datafile\/yallonking.432.812066619\r\n\/u01\/app\/oracle\/oradata\/yallonking_2.dbf\r\n\r\n7 rows selected.\r\n\r\n<\/pre>\n
\u4e3b\u5e93\u64cd\u4f5c<\/p>\n
\r\nSQL> create tablespace cfca datafile '+DATA\/racdb_p\/yallonking_2.dbf' size 1m;\r\ncreate tablespace cfca datafile '+DATA\/racdb_p\/yallonking_2.dbf' size 1m\r\n*\r\nERROR at line 1:\r\nORA-01119: error in creating database file '+DATA\/racdb_p\/yallonking_2.dbf'\r\nORA-17502: ksfdcre:4 Failed to create file +DATA\/racdb_p\/yallonking_2.dbf\r\nORA-15173: entry 'racdb_p' does not exist in directory '\/'\r\n\r\n[grid@11grac1 ~]$ asmcmd\r\nASMCMD> ls\r\nDATA\/\r\nASMCMD> cd data\r\nASMCMD> ls\r\nRACDB\/\r\nracscan\/\r\nASMCMD> pwd    \r\n+data\r\nASMCMD> mkdir racdb_p\r\nASMCMD> ls\r\nRACDB\/\r\nracdb_p\/\r\nracscan\/\r\n<\/pre>\n
\u6b64\u523b\u5728\u4e3b\u5e93\u7ee7\u7eed\u4e4b\u524d\u7684\u521b\u5efasql<\/p>\n
\r\nSQL> \/\r\n\r\nTablespace created.\r\n\r\n<\/pre>\n
\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n
\r\n<msg time='2013-04-08T23:15:12.090+08:00' org_id='oracle' comp_id='rdbms'\r\n msg_id='opiexe:2994:4222364190' client_id='' type='NOTIFICATION'\r\n group='admin_ddl' level='16' host_id='11grac1'\r\n host_addr='192.168.137.161' module='sqlplus@11grac1 (TNS V1-V3)' pid='6524'>\r\n <txt>create tablespace cfca datafile &apos;+DATA\/racdb_p\/yallonking_2.dbf&apos; size 1m\r\n <\/txt>\r\n<\/msg>\r\n<msg time='2013-04-08T23:15:49.869+08:00' org_id='oracle' comp_id='rdbms'\r\n msg_id='opiexe:3065:2802784106' client_id='' type='NOTIFICATION'\r\n group='admin_ddl' level='16' host_id='11grac1'\r\n host_addr='192.168.137.161' module='sqlplus@11grac1 (TNS V1-V3)' pid='6524'>\r\n <txt>Completed: create tablespace cfca datafile &apos;+DATA\/racdb_p\/yallonking_2.dbf&apos; size 1m\r\n <\/txt>\r\n<\/msg>\r\n\r\n<\/pre>\n
\u67e5\u770b\u4e3b\u5e93\u65b0\u7684\u6587\u4ef6<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/users01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/datafile\/yallonking.432.812066619\r\n+DATA\/racdb\/yallonking_2.dbf\r\n+DATA\/racdb_p\/yallonking_2.dbf\r\n\r\n8 rows selected.\r\n\r\n<\/pre>\n
\u4e3b\u5e93\u5207\u6362\u65e5\u5fd7\u540e\u67e5\u770b\u5907\u5e93<\/p>\n
\u5907\u5e93\u67e5\u770b<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n------------------------------------------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\n\/u01\/app\/oracle\/oradata\/datafile\/yallonking.432.812066619\r\n\/u01\/app\/oracle\/oradata\/yallonking_2.dbf\r\n\/u01\/app\/oracle\/oradata_p\/yallonking_2.dbf\r\n\r\n8 rows selected.\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u6b64\u5904\u5728\u4e3b\u5e93\u901a\u8fc7ASMCMD\u521b\u5efa\u7684asm\u76ee\u5f55\u540e\uff0c\u4e5f\u4f1a\u81ea\u52a8\u540c\u6b65\u5230\u5907\u5e93\u5e76\u5728\u5907\u5e93\u521b\u5efa\u76f8\u5173\u76ee\u5f55\u3002<\/p>\n
\u5c0f\u7ed3\uff1a\u65e0\u8bba\u5728\u4e3b\u5e93\u662f\u4ecesql*plus\u547d\u4ee4\u884c\u7528sql\u8fd8\u662f\u5728ASMCMD\u547d\u4ee4\u884c\u7528\u547d\u4ee4\u521b\u5efa\u7684\u76ee\u5f55\uff0c\u90fd\u4f1a\u540c\u6b65\u5230\u5907\u5e93\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
DG\u5173\u4e8eASM\u76ee\u5f55\u540c\u6b65\u7684\u95ee\u9898 \u7b2c\u4e00\u79cd\uff1a\u5728sql*plus\u4e2d\u4f7f\u7528sql\u521b\u5efa\u76ee\u5f55\uff0c\u67e5\u770b\u662f\u5426\u540c\u6b65\u5230\u5907\u5e93 \u4e3b\u5e93 SQL […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[178,176,177],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/814"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=814"}],"version-history":[{"count":1,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/814\/revisions"}],"predecessor-version":[{"id":815,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/814\/revisions\/815"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=814"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}