{"id":413,"date":"2013-10-08T09:48:56","date_gmt":"2013-10-08T18:48:56","guid":{"rendered":"\/blog\/?p=413"},"modified":"2023-09-21T09:38:51","modified_gmt":"2023-09-21T00:38:51","slug":"oracle-%ed%8c%8c%eb%9d%bc%eb%a9%94%ed%84%b0-%ed%8c%8c%ec%9d%bc-%ec%a0%95%eb%a6%acspfile-pfile","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=413","title":{"rendered":"Oracle \ud30c\ub77c\uba54\ud130 \ud30c\uc77c \uc815\ub9ac(spfile, pfile)"},"content":{"rendered":"\n<p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ucd9c\ucc98 : <\/span><a class=\"tx-link\" target=\"_blank\" href=\"http:\/\/estenpark.tistory.com\/294\" rel=\"noopener\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">http:\/\/estenpark.tistory.com\/294<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"><\/span><\/p><p style=\"PAGE-BREAK-AFTER: avoid\" ><span style=\"FONT-SIZE: 14pt\"><span style=\"font-size: 18pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">1.&nbsp;\ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uac1c\ub150\uacfc \uc885\ub958<\/span><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><\/p><div style=\"BORDER-BOTTOM: #cbcbcb 1px solid; BORDER-LEFT: #cbcbcb 1px solid; PADDING-BOTTOM: 10px; BACKGROUND-COLOR: #071a30; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; BORDER-TOP: #cbcbcb 1px solid; BORDER-RIGHT: #cbcbcb 1px solid; PADDING-TOP: 10px\" class=\"txc-textbox\"><font style=\"BACKGROUND-COLOR: #576fbd\" color=\"#ffffff\"><span style=\"font-size: 12pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[1-1 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uac1c\ub150]<\/span><\/font><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n \uc624\ub77c\ud074\uc5d0\uc11c \ub9d0\ud558\ub294 \ud544\uc218 \ud30c\uc77c \uc911\uc5d0\uc11c \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc740 \uc624\ub77c\ud074\uc774 \uad6c\ub3d9 \ud560 \uc218 \uc788\uac8c \uc124\uacc4\ub418\uc5b4 \uc788\ub294&nbsp;\ub3c4\uba74\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ud55c\uac00\uc9c0 \uc608\ub85c \n\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uae30\ub3d9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc744 \ucc38\uc870\ud558\uc5ec SGA \ubc0f \uae30\ud0c0 \ud544\uc694\ud55c \ud658\uacbd\uc744 \uad6c\uc131 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">shutdown(\uc885\ub8cc\uc0c1\ud0dc) -&gt; \ud30c\ub77c\uba54\ud130 \ud30c\uc77c \uc77d\uae30(spfile\/pfile) -&gt; NOMOUNT \ub2e8\uacc4\ubcc4\ub85c \n\uc62c\ub77c\uc624\ub294\ub370 \uc5ec\uae30\uc5d0\uc11c \ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c\uc744 \uac00\uc7a5 \uc911\uc694\ud55c \uc5ed\ud65c\uc744 \ud558\uac8c \ub429\ub2c8\ub2e4. \ub9cc\uc57d \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc774 \uc5c6\uc744 \uacbd\uc6b0\uc5d0\ub294 \"could not \nopen parameter file '\uacbd\ub85c \ubc0f \ud30c\uc77c\uc774\ub984' \" \uc5d0\ub7ec\uac00 \ubc1c\uc0dd \ub429\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ubcf8 \ubb38\uc11c\uc5d0\uc11c\ub294 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uc804\uccb4\uc801\uc778 \uc124\uba85 \ubcf4\ub2e4\ub294 \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub294\uc9c0\uc640 \uac01 \ud30c\uc77c\uc758 \ud2b9\uc131\uc744 \ubd84\uc11d \ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[1-2 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uc885\ub958]<\/span><\/font><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc815\uc801 \ud30c\ub77c\uba54\ud130(initSID.ora) <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><ul style=\"LIST-STYLE-TYPE: disc\"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc624\ub77c\ud074 \ubaa8\ub4e0 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\uac00\ub2a5(8i ~)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc73c\ub85c OS Edit\ub97c \uc774\uc6a9\ud558\uc5ec \ubcc0\uacbd \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uad00\ub828 \ubdf0 : V$PARAMETER<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ub3d9\uc801 \ud30c\ub9c8\uba54\ud130\uc758 \uc885\ub958\ub294 \uc801\uc74c<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ub3d9\uc801 \ud30c\ub77c\uba54\ud130(spfileSID.ora) <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><ul style=\"LIST-STYLE-TYPE: disc\"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc624\ub77c\ud074&nbsp;\ud2b9\uc815 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uac00\ub2a5(9i ~)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ubc14\uc774\ub108\ub9ac \ud615\uc2dd\uc73c\ub85c OS Edit\ub97c \uc774\uc6a9\ud558\uc5ec \ubcc0\uacbd \ubd88\uac00\ub2a5(vi\ub97c \uc774\uc6a9\ud574\uc11c \ub098\uc624\ub294&nbsp;\uacb0\uacfc\ub294&nbsp;\ubc14\uc774\ub108\ub9ac\uac00 \uc544\ub2d9\ub2c8\ub2e4.)<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uad00\ub828 \ubdf0 : V$SPPARAMETER <\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ub3d9\uc801 \ud30c\ub9c8\uba54\ud130\uc758 \uc885\ub958\ub294 \ub9ce\uc74c<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">pfile\uacfc spfile\uc758 \uac00\uc7a5 \ud070 \ucc28\uc774\uc810\uc740 pfile\uc740 OS\uc5d0\uc11c vi \n\ud3b8\uc9d1\uae30\ub97c \uc774\uc6a9\ud558\uc5ec \ud30c\ub77c\uba54\ud130\uc758 \uac12\uc744 \ubcc0\uacbd \ud560 \uc218 \uc788\uace0&nbsp;\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 NOMOUNT&nbsp;\ub2e8\uacc4&nbsp;\uc774\uc0c1\uc774\ub77c\uba74 \ub2e4\uc2dc pfile\uc744 \uc4f0\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.\n \uacb0\uacfc\uc801\uc73c\ub85c \ud30c\uc77c\uc744 \uc9c0\uc6cc\ub3c4 \uc544\ubb34 \uc774\uc0c1 \uc5c6\uc2b5\ub2c8\ub2e4. \uc2dc\uc2a4\ud15c \ub808\ubca8\uc5d0\uc11c \ubcc0\uacbd\uc740 \ub418\uc9c0\ub9cc \uba54\ubaa8\ub9ac\uc5d0\uc11c \uc7a0\uae50 \uc0ac\uc6a9\ud558\uace0 \ubc84\ub9ac\uac8c \ub418\ub294 \uac83\uc785\ub2c8\ub2e4. \n\uc544\ub798 \uc790\uc138\ud788 \uc124\uba85 \ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\ubc18\ub300\ub85c spfile\uc740 OS\uc5d0\uc11c vi \ud3b8\uc9d1\uae30\ub85c \uc808\ub300 \uc218\uc815\uc744 \ud558\uba74 \uc548\ub418\uba70 NOMOUNT \ub2e8\uacc4 \uc774\uc0c1\uc774\ub77c\uba74 spfile\uc744 \ub2e4\uc2dc \uc4f0\uae30 \ub54c\ubb38\uc81c \uc81c\uac70 \ud558\uac70\ub098 \uc774\ub3d9\ud558\uba74 \uc548\ub429\ub2c8\ub2e4.&nbsp;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ucc38\uace0\ub85c \uc2dc\uc2a4\ud15c \ub808\ubca8\uc740 \uc544\ub798\uc5d0\uc11c \uc124\uba85\ud558\uaca0\uc9c0\ub9cc&nbsp;\ud30c\ub77c\uba54\ud130\ub97c&nbsp;\uc124\uc815 \ubcc0\uacbd\uc740 \uc870\uac74\uc5d0 \ub530\ub77c\uc11c&nbsp;pfile, spfile \ubaa8\ub450 \uac00\ub2a5 \ud569\ub2c8\ub2e4. <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SPFILE : ALTER SYSTEM SET [\ud30c\ub77c\uba54\ud130\uc774\ub984=values] [SCOPE=(MEMORY\/SPFILE\/BOTH)]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nPFILE&nbsp;&nbsp; : ALTER SYSTEM SET [\ud30c\ub77c\uba54\ud130\uc774\ub984=values] [SCOPE=(MEMORY)]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><p style=\"PAGE-BREAK-AFTER: avoid\" ><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 14pt\"><span style=\"font-size: 18pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">2.&nbsp;\ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uad00\ub9ac<\/span><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><div style=\"BORDER-BOTTOM: #cbcbcb 1px solid; BORDER-LEFT: #cbcbcb 1px solid; PADDING-BOTTOM: 10px; BACKGROUND-COLOR: #071a30; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; BORDER-TOP: #cbcbcb 1px solid; BORDER-RIGHT: #cbcbcb 1px solid; PADDING-TOP: 10px\" class=\"txc-textbox\"><font style=\"BACKGROUND-COLOR: #576fbd\" color=\"#ffffff\"><span style=\"font-size: 12pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2-1 \ud30c\ub77c\uba54\ud130 \uacbd\ub85c]<\/span><\/font><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uacbd\ub85c\ub294 \uae30\ubcf8\uc801\uc73c\ub85c $ORALE_HOME\/dbs \uc5d0 \uc788\uc2b5\ub2c8\ub2e4.&nbsp;\uc624\ub77c\ud074 9i \ubd80\ud130\ub294 \uc544\ub798 \uc21c\uc11c\uc640 \uac19\uc774 search\ub97c \ud558\uac8c \ub429\ub2c8\ub2e4.<\/span><br \/><span id=\"callbacknestestenparktistorycom2944542\" style=\"width:1px; height:1px; float:right\"><\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2011-01-26 02:17:46]-[oracle@calmmass:~\/product\/10g\/dbs]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ ls -l<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n1.spfiletestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n2.spfile.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n3.inittestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n4.init.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2-2 \ub3d9\uc801 \ud30c\ub77c\uba54\ud130 \uc0ac\uc6a9(SPFILE)]<\/span><\/font><\/span><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> <\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc900\n\ube44 \uc0ac\ud56d\uc740 $ORACLE_HOME\/dbs\/spfiletestdb.ora&nbsp; \uc874\uc7ac \ud574\uc57c \ud569\ub2c8\ub2e4. \uc704 search \uc21c\uc11c\ub97c \ud655\uc778 \ud558\uc168\ub2e4\uba74\n initSID.ora \ud30c\uc77c\uc774 \uc788\uc5b4\ub3c4 \uc0c1\uad00 \uc5c6\uc2b5\ub2c8\ub2e4. spfileSID.ora \ud30c\uc77c\uc774 \uc788\ub2e4\uba74 pfile(initSID.ora)\uc758 \n\ub0b4\uc6a9\uc740 \uc808\ub300 \ubc18\uc601 \ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><\/font><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2011-01-26 02:34:28]-[oracle@calmmass:~\/product\/10g\/dbs]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ ls -al spfile*<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n-rw-r-----&nbsp; 1 oracle dba 2560&nbsp; 1\uc6d4 26 02:17 spfiletestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc624\ud508\ud558\uc9c0 \uc54a\uace0 NOMOUNT \ub2e8\uacc4\uc5d0\uc11c \uc0c1\ud0dc\ub97c \ud655\uc778 \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; startup nomount<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ud604\uc7ac \uc0c1\ud0dc\uac00&nbsp;pfile\uc778\uc9c0&nbsp;spfile\uc778\uc9c0 \ud655\uc778 \ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc774 VALUE\uc5d0 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0\uc5d0\ub294&nbsp;spfile\uc774\uace0 \ub9cc\uc57d&nbsp;VALUE\uc5d0 \uac12\uc774 \uc5c6\ub2e4\uba74&nbsp;pfile\uc774 \ub429\ub2c8\ub2e4.&nbsp;<\/span><\/font><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/span><font size=\"2\"><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; show parameter pfile<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><font color=\"#ffffff\"><font size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n---------------------------------------------------------------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nspfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/product\/10g\/dbs\/spfiletestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ub610 \ub2e4\ub978 \ud655\uc778 \ubc29\ubc95\uc73c\ub85c\ub294 \ud604\uc7ac \ud30c\ub77c\uba54\ud130\ub97c \uba87\uac1c\ub098 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uc9c0 \ud655\uc778 \ud574\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; select isspecified ,count(value) from v$spparameter group by isspecified;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/span><\/font><\/font><font color=\"#ffffff\"><font size=\"2\"><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ISSPECIFIED&nbsp; COUNT(VALUE)<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n------------ ------------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFALSE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">TRUE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2-3&nbsp;\uc815\uc801 \ud30c\ub77c\uba54\ud130 \uc0ac\uc6a9(PFILE)]<\/span><\/font><\/span><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> <\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc900\ube44 \uc0ac\ud56d\uc740 $ORACLE_HOME\/dbs\/inittestdb.ora \uc874\uc7ac \ud574\uc57c \ud569\ub2c8\ub2e4. \uc704 search \uc21c\uc11c\ub97c \ud655\uc778 \ud558\uc168\ub2e4\uba74 spfiletestdb.ora, spfile.ora&nbsp;\ud30c\uc77c\uc744 \uc81c\uac70 \ud558\uc154\uc57c \ud569\ub2c8\ub2e4. <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[2011-01-26 03:09:54]-[oracle@calmmass:~\/product\/10g\/dbs]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ ls -al initt*<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n-rw-r--r--&nbsp; 1 oracle dba 1089&nbsp; 1\uc6d4 25 17:47 inittestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc624\ud508\ud558\uc9c0 \uc54a\uace0 NOMOUNT \ub2e8\uacc4\uc5d0\uc11c \uc0c1\ud0dc\ub97c \ud655\uc778 \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; startup nomount<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ud604\uc7ac \uc0c1\ud0dc\uac00&nbsp;pfile\uc778\uc9c0&nbsp;spfile\uc778\uc9c0 \ud655\uc778 \ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc774 VALUE\uc5d0 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0\uc5d0\ub294&nbsp;spfile\uc774\uace0 \ub9cc\uc57d&nbsp;VALUE\uc5d0 \uac12\uc774 \uc5c6\ub2e4\uba74&nbsp;pfile\uc774 \ub429\ub2c8\ub2e4.&nbsp;<\/span><\/font><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; show parameter pfile;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/span><\/font><\/font><font color=\"#ffffff\"><font size=\"2\"><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp;&nbsp; VALUE<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n-----------------------------------------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nspfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ub610 \ub2e4\ub978 \ud655\uc778 \ubc29\ubc95\uc73c\ub85c\ub294 \ud604\uc7ac \ud30c\ub77c\uba54\ud130\ub97c \uba87\uac1c\ub098 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uc9c0 \ud655\uc778 \ud574\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; select isdefault ,count(value) from v$parameter group by isdefault<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/span><\/font><\/font><font color=\"#ffffff\"><font size=\"2\"><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ISDEFAULT&nbsp;&nbsp;&nbsp; COUNT(VALUE)<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n------------------ ------------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFALSE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nTRUE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 168<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2-4&nbsp;\ud30c\ub77c\uba54\ud130 \ud30c\uc77c \uc0dd\uc131]<\/span><\/font><\/span><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \uc815\uc801 \ud30c\ub77c\uba54\ud130\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc885\ub8cc \uc0c1\ud0dc\uc5d0\uc11c\ub3c4 \uac00\ub2a5 \ud558\uc9c0\ub9cc \ub3d9\uc801 \ud30c\ub77c\uba54\ud130\uc758 \uacbd\uc6b0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 NOMOUNT \ub2e8\uacc4 \uc774\uc0c1\uc5d0\uc11c \uc0dd\uc131\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\uc815\uc801 \ud30c\ub77c\uba54\ud130\uc758 \uacbd\uc6b0 - \ubc29\ubc95 1<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nshow parameter dump \ub85c \ud655\uc778\ud558\uc5ec \ub364\ud504 \ud30c\uc77c\uc774 \uacbd\ub85c\ub97c \ud655\uc778 \ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c \ub364\ud504\ud30c\uc77c\uacfc \ub3d9\uc77c\ud55c \ub514\ub809\ud1a0\ub9ac\uc5d0 \npfile \ub514\ub809\ud1a0\ub9ac\uac00 \uc788\uc2b5\ub2c8\ub2e4. init.ora.2322 \ud30c\uc77c\uc744 \uae30\uc874 pfile($ORACLE_HOME\/dbs) \uc704\uce58\ub85c \ubcf5\uc0ac\ud558\uba74 \n\ub429\ub2c8\ub2e4. \uc624\ub77c\ud074 \uacf5\uc778 \ubb38\uc11c\uc5d0\uc11c\ub294 $ORACLE_HOME\/dbs \ub514\ub809\ud1a0\ub9ac\uc758 init.ora \ud30c\uc77c\ub85c \ubcc0\uacbd \ud558\ub77c\uace0 \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \n\uadf8\ub9d0\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc62c\ub9ac\uc9c0 \ub9d0\ub77c\ub294 \uac83\uacfc \uac19\uc740 \uc774\uc57c\uae30 \uc785\ub2c8\ub2e4. \uc0c1\ub2f9\ud788 \ubd88\ud3b8\ud558\uae30 \ub54c\ubb38\uc5d0 \uc544\ub798\uc640 \uac19\uc740 \uc791\uc5c5\uc744 \ud558\uc2dc\uae38 \uad8c\uc7a5\ud569\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[2011-01-26 04:12:08]-[oracle@calmmass:~\/admin\/testdb\/pfile]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ cp init.ora.010201115288 $ORACLE_HOME\/dbs<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\uc815\uc801 \ud30c\ub77c\uba54\ud130\uc758 \uacbd\uc6b0 - \ubc29\ubc95 2<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nNOMOUNT&nbsp;\ub2e8\uacc4 \uc774\uc0c1\uc5d0\uc11c \uc0dd\uc131 \ud569\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; create pfile from spfile;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ub3d9\uc801 \ud30c\ub77c\uba54\ud130\uc758 \uacbd\uc6b0<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nNOMOUNT \ub2e8\uacc4 \uc774\uc0c1\uc5d0\uc11c \uc0dd\uc131 \ud569\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; create spfile from pfile;<\/span><\/font><\/font><\/font><\/font><\/font><\/span><\/font><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><p style=\"PAGE-BREAK-AFTER: avoid\" ><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"FONT-SIZE: 14pt\"><span style=\"font-size: 18pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">3.&nbsp;\uc2dc\uc2a4\ud15c \ub808\ubca8(ALTER SYSTEM SET)&nbsp;<\/span><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><div style=\"BORDER-BOTTOM: #cbcbcb 1px solid; BORDER-LEFT: #cbcbcb 1px solid; PADDING-BOTTOM: 10px; BACKGROUND-COLOR: #071a30; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; BORDER-TOP: #cbcbcb 1px solid; BORDER-RIGHT: #cbcbcb 1px solid; PADDING-TOP: 10px\" class=\"txc-textbox\"><font style=\"BACKGROUND-COLOR: #576fbd\" color=\"#ffffff\"><span style=\"font-size: 12pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[3-1 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uac12 \ubcc0\uacbd]<\/span><\/font><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \uc0ac\uc6a9 \ubc29\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ALTER SYSTEM SET \ud30c\ub77c\uba54\ud130 \uc774\ub984=\ud30c\ub77c\uba54\ud130 \uac12<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[COMMENT='text']<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[SCOPE=MEMORY\/SPFILE\/BOTH]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[SID='sid'\/'*']<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\ud30c\ub77c\uba54\ud130 \uc124\uc815&nbsp;\uc8fc\uc11d\uc744 \ucd94\uac00\ud558\ub294&nbsp;<\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">COMMENT <\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc635\uc158<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><ul style=\"LIST-STYLE-TYPE: disc\"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ub3d9\uc801 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uc124\uc815 \uac12\uc744 \ud574\ub2f9 \uba85\ub839\uc5b4\ub85c \ubcc0\uacbd\uc2dc \uc8fc\uc11d\uc744 \ucd94\uac00\ud560 \uc218 \uc788\uac8c \ud558\ub294 \uc635\uc158 \uc785\ub2c8\ub2e4. \ud30c\ub77c\uba54\ud130 \uc124\uc815 \uac12 \ubcc0\uacbd\uc2dc \uc774\ub825 \uad00\ub9ac \ubc0f \ud2b9\uc774 \uc0ac\ud56d\uc744 \uba54\ubaa8\ud560 \ud544\uc694\uac00 \uc788\uc744 \uacbd\uc6b0 \uc0ac\uc6a9 \ud569\ub2c8\ub2e4.<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ud30c\ub77c\uba54\ud130 \uc124\uc815 \ubcc0\uacbd\ud558\ub294 <\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SCOPE <\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc635\uc158<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><ul style=\"LIST-STYLE-TYPE: disc\"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ud30c\ub77c\uba54\ud130\uc758 \uc124\uc815\uc744 \ubcc0\uacbd \ud558\ub294\ub370 \uc788\uc5b4\uc11c \uac00\uc7a5 \ud070 \uc5ed\ud65c\uc744 \ud558\ub294 \uc635\uc158\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4. \ub3d9\uc801 \ud30c\ub77c\uba54\ud130(spfile)\uc640 \uc815\uc801 \n\ud30c\ub77c\uba54\ud130(pfile) \uc911 \uc5b4\ub5a4 \ubc29\uc2dd\uc73c\ub85c \uae30\ub3d9 \ub418\uc5c8\ub294\uc9c0\uc5d0 \ub530\ub77c\uc11c \ubc29\ubc95\uc758 \ucc28\uc774\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc778 \uac1c\ub150\uc740 \uc815\uc801 \ud30c\ub77c\uba54\ud130\ub294 \nMEMORY \uc635\uc158\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uace0, \uc815\uc801 \ud30c\ub77c\uba54\ud130\ub294 \uc635\uc158 \ubaa8\ub450 \uc0ac\uc6a9 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">MEMORY : \ud30c\ub77c\uba54\ud130 \uc124\uc815 \uac12 \ubcc0\uacbd\uc744 \uba54\ubaa8\ub9ac\uc5d0\uc11c\ub9cc \uc801\uc6a9\ud558\ub294 \uc758\ubbf8\ub85c \uc885\ub8cc \ud6c4 \uc7ac\uae30\ub3d9 \ud560 \uacbd\uc6b0 MEMORY \uc635\uc158\uc73c\ub85c \ubcc0\uacbd \ub41c \ud30c\ub77c\uba54\ud130 \uac12\uc740 \ubc14\ub00c\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SPFILE : \ud30c\ub77c\uba54\ud130 \uc124\uc815 \uac12\uc744 \ubcc0\uacbd \ud558\ub418 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc7ac\uae30\ub3d9 \ud6c4 \ubcc0\uacbd \ud569\ub2c8\ub2e4. \uc2e4\uc81c\uc801\uc73c\ub85c \ud604\uc7ac \uba54\ubaa8\ub9ac \uc0c1\uc5d0\uc11c\ub294 \uae30\uc874\uc758 \uac12\uc744 \uc720\uc9c0 \ud558\uac8c \ub418\uace0 \uc7ac\uae30\ub3d9 \ud6c4\uc5d0\ub294 \ubcc0\uacbd \ub41c \uac12\uc744 \uc815\uc0c1\uc801\uc73c\ub85c \uc0ac\uc6a9 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">BOTH : \uc5b4\ub824\uc6b4 \uc635\uc158\uc785\ub2c8\ub2e4. \uc65c\ub0d0\ud558\uba74 MEMORY + SPFILE \ub450\uac00\uc9c0\uc758 \uc635\uc158\uc744 \ubaa8\ub450 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\ub807\ub2e4\uba74 \uc815\uc801 \n\ud30c\ub77c\uba54\ud130\uc5d0\uc11c \ud574\ub2f9 \uc635\uc158\uc744 \uc808\ub300 \uc0ac\uc6a9 \ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\uc720\ub294 \uc704\uc5d0\uc11c \uc124\uba85 \ud55c \uac83\uacfc \uac19\uc774 PFILE\uc5d0 \uacb0\uacfc \uac12\uc744 \uc4f0\uc9c0 \uc54a\uae30 \n\ub54c\ubb38\uc785\ub2c8\ub2e4. PFILE\ub294 DBA(\uad00\ub9ac\uc790)\uac00 \uc9c1\uc811 \uc218\uc815\ud558\ub294 \uc124\uc815 \ud30c\uc77c \uc785\ub2c8\ub2e4. \ub2e4\uc2dc \ub9d0\ud574\uc11c \ub3d9\uc801 \ud30c\ub77c\uba54\ud130\ub97c \uc704\ud55c \uc635\uc158\uc774\ub77c\uace0 \uc0dd\uac01 \n\ud558\uc154\ub3c4 \ub429\ub2c8\ub2e4. <\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ud30c\ub77c\uba54\ud130 \uc124\uc815 \ubcc0\uacbd\ud558\ub294 <\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SCOPE <\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc635\uc158\uc744 \uc774\uc6a9\ud558\uc5ec \ubcc0\uacbd \uac00\ub2a5\ud55c \ud30c\ub77c\uba54\ud130\uc640 \ubcc0\uacbd \ubd88 \uac00\ub2a5\ud55c \ud30c\ub77c\uba54\ud130 \ud30c\uc545<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><ul style=\"LIST-STYLE-TYPE: disc\"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">IMMEDIATE : \uc989\uc2dc \uc801\uc6a9\uc774 \uac00\ub2a5\ud55c \ud30c\ub77c\uba54\ud130 MEMORY\/SPFILE\/BOTH \ubaa8\ub450 \uc0ac\uc6a9 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">DEFERRED&nbsp; : \ud604\uc7ac \uc811\uc18d \uc911\uc778 \uc138\uc158\uc740 \uc801\uc6a9 \ud558\uc9c0 \uc54a\uace0 \ub2e4\uc74c \uc138\uc158 \ubd80\ud130 \uc801\uc6a9\ud558\ub294 \ud30c\ub77c\uba54\ud130\ub85c\uc368 MEMORY\/SPFILE\/BOTH \ubaa8\ub450 \uc0ac\uc6a9 \uac00\ub2a5<\/span><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">FALSE : \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc7ac \uae30\ub3d9\ud574\uc57c \uc801\uc6a9 \uac00\ub2a5 \ud55c \uac83\uc73c\ub85c \uc624\uc9c1 SPFILE\ub9cc \uc0ac\uc6a9 \uac00\ub2a5(Static Parameter)<\/span><\/li><\/ul><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\uc815\uc801 \ud30c\ub77c\uba54\ud130(pfile) \ucffc\ub9ac\ub97c \uc774\uc6a9\ud558\uc5ec \uc0ac\uc6a9 \uc720\ubb34\ub97c \ud655\uc778 <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt;&nbsp;&nbsp; <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nSELECT ISSYS_MODIFIABLE ,COUNT(*)<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFROM v$parameter<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nGROUP BY ISSYS_MODIFIABLE;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ISSYS_MODIFIABLE&nbsp;&nbsp;&nbsp;&nbsp; COUNT(*)<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n------------------ ----------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDEFERRED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFALSE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nIMMEDIATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 145<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ub3d9\uc801\ud30c\ub77c\uba54\ud130(spfile) \ucffc\ub9ac\ub97c \uc774\uc6a9\ud558\uc5ec \uc0ac\uc6a9 \uc720\ubb34\ub97c \ud655\uc778<\/span><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt;&nbsp;&nbsp; <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nSELECT b.ISSYS_MODIFIABLE, COUNT(*)<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFROM v$spparameter a, v$parameter b<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nWHERE a.name = b.name<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nGROUP BY b.ISSYS_MODIFIABLE;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ISSYS_MODIFIABLE&nbsp;&nbsp;&nbsp;&nbsp; COUNT(*)<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n------------------ ----------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDEFERRED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFALSE&nbsp;&nbsp;&nbsp;&nbsp; 108<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nIMMEDIATE&nbsp;&nbsp;&nbsp; 145<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\ud30c\ub77c\uba54\ud130 \uc124\uc815 \ubcc0\uacbd\ud558\ub294&nbsp;<\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SID <\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc635\uc158<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><ul style=\"LIST-STYLE-TYPE: disc\"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc624\ub77c\ud074 RAC(Real Application Cluster)\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ubcc0\uacbd\ub41c \ud30c\ub77c\uba54\ud130 \uac12\uc774 \uc801\uc6a9\ub420 \ub178\ub4dc\ub97c \uc120\ud0dd\ud558\ub294 \n\uc635\uc158\uc785\ub2c8\ub2e4. \uae30\ubcf8 \uac12\uc740'*'\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \ubaa8\ub4e0 \ub178\ub4dc\uc5d0 \ubcc0\uacbd\ub41c \uc124\uc815 \uac12\uc744 \uc801\uc6a9\ud569\ub2c8\ub2e4. \ud2b9\uc815 \ub178\ub4dc\uc5d0\ub9cc \uc801\uc6a9\ud574\uc57c \ud560 \uacbd\uc6b0 \ud574\ub2f9 \n\uc778\uc2a4\ud134\uc2a4 \ubc88\ud638\ub97c \uc124\uc815 \ud574\uc8fc\uba74 \ub429\ub2c8\ub2e4.<\/span><\/li><\/ul><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">testdb.<\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">__<\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">db_cache_size=180355072\n \uc5d0\uc11c __\uc758\ubbf8\ub294 spfile\uc5d0\uc11c pfile\ub85c \ucd94\ucd9c\ud560\ub54c ASM\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4\uba74 \ud604\uc7ac SGA\uc758 COMPONENT \uac12\uc744 \uc758\ubbf8 \n\ud569\ub2c8\ub2e4.&nbsp; ASM\uc744 \uc0ac\uc6a9\ud558\uac8c \ub418\uba74 SGA\ub294 \ub3d9\uc801\uc73c\ub85c \ud06c\uae30\uac00 \ubcc0\ud558\ub294\ub370 spfile\uc5d0\uc11c pfile\uc744 \uc0dd\uc131\uc2dc \uac12\uc744 \uc758\ubbf8 \ud569\ub2c8\ub2e4. \ubcc4 \n\uc758\ubbf8\ub294 \uc5c6\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nselect component, current_size\/1024\/1024 \"current\", min_size\/1024\/1024 \"min\", user_specified_size\/1024\/1024 \"user\",<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n&nbsp; granule_size\/1024\/1024 \"granule\"<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nfrom v$sga_dynamic_components;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><\/font><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">*.<\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">db_block_size=8192 \uc774\uc640 \uac19\uc740 \uac12\uc774 \ubcf4\uc774\ub294\ub370, <\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">*<\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc2ec\ubcfc\uc740 rac\uc5d0\uc11c \uc801\uc6a9\uac00\ub2a5\ud558\uac8c \ub610\ub294 \uad6c\ubd84 \uac00\ub2a5\ud558\ub3c4\ub85d\ub514\uc790\uc778\ub41c \uc18d\uc131\uac12\uc774\ub77c \ud560 \uc218\uc788\uc2b5\ub2c8\ub2e4. (* = all instance)<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><\/font><\/font><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><p style=\"PAGE-BREAK-AFTER: avoid\" ><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"FONT-SIZE: 14pt\"><span style=\"font-size: 18pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">4.&nbsp;\ubcf5\uad6c \uc2dc\ub098\ub9ac\uc624&nbsp;<\/span><\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><div style=\"BORDER-BOTTOM: #cbcbcb 1px solid; BORDER-LEFT: #cbcbcb 1px solid; PADDING-BOTTOM: 10px; BACKGROUND-COLOR: #071a30; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; BORDER-TOP: #cbcbcb 1px solid; BORDER-RIGHT: #cbcbcb 1px solid; PADDING-TOP: 10px\" class=\"txc-textbox\"><font style=\"BACKGROUND-COLOR: #576fbd\" color=\"#ffffff\"><span style=\"font-size: 12pt; font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[4-1 \uc0c1\ud669 1]<\/span><\/font><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc885\ub8cc \uc0c1\ud0dc\uc5d0\uc11c DBA(\uad00\ub9ac\uc790) \uc2e4\uc218\ub85c spfile, pfile \ubaa8\ub450&nbsp;\uc0ad\uc81c \ud588\uc744 \uacbd\uc6b0 \ubcf5\uad6c \ubc29\ubc95&nbsp;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\uc704\uc5d0\uc11c \uc124\uba85\ud55c \uac83\uacfc \uac19\uc774 $ORACLE_BASE\/admin\/testdb\/pfile\uc744 $ORACLE_HOME\/dbs\ub85c \ud30c\uc77c\uc744 \ubcf5\uc0ac \ud55c \ud6c4 DB\ub97c OPEN \ud558\uba74 \ub429\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2011-01-26 04:44:58]-[oracle@calmmass:~\/product\/10g\/dbs]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ ls<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nbackup&nbsp; hc_testdb.dat&nbsp; initdw.ora&nbsp; lkTESTDB&nbsp; orapwtestdb<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2011-01-26 04:44:58]-[oracle@calmmass:~\/product\/10g\/dbs]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ sqlplus \/ as sysdba<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; startup<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nORA-01078: failure in processing system parameters<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nLRM-00109: could not open parameter file '\/home\/oracle\/product\/10g\/dbs\/inittestdb.ora'<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2011-01-26 04:46:54]-[oracle@calmmass:~\/admin\/testdb\/pfile]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ cp init.ora.010201115288 $ORACLE_HOME\/dbs\/inittestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\uc9c0\uae08 \ubd80\ud130 \ubcf5\uad6c\ub97c \uc2dc\uc791 \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ud30c\uc77c\uc744 \ubcf5\uc0ac\ud569\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n[2011-01-26 04:46:54]-[oracle@calmmass:~\/admin\/testdb\/pfile]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ cp init.ora.010201115288 $ORACLE_HOME\/dbs\/inittestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2011-01-26 04:47:24]-[oracle@calmmass:~\/product\/10g\/dbs]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ ls<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nbackup&nbsp; hc_testdb.dat&nbsp; initdw.ora&nbsp; inittestdb.ora&nbsp; lkTESTDB&nbsp; orapwtestdb<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[2011-01-26 04:48:56]-[oracle@calmmass:~]<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ sqlplus \/ as sysdba<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><\/font><font color=\"#ffffff\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; <\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ub370\uc774\ud130\ud30c\uc77c\uc744 OPEN \ud558\uae30 \uc774\uc804\uc5d0 Controlfile\uc758 \uacbd\ub85c\uac00 \ub9de\ub294\uc9c0 \ubc1b\ub4dc\uc2dc \ud655\uc778 \ud569\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n$ vi inittestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">###########################################<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n# File Configuration<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n###########################################<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font color=\"#ff8b16\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">control_files=( '\/home\/oracle\/oradata\/testdb\/control01.ctl',&nbsp;&nbsp;&nbsp;&nbsp;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '\/home\/oracle\/oradata\/testdb\/control03.ctl')<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\uc544\ub798\uc640 \uac19\uc774 startup\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc815\uc0c1\uc801\uc73c\ub85c OPEN \ub418\uc5b4\uc11c \ubcf5\uad6c \uc644\ub8cc \uc785\ub2c8\ub2e4.<\/span><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; startup<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nORACLE instance started.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><\/font><font color=\"#ffffff\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Total System Global Area&nbsp; 285212672 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFixed Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1267068 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nVariable Size&nbsp;&nbsp;&nbsp;&nbsp; 92277380 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDatabase Buffers&nbsp;&nbsp; 188743680 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nRedo Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2924544 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDatabase mounted.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDatabase opened.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; show parameter pfile;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><\/font><font color=\"#ffffff\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n----------------------------------------------------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nspfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><span style=\"FONT-SIZE: 12pt\"><font style=\"BACKGROUND-COLOR: #576fbd\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[4-2 \uc0c1\ud669 2]<\/span><\/font><\/span><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\ud604\uc7ac \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc740&nbsp;pfile \uc785\ub2c8\ub2e4. \uace0\uac1d\uc0ac\uc5d0\uc11c pfile\uc744 spfile\ub85c \ubcc0\uacbd \ud574\ub2ec\ub77c\uace0 \uc694\uccad\uc774 \uc654\uc2b5\ub2c8\ub2e4. &nbsp;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><font style=\"BACKGROUND-COLOR: #576fbd\" size=\"3\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">[\uc124\uba85]<\/span><\/font><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;\uc774 \ubc29\ubc95\uc740 \ubcc4\ub3c4\uc758 \uc124\uba85\uc774 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4. pfile\uc744 spfile\ub85c \ub9cc\ub4e4\uc5b4 \uc8fc\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc7ac\uae30\ub3d9 \ud558\uba74 \ub429\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; create spfile from pfile;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; shutdown immediate;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; startup<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nORACLE instance started.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><\/font><\/font><font color=\"#ffffff\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><font color=\"#ffffff\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Total System Global Area&nbsp; 285212672 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nFixed Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1267068 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nVariable Size&nbsp;&nbsp;&nbsp;&nbsp; 92277380 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDatabase Buffers&nbsp;&nbsp; 188743680 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nRedo Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2924544 bytes<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDatabase mounted.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nDatabase opened.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><a href=\"mailto:SYS@testdb\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SYS@testdb<\/span><\/a><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&gt; show parameter pfile;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><\/font><\/font><font color=\"#ffffff\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><font color=\"#ffffff\"><font style=\"BACKGROUND-COLOR: #071a30\" size=\"2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n------------------------------------------------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\nspfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/product\/10g\/dbs\/spfiletestdb.ora<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/font><\/font><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><p style=\"PAGE-BREAK-AFTER: avoid\" ><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc740 \uc624\ub77c\ud074\uc5d0\uc11c \ud544\uc218 \ud30c\uc77c \uc911 \ud558\ub098\ub85c \uba85\uc2dc \ub418\uc5b4\uc788\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\uc0ac\uc6a9 \ubc29\ubc95\uc740 \uc27d\uc9c0\ub9cc \uad00\ub9ac\ub97c \uc798 \ud574\uc57c \ud558\ub294 \ud30c\uc77c \uc911 \ud558\ub098 \uc785\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\ubcf4\ud1b5 \ubc31\uc5c5\ud30c\uc77c\uc758 \uae30\uc900\uc774 redo log file, control file, data file, archive log file \ubb34\uc870\uac74 \ubc31\uc5c5\uc744 \ud558\uac8c \ub418\uace0 \uc0c1\ud669\uc5d0 \ub530\ub77c\uc11c \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\ub3c4 \ubc31\uc5c5\uc808\ucc28\uc5d0 \ud3ec\ud568 \ub420 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ubc18\ub4dc\uc2dc \uc54c\uc544\uc57c \ud560 \uac83\uc740&nbsp;pfile, spfile\uc758 \ucc28\uc774\uc810\uc744 \ud30c\uc545 \ud558\uc154\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ucd9c\ucc98 : http:\/\/estenpark.tistory.com\/294 1.&nbsp;\ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uac1c\ub150\uacfc \uc885\ub958 [1-1 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc758 \uac1c\ub150] \uc624\ub77c\ud074\uc5d0\uc11c \ub9d0\ud558\ub294 \ud544\uc218 \ud30c\uc77c \uc911\uc5d0\uc11c \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc740 \uc624\ub77c\ud074\uc774 \uad6c\ub3d9 \ud560 \uc218 \uc788\uac8c \uc124\uacc4\ub418\uc5b4 \uc788\ub294&nbsp;\ub3c4\uba74\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ud55c\uac00\uc9c0 \uc608\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uae30\ub3d9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud30c\ub77c\uba54\ud130 \ud30c\uc77c\uc744 \ucc38\uc870\ud558\uc5ec SGA \ubc0f \uae30\ud0c0 \ud544\uc694\ud55c \ud658\uacbd\uc744 \uad6c\uc131 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. shutdown(\uc885\ub8cc\uc0c1\ud0dc) -&gt; \ud30c\ub77c\uba54\ud130 \ud30c\uc77c \uc77d\uae30(spfile\/pfile) -&gt; NOMOUNT \ub2e8\uacc4\ubcc4\ub85c \uc62c\ub77c\uc624\ub294\ub370 \uc5ec\uae30\uc5d0\uc11c \ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c\uc744 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-413","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=413"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/413\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}