{"id":1196,"date":"2016-01-03T10:13:34","date_gmt":"2016-01-03T10:13:34","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1196"},"modified":"2016-01-03T10:13:34","modified_gmt":"2016-01-03T10:13:34","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%bd%9c%eb%93%9c%eb%b0%b1%ec%97%85","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1196","title":{"rendered":"\uc624\ub77c\ud074 \ucf5c\ub4dc\ubc31\uc5c5"},"content":{"rendered":"

DB \uc885\ub8cc \ud6c4 \uc804\uccb4 \ud30c\uc77c\uc744 \ubc31\uc5c5 \ubc1b\ub294 \ubc29\uc2dd <\/SPAN><\/P>
\n

\ud2b9\uc9d5 <\/SPAN><\/P>
\n

\ubaa8\ub4e0 \ud30c\uc77c\uc740 \ub3d9\uc77c\ud55c SCN\uc744 \uac00\uc838\uc57c \ud568. \uc989 shutdown \uc2dc\uc810\uc774 \uac19\uc774\uc57c \ud568. <\/SPAN><\/P>
\n

\ub610\ud55c \uc815\uc0c1\uc801\uc73c\ub85c \uc885\ub8cc\ud574\uc57c \ud568. <\/SPAN><\/P>
\n

\uc544\uce74\uc774\ube0c, \ub178\uc544\uce74\uc774\ube0c \ubaa8\ub450 \uc0ac\uc6a9 \uac00\ub2a5 <\/SPAN><\/P>
\n

datafile, redo log, control file \ubaa8\ub450 \uac00\ub2a5 <\/SPAN><\/P>
\n

   <\/P>
\n

\uc2e4\uc2b5 <\/SPAN><\/P>
\n

# \ub370\uc774\ud130 \ud30c\uc77c \uc870\ud68c <\/SPAN><\/P>
\n

set lines 300 <\/SPAN><\/P>
\n

set pages 1000 <\/SPAN><\/P>
\n

col name for a70 <\/SPAN><\/P>
\n

select name, status from v$datafile ; <\/SPAN><\/P>
\n

   <\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# \ub9ac\ub450\ub85c\uadf8 \ud30c\uc77c \uc870\ud68c <\/SPAN><\/P>
\n

select a.group# , a.member , b.bytes\/1024\/1024 MB , b.archived , b.status <\/SPAN><\/P>
\n

from v$logfile a , v$log b <\/SPAN><\/P>
\n

where a.group#=b .group# <\/SPAN><\/P>
\n

order by 1,2 ; <\/SPAN><\/P>
\n

   <\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# \ucee8\ud2b8\ub864\ud30c\uc77c \uc870\ud68c <\/SPAN><\/P>
\n

select name from v$controlfile ; <\/SPAN><\/P>
\n

   <\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# DB \uc885\ub8cc <\/SPAN><\/P>
\n

shutdown immediate <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# \ub370\uc774\ud130\ud30c\uc77c \ubc31\uc5c5 <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

<\/SPAN><\/P>
\n

# \ub9ac\ub450\ub85c\uadf8 \ud30c\uc77c \ubc31\uc5c5 <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# \ucee8\ud2b8\ub864\ud30c\uc77c \ubc31\uc5c5 <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# \ud655\uc778 <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# DB \uae30\ub3d9 <\/SPAN><\/P>
\n

startup <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

  <\/SPAN> <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

DB \uc885\ub8cc \ud6c4 \uc804\uccb4 \ud30c\uc77c\uc744 \ubc31\uc5c5 \ubc1b\ub294 \ubc29\uc2dd \ud2b9\uc9d5 \ubaa8\ub4e0 \ud30c\uc77c\uc740 \ub3d9\uc77c\ud55c SCN\uc744 \uac00\uc838\uc57c \ud568. \uc989 shutdown \uc2dc\uc810\uc774 \uac19\uc774\uc57c \ud568. \ub610\ud55c \uc815\uc0c1\uc801\uc73c\ub85c \uc885\ub8cc\ud574\uc57c \ud568. \uc544\uce74\uc774\ube0c, \ub178\uc544\uce74\uc774\ube0c \ubaa8\ub450 \uc0ac\uc6a9 \uac00\ub2a5 datafile, redo log, control file \ubaa8\ub450 \uac00\ub2a5     \uc2e4\uc2b5 # \ub370\uc774\ud130 \ud30c\uc77c \uc870\ud68c set lines 300 set pages 1000 col name for a70 select name, […]<\/p>\n","protected":false},"author":1,"featured_media":1197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[681,682,683],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile5.uf.244D2A3D5688F44B133791.png?fit=507%2C235","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1196"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1196"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1196\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1197"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1196"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}