{"id":3637,"date":"2018-03-19T11:08:15","date_gmt":"2018-03-19T02:08:15","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3637"},"modified":"2018-03-19T11:08:15","modified_gmt":"2018-03-19T02:08:15","slug":"oracle-db-%ea%b8%b0%eb%8f%99-%ec%a4%91%ec%a7%80","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3637","title":{"rendered":"ORACLE DB \uae30\ub3d9 \/ \uc911\uc9c0"},"content":{"rendered":"

Oracle Data Base Startup
\n<\/span><\/h3>\n

Oracle Startup\uc740 \ub0b4\ubd80\uc801\uc73c\ub85c 3\uac1c\uc758 \uacfc\uc815\uc73c\ub85c \ub098\ub204\uc5b4 \uc2e4\ud589\ub41c\ub2e4. \uac01\uac01\uc758 \uacfc\uc815\uc5d0\uc11c \uc791\uc5c5\ub418\ub294 \ub0b4\uc6a9 \ubc0f \uc0ac\uc6a9\ub418\ub294 file\uc740 Backup\uc774\ub098 Recovery\uc2dc \uaf2d \ud544\uc694\ud55c \ubd80\ubd84\uc774\ub77c\uace0 \ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

SQL> startup
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0Oracle instance startup.
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0Database mounted.
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0Database opened.
\n<\/span><\/p>\n

\"\"
\n<\/span><\/p>\n

1\ub2e8\uacc4 : Nomount
\n<\/span><\/h4>\n

Oracle\uc774 \uc6b4\uc6a9\ud558\ub294\ub370 \ud544\uc694\ud55c background process\ub97c \uc2e4\ud589\uc2dc\ud0a4\uace0 system memory\ub0b4\uc5d0 SGA ( system global area )\ub97c \ud560\ub2f9\ud55c\ub2e4
\n<\/span><\/p>\n

1. init$ORACLE_SID.ora file\uc744 \ucc3e\ub294\ub2e4.
\n<\/span><\/p>\n

Init$ORACLE_SID.ora file\uc5d0\ub294 Oracle\uc774 startup\ud558\ub294\ub370 \ud544\uc694\ud55c parameter \uac12\uc774 \uc815\uc758\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \uac00\uc7a5 \uba3c\uc800 $ORACLE_HOME\/dbs\/init$ORACLE_SID.ora file\ub97c \ucc3e\ub294\ub2e4.
\n<\/span><\/p>\n

2. background process\ub97c \uae30\ub3d9 \ud55c\ub2e4.
\n<\/span><\/p>\n

init$ORACLE_SID.ora file\ub0b4\uc5d0 \uc9c0\uc815\ub41c config file\ub97c \ud3ec\ud568\ud558\uc5ec parameter \ub0b4\uc6a9\uc744 \ucc38\uc870\ud558\uc5ec Oracle background process\ub97c startup \ud55c\ub2e4.
\n<\/span><\/p>\n

3. SGA\ub97c \ud560\ub2f9 \ubc1b\ub294\ub2e4.
\n<\/span><\/p>\n

init$ORACLE_SID.ora file\ub0b4\uc5d0 \uc9c0\uc815\ub41c parameter \uac12\uc744 \uc774\uc6a9\ud558\uc5ec system memory\ub0b4\uc5d0\uc11c SGA\ub97c \ud560\ub2f9 \ubc1b\ub294\ub2e4.
\n<\/span><\/p>\n

F<\/span> backup & recovery\uc2dc \ud544\uc694 \uc0ac\ud56d
\n<\/span><\/p>\n

Backup & recovery\uc2dc \uaf2d \ud544\uc694\ud55c file\uc774 \uc774\uacf3\uc5d0\uc11c \ub3c4\ucd9c \ub418\uc5c8\ub2e4. Init$ORACLE_SID.ora\uc640 config file\uc740 backup\uc2dc \ud56d\uc2dc \uac19\uc774 backup\ub418\uc5b4\uc57c \ud558\uace0 recovery\uc2dc\uc5d0\ub3c4 \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ub418\ub294 file\uc774\ub2e4.<\/em><\/span>
\n<\/span><\/p>\n

2\ub2e8\uacc4 : database mount
\n<\/span><\/h4>\n

init[sid] file\uc5d0 \uc9c0\uc815\ub41c control file\ub97c \uc77d\uc5b4 \ubaa8\ub4e0 data file\uc744 mount \uc2dc\ud0a8\ub2e4.
\n<\/span><\/p>\n

1. control file\uc744 \ucc3e\ub294\ub2e4.
\n<\/span><\/p>\n

control file\uc5d0\ub294 Datafile \ubc0f redo log file\uc5d0 \ub300\ud55c \uc815\ubcf4 \ubc0f SCN ( system control number )\uc774 \uc815\uc758\ub418\uc5b4 \uc788\ub2e4. \uc774 \uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uc5ec \ubaa8\ub4e0 \uc790\ub8cc\uc758 commit \uc2dc\uc810\uc774 \ub3d9\uc77c\ud55c\uac00\ub97c \uac80\uc99d\ud55c\ub2e4. \ub9cc\uc77c \ud2c0\ub9ac\uba74 redo log\ub97c \uc774\uc6a9\ud558\uc5ec Recover \ud55c \ud6c4 startup\ud55c\ub2e4.
\n<\/span><\/p>\n

2. data file\uc744 mount \uc2dc\ud0a8\ub2e4.
\n<\/span><\/p>\n

Control \ud654\uc77c\uc5d0 \uc815\uc758\ub41c \ubaa8\ub4e0 data file\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud558\uc5ec mount\uc2dc\ud0a8\ub2e4.
\n<\/span><\/p>\n

3. redo log \ud654\uc77c\uc744 mount \uc2dc\ud0a8\ub2e4.
\n<\/span><\/p>\n

control\ud654\uc77c\uc5d0 \uc815\uc758\ub41c redo log file\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud558\uc5ec mount\uc2dc\ud0a8\ub2e4.
\n<\/span><\/p>\n

F<\/span> \uc774 \uc0c1\ud0dc\uc5d0\uc11c \uc911\uc694\ud55c \uba87 \uac00\uc9c0 backup, recovery, dba \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4.
\n<\/span><\/p>\n

1.\uc804\uccb4 database\uc758 \ubcf5\uad6c\uac00 \uac00\ub2a5\ud558\ub2e4.
\n<\/em><\/span><\/p>\n

2.No archive log mode\ub97c archive log mode\ub85c \ubcc0\uacbd\uc774 \uac00\ub2a5\ud558\ub2e4.
\n<\/em><\/span><\/p>\n

3.Data file\uc758 \uc704\uce58\ub098 \uc774\ub984\uc758 \ubcc0\uacbd\uc774 \uac00\ub2a5\ud558\ub2e4.
\n<\/em><\/span><\/p>\n

4.\ub9ac\ub450 \ub85c\uadf8 \ud30c\uc77c\uc758 \ucd94\uac00, \uc0ad\uc81c, \uc774\ub984 \ubcc0\uacbd
\n<\/em><\/span><\/p>\n

5.\ubd88\uc644\uc804\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcf5\uad6c<\/em><\/span>
\n<\/span><\/p>\n

3\ub2e8\uacc4 : database open
\n<\/span><\/h4>\n

\ub9c8\uc6b4\ud2b8\ub41c \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c User\ub4e4\uc774 \uc811\uc18d\ud560 \uc218 \uc788\ub3c4\ub85d online log file\uacfc data file\uc744 open\ud55c\ub2e4.
\n<\/span><\/p>\n

1. \uc790\ub3d9 recovery \uc218\ud589
\n<\/span><\/p>\n

mount\ub41c data file\ub4f1\uc744 \uc774\uc6a9\ud558\uc5ec \ube44 \uc815\uc0c1\uc801\uc778 \uc885\ub8cc ( shutdown abort ) \ub4f1\uc73c\ub85c \uc778\ud55c data file\uc758 SCN \ubd88\uc77c\uce58\uc2dc RECO process\uac00 \uc790\ub3d9\uc73c\ub85c(\uc989\uc2dc. consistent\ud558\uac8c) \ud574\ub2f9 transaction\uc744 \ud574\uacb0\ud558\uace0 recovery\ub97c \uc218\ud589\ud55c\ub2e4. Redo log\uc640 rollback segment\uc758 \uc815\ubcf4 \ub9cc\uc73c\ub85c recovery\uac00 \ubd88\uac00\ub2a5 \ud560 \uacbd\uc6b0 media recovery\ub97c \uc694\uccad\ud55c\ub2e4.
\n<\/span><\/p>\n

2. data file open
\n<\/span><\/p>\n

\ubaa8\ub4e0 data file\uc774 \uc815\uc0c1\uc778 \uacbd\uc6b0 data file\uc744 open\ud55c\ub2e4.
\n<\/span><\/p>\n

3. user \uc0ac\uc6a9 \uac00\ub2a5
\n<\/span><\/p>\n

\uc774\uc81c\ubd80\ud130 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\uc758 database access\uac00 \uac00\ub2a5\ud55c \uc0c1\ud0dc\ub85c \uc804\ud658\ub41c\ub2e4.
\n<\/span><\/p>\n

Oracle Data Base Shutdown
\n<\/span><\/h3>\n

Oracle startup\uc2dc\uc640 \ubc18\ub300\ub85c \uc218\ud589\ub41c\ub2e4.
\n<\/span><\/p>\n

SQL> shutdown
\n<\/span><\/p>\n

Database closed.
\n<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0 Database dismounted.
\n<\/span><\/p>\n

ORACLE instance shutdown.
\n<\/span><\/p>\n

Closing Database
\n<\/span><\/h4>\n

Database\ub97c close \ud560 \ub54c Oracle\uc740 \ubaa8\ub4e0 SGA \uc548\uc758 database data\uc640 recovery data\ub97c datafile\uacfc redo log file\uc5d0 \uac01\uac01 write \ud55c\ub2e4. \uc774 \uc791\uc5c5\uc774 \uc218\ud589\ub41c \ud6c4 Oracle\uc740 \ubaa8\ub4e0 online datafile\uacfc online redo log file\uc744 close \ud55c\ub2e4. Control file\uc740 database\uac00 close \ub41c \ud6c4\uc5d0\ub3c4 \uc5ec\uc804\ud788 mount \ub418\uc5b4 open \ub41c \uc0c1\ud0dc\ub85c \ub0a8\uc544 \uc788\ub294\ub2e4.
\n<\/span><\/p>\n

\ud2b9\uc218\ud55c \uc0c1\ud669\uc5d0 open \ub41c database\uc758 instance\ub97c abort \uc2dc\ud0a4\uace0 database\ub97c \uc989\uc2dc dismount \uc2dc\ud0ac \uc218 \uc788\ub2e4. \uc774 \uacfc\uc815\uc740 SGA buffer\ub97c datafile\uacfc redo log file\uc5d0 \uae30\ub85d\ud558\ub294 \uacfc\uc815\uc744 \uc0dd\ub7b5\ud558\ubbc0\ub85c \ube60\ub974\uac8c \uc218\ud589\ub420 \uc218 \uc788\ub2e4. (Oracle\uc740database\ub97c reopen \ud560 \ub54c \uc790\ub3d9\uc73c\ub85c \ubcf5\uad6c\ud55c\ub2e4 – instance recovery)
\n<\/span><\/p>\n

Dismount database
\n<\/span><\/h4>\n

Database\ub97c dismount \uc2dc\ud0a8 \ud6c4\uc5d0\ub294 memory \uc548\uc5d0 instance\ub9cc\uc774 \ub0a8\uc544 \uc788\uac8c \ub41c\ub2e4. Database\uac00 dismount \ub41c \ud6c4 Oracle\uc740 database\uc758 control file\uc744 close\ud55c\ub2e4.
\n<\/span><\/p>\n

Shutdown instance
\n<\/span><\/h4>\n

Instance\ub97c shut down \ud560 \ub54c memory\ub85c\ubd80\ud130 SGA\uac00 \uc81c\uac70\ub418\uba70 background process\uac00 \uc885\ub8cc\ub41c\ub2e4.
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Data Base Startup Oracle Startup\uc740 \ub0b4\ubd80\uc801\uc73c\ub85c 3\uac1c\uc758 \uacfc\uc815\uc73c\ub85c \ub098\ub204\uc5b4 \uc2e4\ud589\ub41c\ub2e4. \uac01\uac01\uc758 \uacfc\uc815\uc5d0\uc11c \uc791\uc5c5\ub418\ub294 \ub0b4\uc6a9 \ubc0f \uc0ac\uc6a9\ub418\ub294 file\uc740 Backup\uc774\ub098 Recovery\uc2dc \uaf2d \ud544\uc694\ud55c \ubd80\ubd84\uc774\ub77c\uace0 \ud560 \uc218 \uc788\ub2e4. SQL> startup \u00a0\u00a0\u00a0\u00a0Oracle instance startup. \u00a0\u00a0\u00a0\u00a0Database mounted. \u00a0\u00a0\u00a0\u00a0Database opened. 1\ub2e8\uacc4 : Nomount Oracle\uc774 \uc6b4\uc6a9\ud558\ub294\ub370 \ud544\uc694\ud55c background process\ub97c \uc2e4\ud589\uc2dc\ud0a4\uace0 system memory\ub0b4\uc5d0 SGA ( system global area )\ub97c \ud560\ub2f9\ud55c\ub2e4 1. init$ORACLE_SID.ora […]<\/p>\n","protected":false},"author":1,"featured_media":2876,"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":[9],"tags":[71,1051,1049,1048,1050],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Cover1.png?fit=1000%2C730","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3637"}],"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=3637"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3637\/revisions"}],"predecessor-version":[{"id":3639,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3637\/revisions\/3639"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2876"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3637"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}