{"rsdb":{"rid":"158023","subhead":"","postdate":"0","aid":"118481","fid":"57","uid":"1","topic":"1","content":"

\u91cd\u8981\u8bf4\u660e\uff1a\u7531\u4e8e\u672c\u6587\u7531\u672c\u4eba\u6d4b\u8bd5\u5e76\u5b8c\u6210\uff0c\u5176\u4e2d\u53ef\u80fd\u8fd8\u6709\u4e0d\u8db3\u4e4b\u5904\uff0c\u53e6\u5916\u4e0d\u540c\u7684\u73af\u5883\u53ef\u80fd\u4e5f\u6709\u4e0d\u540c\u7684\u89e3\u51b3\u65b9\u6cd5\uff0c\u672c\u6587\u4ec5\u4f9b\u53c2\u8003\uff0c\u5e76\u6b22\u8fce\u6307\u8bc1<\/strong><\/span><\/strong><\/p>

\u95ee\u9898\u63cf\u8ff0\uff1a<\/strong><\/p>

1\u3001\u67e5\u8be2sga\u5927\u5c0f<\/p>

2\u3001\u4fee\u6539sga\u5927\u5c0f\u4e3a500M<\/p>

3\u3001\u56e0\u4e3a\u662f\u6307\u5b9a\u53c2\u6570\u4e3aspfile\uff0c\u56e0\u6b64\u8981\u91cd\u542finstance\u624d\u80fd\u4f7f\u53c2\u6570\u751f\u6548<\/p>

4\u3001\u91cd\u542finstance \u65f6\uff0c\u63d0\u793asga\u6700\u5c0f\u503c\u5e94\u8be5\u4e3a668M

<\/p>

\u89e3\u51b3\u7ec6\u8def\uff1a<\/strong><\/p>

\u9996\u5148\u6211\u4eec\u8981\u7406\u89e3\u4e00\u4e0boracle\u6570\u636e\u5e93\u5728\u542f\u52a8\u8fc7\u7a0b\u4e2d\u8c03\u7528 \u7684\u53c2\u6570\uff0c\u5176\u987a\u5e8f\u4e3a\uff1a<\/p>

spfilesid.ora -> spfile.ora ->initsid.ora-> init.ora  \u4ece\u8fd9\u6761\u542f\u52a8\u7ebf\u6765\u8bf4\uff0c\u5982\u679c\u7b2c\u4e00\u4e2aspfilesid.ora\u6587\u4ef6\u627e\u4e0d\u5230\u7684\u8bdd\uff0c\u5b83\u4f1a\u627e\u5230\u4e8c\u4e2aspfile.ora\u6587\u4ef6\uff0c\u5982\u679c\u80fd\u627e\u5230\u5c31\u80fd\u6b63\u5e38\u542f\u52a8\uff0c\u82e5\u627e\u4e0d\u5230\uff0c\u518d\u7ee7\u7eed\u627e\u4e0b\u4e00\u4e2ainitsid.ora\u6587\u4ef6\uff0c\u4e00\u76f4\u627e\u5230\u6700\u540e\u4e00\u4e2ainit.ora\u6587\u4ef6\uff0c\u8bf4\u660e\uff1a\u5982\u679c\u627e\u5230\u5176\u4e2d\u4e00\u4e2a\u5219\u4f1a\u6b63\u5e38\u542f\u52a8instance<\/p>

\u89e3\u51b3\u65b9\u6cd5\uff1a<\/strong><\/p>

\u901a\u8fc7\u521b\u5efapfile\u6587\u4ef6\u65b9\u5f0f\u6765\u542f\u52a8\u6570\u636e\u5e93\uff0c\u7136\u540e\u518d\u4ee5pfile\u6587\u4ef6\u4e3a\u6a21\u677f\u521b\u5efaspfile,\u5177\u4f53\u6b65\u9aa4\u662f\uff1a<\/p>

1\u3001\u4ee5spfile\u6a21\u677f\u521b\u5efapfile\u6587\u4ef6\uff0c\u5e76\u6307\u5b9a\u8def\u5f84\u4e3a\u672c\u5730\u786c\u76d8\u4f4d\u7f6e<\/p>

create pfile='\/oracle\/initudevasm.ora' from spfile='+DGDATA02\/udevasm\/spfileudevasm.ora';<\/p>

2\u3001\u4fee\u6539initudevasm.ora\u6587\u4ef6\uff0c\u627e\u5230sga_target\u5b57\u6bb5\uff0c\u4fee\u6539\u5927\u4e8e668M<\/span><\/p>

vi \/oracle\/initudevasm.ora<\/p>

udevasm.__db_cache_size=826277888
udevasm.__java<\/a>_pool_size=4194304
udevasm.__large_pool_size=8388608
udevasm.__oracle_base='\/oracle\/app\/oracle'#ORACLE_BASE set from environment
udevasm.__pga_aggregate_target=629145600
udevasm.__sga_target=1073741824
udevasm.__shared_io_pool_size=0
udevasm.__shared_pool_size=222298112
udevasm.__streams_pool_size=0
*.audit_file_dest='\/oracle\/app\/oracle\/admin\/udevasm\/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='+DGDATA02\/udevasm\/controlfile\/current.256.945212019'
*.db_block_size=8192
*.db_create_file_dest='+DGDATA02'
*.db_domain=''
*.db_name='udevasm'
*.db_recovery_file_dest_size=3221225472
*.diagnostic_dest='\/oracle\/app\/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=udevasmXDB)'
udevasm.log_archive_dest_1='LOCATION=+DGRECOVERY\/'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=629145600
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=170
*.sga_target=754288000  --\u5927\u4e8e668M<\/span>
*.undo_tablespace='UNDOTBS1'
3\u3001\u4ee5pfile\u6587\u4ef6\u542f\u52a8instance<\/p>

4\u3001\u4ee5pfile\u6587\u4ef6\u4e3a\u6a21\u677f\u521b\u5efaspfile\u6587\u4ef6<\/p>

5\u3001\u5173\u95ed\u5b9e\u4f8b\uff0c\u5e76\u91cd\u65b0\u542f\u52a8spfile,\u56e0\u4e3a\u5728\u5728\u521b\u5efaspfile\u65f6\u5df2\u7ecf\u9ed8\u8ba4\u6307\u5b9a\u539f\u6765\u7684\u8def\u5f84\uff0c\u5e76\u628a\u539f\u6765\u7684spfile\u6587\u4ef6\u8986\u76d6\u4e86\uff0c\u6240\u4ee5\u53ea\u8981\u76f4\u63a5\u542f\u52a8\u5373\u53ef<\/p>

6\u3001\u67e5\u8be2\u4fee\u6539\u540e\u7684sga\u5927\u5c0f<\/p>

\u901a\u8fc7\u4e0a\u9762\u67e5\u8be2\u5219\u5224\u65ad\u5df2\u7ecf\u4fee\u6539???\u6062\u590d\u6210\u529f<\/p>

\u603b\u7ed3\uff1a<\/strong><\/p>

    1\u3001\u5f53\u6570\u636e\u5e93\u53d1\u751f\u56e0\u4e3a\u6709\u5173\u53c2\u6570\u6587\u4ef6\u5f02\u5e38\u65e0\u6cd5\u542f\u52a8\u6b63\u5e38\u65f6\uff0c\u53ef\u4ee5\u5148\u628a\u539f\u7406\u7406\u89e3\uff0c\u7136\u540e\u901a\u8fc7\u521b\u5efapfile\u4e0espfile\u6587\u4ef6\u65b9\u5f0f\u89e3\u51b3\u542f\u52a8\u95ee\u9898\u3002<\/p>

    2\u3001\u8981\u5907\u4efd\u6709\u5173\u6570\u636e\u5e93\u53c2\u6570\u6587\u4ef6\u4ee5\u9632\u6b62\u8bef\u64cd\u4f5c\u5bfc\u81f4\u6570\u636e\u5e93\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8<\/p>","orderid":"0","title":"Oracle\u5b9e\u4f8b\u5173\u95ed\u65f6\u4fee\u6539spfile\u7684\u53c2\u6570","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"7756","pages":"1","comments":"0","posttime":"2017-07-14 10:22:58","list":"1499998978","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"Oracle<\/A> \u5b9e\u4f8b<\/A> \u5173\u95ed<\/A> \u4fee\u6539<\/A> spfile<\/A> \u53c2\u6570<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"218.17.197.194","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Oracle\u5b9e\u4f8b\u5173\u95ed\u65f6\u4fee\u6539spfile\u7684\u53c2\u6570","lastview":"1703109338","digg_num":"5366","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}