{"id":1228,"date":"2018-03-05T14:36:57","date_gmt":"2018-03-05T06:36:57","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1228"},"modified":"2018-03-30T09:29:44","modified_gmt":"2018-03-30T01:29:44","slug":"oracle-12c-%e5%8f%98%e6%9b%b4%e5%bd%92%e6%a1%a3%e6%a8%a1%e5%bc%8f","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1228","title":{"rendered":"Oracle 12C \u53d8\u66f4\u5f52\u6863\u6a21\u5f0f"},"content":{"rendered":"<p>\n\t<strong>1.shutdown normal\u6216shutdown immediate\u5173\u95ed\u6570\u636e\u5e93<\/strong>\n<\/p>\n<p>\n\tSQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 5 14:22:50 2018\n<\/p>\n<p>\n\tCopyright (c) 1982, 2014, Oracle. &nbsp;All rights reserved.\n<\/p>\n<p>\n\tSQL&gt; conn \/as sysdba;\n<\/p>\n<p>\n\tSQL&gt; shutdown immediate;\n<\/p>\n<p>\n\tDatabase closed.<br \/>\n\tDatabase dismounted.<br \/>\n\tORACLE instance shut down.\n<\/p>\n<p>\n\t<strong>2.\u542f\u52a8Oracle\u6570\u636e\u5e93\u5230mount\u72b6\u6001<\/strong>\n<\/p>\n<p>\n\tSQL&gt; startup mount; &nbsp;\n<\/p>\n<p>\n\tORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance<br \/>\n\tORACLE instance started.\n<\/p>\n<p>\n\tTotal System Global Area 2147483648 bytes<br \/>\n\tFixed Size &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3712904 bytes<br \/>\n\tVariable Size &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 486541432 bytes<br \/>\n\tDatabase Buffers &nbsp; &nbsp; &nbsp; &nbsp; 1644167168 bytes<br \/>\n\tRedo Buffers &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13062144 bytes<br \/>\n\tDatabase mounted.\n<\/p>\n<p>\n\t<strong>3.\u542f\u7528\u6216\u505c\u6b62\u5f52\u6863\u6a21\u5f0f<\/strong>\n<\/p>\n<p>\n\t\u5982\u679c\u8981\u542f\u7528\u5f52\u6863\u6a21\u5f0f\uff0c\u6b64\u5904\u4f7f\u7528alter database archivelog \u547d\u4ee4\u3002\n<\/p>\n<p>\n\t\u5982\u679c\u8981\u5173\u95ed\u5f52\u6863\u6a21\u5f0f\uff0c\u6b64\u5904\u4f7f\u7528alter database noarchivelog \u547d\u4ee4\u3002\n<\/p>\n<p>\n\tSQL&gt; alter database archivelog; &nbsp;\n<\/p>\n<p>\n\tDatabase altered.\n<\/p>\n<p>\n\tSQL&gt; alter database open; &nbsp;\n<\/p>\n<p>\n\tDatabase altered.&nbsp;\n<\/p>\n<p>\n\tSQL&gt; archive log list; &nbsp;\n<\/p>\n<p>\n\tDatabase log mode &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Archive Mode<br \/>\n\tAutomatic archival &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Enabled<br \/>\n\tArchive destination &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;\/u01\/DEV\/db\/data\/archive<br \/>\n\tOldest online log sequence &nbsp; &nbsp; 61<br \/>\n\tNext log sequence to archive &nbsp; 62<br \/>\n\tCurrent log sequence &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 62\n<\/p>\n<p>\n\t\u4ee5\u4e0b\u662f\u5b98\u65b9\u53c2\u8003\u6587\u6863\uff0812C\u4e00\u6837\u7684\u64cd\u4f5c\u65b9\u5f0f\uff09\uff1a\n<\/p>\n<p>\n\tEnable\/Disable Archive Log Mode In 10g and 11g ( Doc ID 371139.1 )&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.shutdown normal\u6216shutdown immediate\u5173\u95ed\u6570\u636e\u5e93 SQL*Plus: Rel &hellip; <a href=\"https:\/\/www.llku.com\/?p=1228\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Oracle 12C \u53d8\u66f4\u5f52\u6863\u6a21\u5f0f<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31],"tags":[205],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1228"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1228"}],"version-history":[{"count":4,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1228\/revisions"}],"predecessor-version":[{"id":1265,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1228\/revisions\/1265"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}