{"id":1189,"date":"2017-12-18T17:51:30","date_gmt":"2017-12-18T09:51:30","guid":{"rendered":"http:\/\/www.821121.com\/?p=1189"},"modified":"2020-12-18T17:51:45","modified_gmt":"2020-12-18T09:51:45","slug":"%e8%af%af%e5%88%a0%e5%a4%9a%e8%b7%af%e5%a4%8d%e7%94%a8%e7%9a%84online%e6%97%a5%e5%bf%97%e6%96%87%e4%bb%b6%ef%bc%8c%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e5%8f%98%e5%8c%96","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1189","title":{"rendered":"*\u8bef\u5220\u591a\u8def\u590d\u7528\u7684online\u65e5\u5fd7\u6587\u4ef6\uff0c\u6570\u636e\u5e93\u7684\u53d8\u5316"},"content":{"rendered":"<h1>1.\u67e5\u770bredo\u65e5\u5fd7<\/h1>\n<pre><code class=\"language-sql\">col member for a45\nset lines 120\nSELECT thread#,\n         a.sequence#,\n         a.group#,\n         TO_CHAR (first_change#, &#039;9999999999999999&#039;) &quot;SCN&quot;,\n         a.status,\n         MEMBER\n    FROM v$log a, v$logfile b\n   WHERE a.group# = B.GROUP#\nORDER BY a.sequence# DESC;\n\nSQL&gt; col member for a45\nSQL&gt; set lines 120\nSQL&gt; SELECT thread#,\n  2           a.sequence#,\n  3           a.group#,\n  4           TO_CHAR (first_change#, &#039;9999999999999999&#039;) &quot;SCN&quot;,\n  5           a.status,\n  6           MEMBER\n  7      FROM v$log a, v$logfile b\n  8     WHERE a.group# = B.GROUP#\n  9  ORDER BY a.sequence# DESC;\n\n   THREAD#  SEQUENCE#     GROUP# SCN               STATUS           MEMBER\n---------- ---------- ---------- ----------------- ---------------- ---------------------------------------------\n         1          5          1           1162988 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log\n         1          5          1           1162988 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\n         1          4          2           1141227 INACTIVE         \/u01\/app\/oracle\/oradata\/racdb\/redo02_1.log\n         1          4          2           1141227 INACTIVE         \/u01\/app\/oracle\/oradata\/racdb\/redo02_2.log\n<\/code><\/pre>\n<h1>2.\u67e5\u770b\u6570\u636e\u5e93\u6587\u4ef6\u540d<\/h1>\n<pre><code class=\"language-sql\">SQL&gt; !ls -l\ntotal 1663272\ndrwxr-xr-x. 2 oracle oinstall      4096 Dec 15 22:26 archivelog\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:34 control01.ctl\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:34 control02.ctl\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:34 control03.ctl\n-rw-r-----  1 oracle oinstall  10493952 Dec 15 22:26 eas_d_anjoy_standard01.dbf\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:32 redo01_1.log\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:32 redo01_2.log\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:26 redo02_1.log\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:26 redo02_2.log\n-rw-r-----  1 oracle oinstall 576724992 Dec 15 22:32 sysaux01.dbf\n-rw-r-----  1 oracle oinstall 775954432 Dec 15 22:32 system01.dbf\n-rw-r-----  1 oracle oinstall  20979712 Dec 13 05:30 temp01.dbf\n-rw-r-----  1 oracle oinstall  20979712 Dec 15 22:26 test01.dbf\n-rw-r-----  1 oracle oinstall  47194112 Dec 15 22:32 undotbs1.dbf\n-rw-r-----  1 oracle oinstall   5251072 Dec 15 22:26 \n```users01.dbf\n\n# 3.\u5220\u9664\u5f53\u524d\u65e5\u5fd7\u7ec4\u6587\u4ef6\n```sql\nSQL&gt; !rm redo01_1.log\nSQL&gt; !ls -l\ntotal 1612068\ndrwxr-xr-x. 2 oracle oinstall      4096 Dec 15 22:26 archivelog\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:36 control01.ctl\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:36 control02.ctl\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:36 control03.ctl\n-rw-r-----  1 oracle oinstall  10493952 Dec 15 22:26 eas_d_anjoy_standard01.dbf\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:35 redo01_2.log\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:26 redo02_1.log\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:26 redo02_2.log\n-rw-r-----  1 oracle oinstall 576724992 Dec 15 22:32 sysaux01.dbf\n-rw-r-----  1 oracle oinstall 775954432 Dec 15 22:32 system01.dbf\n-rw-r-----  1 oracle oinstall  20979712 Dec 13 05:30 temp01.dbf\n-rw-r-----  1 oracle oinstall  20979712 Dec 15 22:26 test01.dbf\n-rw-r-----  1 oracle oinstall  47194112 Dec 15 22:32 undotbs1.dbf\n-rw-r-----  1 oracle oinstall   5251072 Dec 15 22:26 users01.dbf\n<\/code><\/pre>\n<h1>4.\u67e5\u770b\u5f53\u524d\u7684\u65e5\u5fd7\u7ec4\u4ecd\u7136\u5728\u4f7f\u7528<\/h1>\n<pre><code class=\"language-sql\">SQL&gt; col member for a45\nSQL&gt; set lines 120\nSQL&gt; SELECT thread#,\n  2           a.sequence#,\n  3           a.group#,\n  4           TO_CHAR (first_change#, &#039;9999999999999999&#039;) &quot;SCN&quot;,\n  5           a.status,\n  6           MEMBER\n  7      FROM v$log a, v$logfile b\n  8     WHERE a.group# = B.GROUP#\n  9  ORDER BY a.sequence# DESC;\n\n   THREAD#  SEQUENCE#     GROUP# SCN               STATUS           MEMBER\n---------- ---------- ---------- ----------------- ---------------- ---------------------------------------------\n         1          5          1           1162988 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log\n         1          5          1           1162988 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\n         1          4          2           1141227 INACTIVE         \/u01\/app\/oracle\/oradata\/racdb\/redo02_1.log\n         1          4          2           1141227 INACTIVE         \/u01\/app\/oracle\/oradata\/racdb\/redo02_2.log<\/code><\/pre>\n<h1>5.\u91cd\u542f\u6570\u636e\u5e93\uff0c\u53ef\u4ee5\u6b63\u5e38\u91cd\u542f<\/h1>\n<pre><code class=\"language-sql\">SQL&gt; shutdown immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL&gt; startup\nORACLE instance started.\n\nTotal System Global Area 1202556928 bytes\nFixed Size                  2252704 bytes\nVariable Size             771752032 bytes\nDatabase Buffers          419430400 bytes\nRedo Buffers                9121792 bytes\nDatabase mounted.\nDatabase opened.<\/code><\/pre>\n<h1>6.\u5207\u6362\u65e5\u5fd7\u67e5\u770b\u662f\u5426\u6210\u529f\uff0c\u800c\u88ab\u5220\u6389\u7684\u591a\u8def\u590d\u7528\u786e\u5b9a\u4e0d\u5728\uff0c\u4f46\u662f\u5728\u6570\u636e\u5e93\u4f9d\u7136\u53ef\u4ee5\u770b\u5230<\/h1>\n<pre><code class=\"language-sql\">SQL&gt; col member for a45\nSQL&gt; set lines 120\nSQL&gt; SELECT thread#,\n  2           a.sequence#,\n  3           a.group#,\n  4           TO_CHAR (first_change#, &#039;9999999999999999&#039;) &quot;SCN&quot;,\n  5           a.status,\n  6           MEMBER\n  7      FROM v$log a, v$logfile b\n  8     WHERE a.group# = B.GROUP#\n  9  ORDER BY a.sequence# DESC;\n\n   THREAD#  SEQUENCE#     GROUP# SCN               STATUS           MEMBER\n---------- ---------- ---------- ----------------- ---------------- ---------------------------------------------\n         1          5          1           1162988 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log\n         1          5          1           1162988 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\n         1          4          2           1141227 INACTIVE         \/u01\/app\/oracle\/oradata\/racdb\/redo02_1.log\n         1          4          2           1141227 INACTIVE         \/u01\/app\/oracle\/oradata\/racdb\/redo02_2.log\n\nSQL&gt; alter system switch logfile;\n\nSystem altered.\n\nSQL&gt; col member for a45\nSQL&gt; set lines 120\nSQL&gt; SELECT thread#,\n  2           a.sequence#,\n  3           a.group#,\n  4           TO_CHAR (first_change#, &#039;9999999999999999&#039;) &quot;SCN&quot;,\n  5           a.status,\n  6           MEMBER\n  7      FROM v$log a, v$logfile b\n  8     WHERE a.group# = B.GROUP#\n  9  ORDER BY a.sequence# DESC;\n\n   THREAD#  SEQUENCE#     GROUP# SCN               STATUS           MEMBER\n---------- ---------- ---------- ----------------- ---------------- ---------------------------------------------\n         1          6          2           1164459 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo02_1.log\n         1          6          2           1164459 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo02_2.log\n         1          5          1           1162988 ACTIVE           \/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log\n         1          5          1           1162988 ACTIVE           \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\n\nSQL&gt; !ls -l\ntotal 1612068\ndrwxr-xr-x. 2 oracle oinstall      4096 Dec 15 22:41 archivelog\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:41 control01.ctl\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:41 control02.ctl\n-rw-r-----  1 oracle oinstall  18530304 Dec 15 22:41 control03.ctl\n-rw-r-----  1 oracle oinstall  10493952 Dec 15 22:41 eas_d_anjoy_standard01.dbf\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:41 redo01_2.log\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:41 redo02_1.log\n-rw-r-----  1 oracle oinstall  52429312 Dec 15 22:41 redo02_2.log\n-rw-r-----  1 oracle oinstall 576724992 Dec 15 22:41 sysaux01.dbf\n-rw-r-----  1 oracle oinstall 775954432 Dec 15 22:41 system01.dbf\n-rw-r-----  1 oracle oinstall  20979712 Dec 13 05:30 temp01.dbf\n-rw-r-----  1 oracle oinstall  20979712 Dec 15 22:41 test01.dbf\n-rw-r-----  1 oracle oinstall  47194112 Dec 15 22:41 undotbs1.dbf\n-rw-r-----  1 oracle oinstall   5251072 Dec 15 22:41 users01.dbf<\/code><\/pre>\n<h1>7.\u67e5\u770b\u544a\u8b66\u65e5\u5fd7\uff08\u6570\u636e\u5e93\u6301\u7eed\u544a\u8b66\uff0c\u5e76\u5728trace\u76ee\u5f55\u4e0b\u751f\u6210\u4e86\u8ffd\u8e2a\u6587\u4ef6\uff09<\/h1>\n<pre><code class=\"language-sql\">alert\u65e5\u5fd7\uff1a\nCheckpoint not complete\n  Current log# 2 seq# 6 mem# 0: \/u01\/app\/oracle\/oradata\/racdb\/redo02_1.log\n  Current log# 2 seq# 6 mem# 1: \/u01\/app\/oracle\/oradata\/racdb\/redo02_2.log\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/racdb\/racdb\/trace\/racdb_lgwr_3193.trc:\nORA-00313: open failed for members of log group 1 of thread 1\nORA-00312: online log 1 thread 1: &#039;\/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log&#039;\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/racdb\/racdb\/trace\/racdb_lgwr_3193.trc:\nORA-00321: log 1 of thread 1, cannot update log file header\nORA-00312: online log 1 thread 1: &#039;\/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log&#039;\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/racdb\/racdb\/trace\/racdb_lgwr_3193.trc:\nORA-00313: open failed for members of log group 1 of thread 1\nThread 1 advanced to log sequence 7 (LGWR switch)\n  Current log# 1 seq# 7 mem# 1: \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\nTue Dec 15 22:41:00 2020\nArchived Log entry 36 added for thread 1 sequence 6 ID 0x3ee0566e dest 1:\nTue Dec 15 22:41:00 2020\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/racdb\/racdb\/trace\/racdb_m000_3251.trc:\nORA-00313: open failed for members of log group 1 of thread 1\nORA-00312: online log 1 thread 1: &#039;\/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log&#039;\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 3\n<\/code><\/pre>\n<h1>8.\u5c06\u522b\u5220\u9664\u7684\u65e5\u5fd7\u6587\u4ef6\u4ece\u65e5\u5fd7\u7ec4\u5254\u9664\uff0c\u5207\u6362\u65e5\u5fd7\uff0c\u544a\u8b66\u65e5\u5fd7\u4e2d\u6062\u590d\u6b63\u5e38<\/h1>\n<pre><code class=\"language-sql\">SQL&gt; alter database drop logfile member &#039;\/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log&#039;;\n\nDatabase altered.\n\nSQL&gt; col member for a45\nSQL&gt; set lines 120\nSQL&gt; SELECT thread#,\n  2           a.sequence#,\n  3           a.group#,\n  4           TO_CHAR (first_change#, &#039;9999999999999999&#039;) &quot;SCN&quot;,\n  5           a.status,\n  6           MEMBER\n  7      FROM v$log a, v$logfile b\n  8     WHERE a.group# = B.GROUP#\n  9  ORDER BY a.sequence# DESC;\n\n   THREAD#  SEQUENCE#     GROUP# SCN               STATUS           MEMBER\n---------- ---------- ---------- ----------------- ---------------- ---------------------------------------------\n         1          4          2           1110573 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo02_1.log\n         1          4          2           1110573 CURRENT          \/u01\/app\/oracle\/oradata\/racdb\/redo02_2.log\n         1          3          1           1110570 INACTIVE         \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\n\nSQL&gt; alter system switch logfile;\n\nSystem altered.\n\nSQL&gt; \/\n\nSystem altered.\n\n\u544a\u8b66\u65e5\u5fd7\uff1a\nChecker run found 1 new persistent data failures\nTue Dec 15 22:54:40 2020\nalter database drop logfile member &#039;\/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log&#039;\nCompleted: alter database drop logfile member &#039;\/u01\/app\/oracle\/oradata\/racdb\/redo01_1.log&#039;\nTue Dec 15 22:55:14 2020\nThread 1 advanced to log sequence 5 (LGWR switch)\n  Current log# 1 seq# 5 mem# 0: \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\nTue Dec 15 22:55:14 2020\nArchived Log entry 34 added for thread 1 sequence 4 ID 0x3ee0566e dest 1:\nThread 1 cannot allocate new log, sequence 6\nCheckpoint not complete\n  Current log# 1 seq# 5 mem# 0: \/u01\/app\/oracle\/oradata\/racdb\/redo01_2.log\nThread 1 advanced to log sequence 6 (LGWR switch)\n  Current log# 2 seq# 6 mem# 0: \/u01\/app\/oracle\/oradata\/racdb\/redo02_1.log\n  Current log# 2 seq# 6 mem# 1: \/u01\/app\/oracle\/oradata\/racdb\/redo02_2.log\nTue Dec 15 22:55:21 2020\nArchived Log entry 35 added for thread 1 sequence 5 ID 0x3ee0566e dest 1:<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1.\u67e5\u770bredo\u65e5\u5fd7 col member for<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,41],"tags":[],"class_list":["post-1189","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-41"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1189"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1189\/revisions"}],"predecessor-version":[{"id":1190,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1189\/revisions\/1190"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1189"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}