{"id":2882,"date":"2018-02-03T18:58:10","date_gmt":"2018-02-03T09:58:10","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2882"},"modified":"2018-02-03T18:59:30","modified_gmt":"2018-02-03T09:59:30","slug":"%ec%9d%b4%ec%a0%84-control-file%eb%a1%9c-%eb%b6%80%ed%84%b0-control-file-%eb%b0%b1%ec%97%85%eb%b0%9b%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2882","title":{"rendered":"\uc774\uc804 control file\ub85c \ubd80\ud130 control file \ubc31\uc5c5\ubc1b\uae30."},"content":{"rendered":"<p>\uae30\uc874\uc758 database \uc5d0\uc11c control file \uc758 \uc815\ubcf4\uac00 \ubcc0\uacbd\ub418\ub294 \uacbd\uc6b0 \uae30\uc874\uc758 control file\uc744 \ubc31\uc5c5 \ubc1b\uc740 \ud6c4 \ubc31\uc5c5 \ubc1b\uc740 control file\uc744 \uc774\uc6a9\ud574\uc11c \uc0c8\ub85c\uc6b4 control file\uc744 \uc0dd\uc131\ud574 \ub0b8\ub2e4. Control file\uc744 \ubc31\uc5c5 \ubc1b\ub294 \ubc29\ubc95\uc5d0\ub294 binary file \ud615\ud0dc\uc640 trace file(\uc2a4\ud06c\ub9bd\ud2b8)\ud30c\uc77c \ud615\ud0dc\ub85c \ubc1b\ub294 2\uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\ub294\ub370<span style=\"color: red;\">, trace file \ud30c\uc77c\uc744 \uc774\uc6a9\ud558\uc5ec control file\uc744 \uc0dd\uc131\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n<p>control file\uc744 \ubc31\uc5c5\ubc1b\uae30 \uc804\uc5d0\ub294<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\">Make a list of all datafiles and online redo log files of the database.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"color: red;\">Shut down the database. \u2013 normal<\/span><\/div>\n<\/li>\n<\/ul>\n<p>\ud55c\ub2e4.<\/p>\n<p><span style=\"color: red;\">ALTER DATABASE BACKUP CONTROLFILE TO<br \/>\n<\/span><\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 111px;\" \/>\n<col style=\"width: 76px;\" \/>\n<col style=\"width: 442px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding: 1px;\" rowspan=\"3\"><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">BACKUP<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"><br \/>\n<\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">CONTROLFILE<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\">\u00a0<\/span><\/td>\n<td style=\"padding: 1px;\" colspan=\"2\"><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\">Use the <\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">BACKUP<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"><br \/>\n<\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">CONTROLFILE<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"> clause to back up the current control file.\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 1px;\"><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">TO<\/span><em><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"> &#8216;<\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">filename<\/span><\/em><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"><em>&#8216;<\/em>\u00a0<\/span><\/td>\n<td style=\"padding: 1px;\"><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\">Specify the file to which the control file is backed up. You must fully specify the <\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\"><em>filename<\/em><\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"> using the conventions for your operating system. If the specified file already exists, you must specify <\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">REUSE<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\">. \u2013 binary \ud615\ud0dc\ub85c \ub9cc\ub4dc\ub294 \uac83\u00a0<\/span><\/td>\n<\/tr>\n<tr style=\"height: 488px;\">\n<td style=\"border-bottom: none; padding: 1px;\"><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">TO<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"><br \/>\n<\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">TRACE<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\">\u00a0<\/span><\/td>\n<td style=\"border-bottom: none; padding: 1px;\"><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\">Specify <\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">TO<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"><br \/>\n<\/span><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">TRACE<\/span><span style=\"font-family: \ubc14\ud0d5; font-size: 12pt;\"> if you want Oracle to write SQL statements to the database&#8217;s trace file rather than making a physical backup of the control file. <span style=\"color: red;\">The SQL statements can start up the database, re-create the control file, and recover and open the database appropriately, based on the created control file.\u00a0\u2013USER_DUMP_DEST \uc704\uce58\ub85c \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c\uc744 \uc0dd\uc131\ud55c\ub2e4.<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: red; font-family: \ubc14\ud0d5; font-size: 12pt;\">You can copy the statements from the trace file into a script file, edit the statements as necessary, and use the database if all copies of the control file are lost (or to change the size of the control file).<br \/>\n<\/span><\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">RESETLOGS<\/span> indicates that the SQL statement written to the trace file for starting the database is <span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">ALTER<\/span><br \/>\n<span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">DATABASE<\/span><br \/>\n<span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">OPEN<\/span><br \/>\n<span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">RESETLOGS<\/span>.<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">NORESETLOGS<\/span> indicates that the SQL statement written to the trace file for starting the database is <span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">ALTER<\/span><br \/>\n<span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">DATABASE<\/span><br \/>\n<span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">OPEN<\/span><br \/>\n<span style=\"font-family: \ub3cb\uc6c0; font-size: 10pt;\">NORESETLOGS<\/span>.<\/div>\n<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\uae30\uc874\uc758 database \uc5d0\uc11c control file \uc758 \uc815\ubcf4\uac00 \ubcc0\uacbd\ub418\ub294 \uacbd\uc6b0 \uae30\uc874\uc758 control file\uc744 \ubc31\uc5c5 \ubc1b\uc740 \ud6c4 \ubc31\uc5c5 \ubc1b\uc740 control file\uc744 \uc774\uc6a9\ud574\uc11c \uc0c8\ub85c\uc6b4 control file\uc744 \uc0dd\uc131\ud574 \ub0b8\ub2e4. Control file\uc744 \ubc31\uc5c5 \ubc1b\ub294 \ubc29\ubc95\uc5d0\ub294 binary file \ud615\ud0dc\uc640 trace file(\uc2a4\ud06c\ub9bd\ud2b8)\ud30c\uc77c \ud615\ud0dc\ub85c \ubc1b\ub294 2\uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\ub294\ub370, trace file \ud30c\uc77c\uc744 \uc774\uc6a9\ud558\uc5ec control file\uc744 \uc0dd\uc131\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4. control file\uc744 \ubc31\uc5c5\ubc1b\uae30 \uc804\uc5d0\ub294 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2875,"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":[950,951,949],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2882"}],"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=2882"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2882\/revisions"}],"predecessor-version":[{"id":2884,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2882\/revisions\/2884"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2875"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2882"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}