{"id":925,"date":"2017-12-14T14:55:00","date_gmt":"2017-12-14T06:55:00","guid":{"rendered":"http:\/\/www.langmanezhuang.com\/index.php\/2017\/12\/14\/oracle%e8%a7%a3%e5%86%b3ora-01653%e6%97%a0%e6%b3%95%e6%89%a9%e5%b1%95%e8%a1%a8%e7%a9%ba%e9%97%b4%e9%97%ae%e9%a2%98\/"},"modified":"2017-12-14T14:55:00","modified_gmt":"2017-12-14T06:55:00","slug":"oracle%e8%a7%a3%e5%86%b3ora-01653%e6%97%a0%e6%b3%95%e6%89%a9%e5%b1%95%e8%a1%a8%e7%a9%ba%e9%97%b4%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"http:\/\/blog.langmanezhuang.com\/index.php\/2017\/12\/14\/oracle%e8%a7%a3%e5%86%b3ora-01653%e6%97%a0%e6%b3%95%e6%89%a9%e5%b1%95%e8%a1%a8%e7%a9%ba%e9%97%b4%e9%97%ae%e9%a2%98\/","title":{"rendered":"Oracle\u89e3\u51b3Ora-01653\u65e0\u6cd5\u6269\u5c55\u8868\u7a7a\u95f4\u95ee\u9898"},"content":{"rendered":"

\u5148\u9488\u5bf9\u53ef\u80fd\u60271\u67e5\u770b\u8868\u7a7a\u95f4\u4f7f\u7528\u60c5\u51b5 <\/span><\/p>\n

\n
SELECT<\/span> UPPER<\/span>(F.TABLESPACE_NAME) \"\u8868\u7a7a\u95f4\u540d\",\n       D.TOT_GROOTTE_MB \"\u8868\u7a7a\u95f4\u5927\u5c0f(M) \",\n       D.TOT_GROOTTE_MB <\/span>-<\/span> F.TOTAL_BYTES \"\u5df2\u4f7f\u7528\u7a7a\u95f4(M)\",\n       TO_CHAR(<\/span>ROUND<\/span>((D.TOT_GROOTTE_MB -<\/span> F.TOTAL_BYTES) \/<\/span> D.TOT_GROOTTE_MB *<\/span> 100<\/span>,\n                     <\/span>2<\/span>),\n               <\/span>'<\/span>990.99<\/span>'<\/span>) \"\u4f7f\u7528\u6bd4\",\n       F.TOTAL_BYTES \"\u7a7a\u95f2\u7a7a\u95f4(M) \",\n       F.MAX_BYTES \"\u6700\u5927\u5757(M) \"\n  <\/span>FROM<\/span> (SELECT<\/span> TABLESPACE_NAME,\n               <\/span>ROUND<\/span>(SUM<\/span>(BYTES) \/<\/span> (1024<\/span> *<\/span> 1024<\/span>), 2<\/span>) TOTAL_BYTES,\n               <\/span>ROUND<\/span>(MAX<\/span>(BYTES) \/<\/span> (1024<\/span> *<\/span> 1024<\/span>), 2<\/span>) MAX_BYTES\n          <\/span>FROM<\/span> SYS.DBA_FREE_SPACE\n         <\/span>GROUP<\/span> BY<\/span> TABLESPACE_NAME) F,\n       (<\/span>SELECT<\/span> DD.TABLESPACE_NAME,\n               <\/span>ROUND<\/span>(SUM<\/span>(DD.BYTES) \/<\/span> (1024<\/span> *<\/span> 1024<\/span>), 2<\/span>) TOT_GROOTTE_MB\n          <\/span>FROM<\/span> SYS.DBA_DATA_FILES DD\n         <\/span>GROUP<\/span> BY<\/span> DD.TABLESPACE_NAME) D\n <\/span>WHERE<\/span> D.TABLESPACE_NAME =<\/span> F.TABLESPACE_NAME\n <\/span>ORDER<\/span> BY<\/span> 4<\/span> DESC<\/span><\/pre>\n<\/div>\n
\"\"<\/p>\n
\u901a\u8fc7\u4e0a\u8868\u6211\u4eec\u53ef\u4ee5\u770b\u51fa\uff0c\u8868\u7a7a\u95f4***_TRD\u7684\u8868\u7a7a\u95f4\u7684\u7a7a\u95f4\u4f7f\u7528\u7387\u5df2\u7ecf\u8fbe\u523099.6%\uff0c\u53ea\u5269\u4e0b133.88M\u53ef\u7528\uff0c\u800c\u5176\u7d22\u5f15\u7a7a\u95f4 ***_TRD_IDX\u7684\u7a7a\u95f4\u4f7f\u7528\u7387\u66f4\u662f\u8fbe\u5230\u4e8699.97%\uff0c\u53ea\u5269\u4e0b4.94M\u53ef\u7528\u3002<\/p>\n
\n
SELECT<\/span> T.TABLESPACE_NAME,\n       D.<\/span>FILE_NAME<\/span>,\n       D.AUTOEXTENSIBLE,\n       D.BYTES,\n       D.MAXBYTES,\n       D.STATUS\n  <\/span>FROM<\/span> DBA_TABLESPACES T, DBA_DATA_FILES D\n <\/span>WHERE<\/span> T.TABLESPACE_NAME =<\/span> D.TABLESPACE_NAME\n <\/span>ORDER<\/span> BY<\/span> TABLESPACE_NAME, FILE_NAME<\/span>;<\/pre>\n<\/div>\n
\"\"<\/p>\n
 <\/p>\n
\u4ece\u4e0a\u8868\u53ef\u4ee5\u770b\u51fa\uff0c\u6240\u6709\u7684\u8868\u7a7a\u95f4\u90fd\u5f00\u542f\u4e86\u81ea\u52a8\u6269\u5c55\u7684\u529f\u80fd\uff0c\u800c\u4e14\u72b6\u6001\u90fd\u662favailable\u7684\u3002<\/p>\n
 \u7efc\u5408\u4e0a\u8ff0\u68c0\u67e5\u7ed3\u679c\uff0c\u53ef\u65ad\u5b9a\u9047\u5230\u7684\u95ee\u9898\u662f\u56e0\u4e3a\u53ef\u80fd\u60271—\u8868\u7a7a\u95f4\u4e0d\u8db3\u5bfc\u81f4\u3002\u89e3\u51b3\u529e\u6cd5\u4e5f\u5c31\u662f\u6269\u5927\u8868\u7a7a\u95f4\u3002<\/p>\n
 <\/p>\n
\u6269\u5927\u8868\u7a7a\u95f4\u7684\u56db\u79cd\u65b9\u6cd5\uff1a 
1\u3001\u589e\u52a0\u6570\u636e\u6587\u4ef6 
ALTER TABLESPACE ***_TRD ADD DATAFILE 
‘D:ORACLEPRODUCT10.2.0ORADATADBFILETRD_2.DBF’ SIZE 1024M;<\/span><\/span><\/span><\/p>\n
2\u3001\u589e\u52a0\u6570\u636e\u6587\u4ef6\u5e76\u5141\u8bb8\u81ea\u52a8\u589e\u957f 
ALTER TABLESPACE ***_TRD ADD DATAFILE 
‘D:ORACLEPRODUCT10.2.0ORADATADBFILETRD_2.DBF’ SIZE 1024M AUTOEXTEND ON NEXT 8M MAXSIZE 10240M;<\/span><\/span><\/p>\n
3\u3001\u5141\u8bb8\u5df2\u5b58\u5728\u7684\u6570\u636e\u6587\u4ef6\u81ea\u52a8\u589e\u957f 
ALTER DATABASE DATAFILE ‘D:ORACLEPRODUCT10.2.0ORADATADBFILETRD.DBF’ 
AUTOEXTEND ON NEXT 8M MAXSIZE 10240M;<\/span><\/span><\/p>\n
4\u3001\u624b\u5de5\u6539\u53d8\u5df2\u5b58\u5728\u6570\u636e\u6587\u4ef6\u7684\u5927\u5c0f 
ALTER DATABASE DATAFILE ‘D:ORACLEPRODUCT10.2.0ORADATADBFILETRD.DBF’ 
RESIZE 10240M;<\/span><\/span><\/p>\n
\u5b9e\u9645\u89e3\u51b3\u8fc7\u7a0b\u4e2d\uff0c\u6211\u4eec\u4f7f\u7528\u7684\u662f\u65b9\u6cd52\u3002<\/p>\n
\u5bf9\u4e8e\u5177\u4f53\u7684\u9879\u76ee\uff0c\u9700\u8981\u6839\u636e\u8868\u7a7a\u95f4\u4e2d\u5404\u4e2a\u8868\u7684\u5b9e\u9645\u60c5\u51b5\u6765\u786e\u5b9a\u5177\u4f53\u90a3\u79cd\u65b9\u6cd5\u6700\u4f18\uff0c\u5728\u6b64\u4e0d\u505a\u8fdb\u4e00\u6b65\u9610\u8ff0\u3002<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u5148\u9488\u5bf9\u53ef\u80fd\u60271\u67e5\u770b\u8868\u7a7a\u95f4\u4f7f\u7528\u60c5\u51b5  SELECT UPPER(F.TABLESPACE_NAME)  … \u7ee7\u7eed\u9605\u8bfb Oracle\u89e3\u51b3Ora-01653\u65e0\u6cd5\u6269\u5c55\u8868\u7a7a\u95f4\u95ee\u9898<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/925"}],"collection":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/comments?post=925"}],"version-history":[{"count":0,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/925\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/media?parent=925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/categories?post=925"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/tags?post=925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}