{"id":92,"date":"2020-11-23T08:04:54","date_gmt":"2020-11-23T08:04:54","guid":{"rendered":"http:\/\/101.32.12.22\/?p=92"},"modified":"2020-11-23T08:05:58","modified_gmt":"2020-11-23T08:05:58","slug":"%e4%bf%ae%e6%94%b9redo%e6%97%a5%e5%bf%97%e5%a4%a7%e5%b0%8f","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=92","title":{"rendered":"Oracle\u6570\u636e\u5e93\u4fee\u6539redo\u65e5\u5fd7\u5927\u5c0f"},"content":{"rendered":"

1\u3001\u67e5\u770b\u5f53\u524d\u7684\u65e5\u5fd7\u6587\u4ef6\u4fe1\u606f<\/strong><\/p>\n

SQL> select group#,status from v$log\u00a0;<\/p>\n

GROUP# STATUS
\n---------- ------------------------------------------------
\n1 CURRENT
\n2 INACTIVE<\/p>\n

SQL> select member from v$logfile;<\/p>\n

MEMBER
\n--------------------------------------------------------------------------------
\n\/oracle\/oradata\/test\/redo02.log
\n\/oracle\/oradata\/test\/redo01.log<\/p>\n

SQL> select bytes from v$log;<\/p>\n

BYTES
\n----------
\n52428800
\n52428800<\/p>\n

2\u3001\u589e\u52a02\u4e2aredo\u65e5\u5fd7\u7ec4<\/strong>
\nSQL> alter database add logfile thread 1 group 4 ('\/oracle\/oradata\/test\/redo04.log') size 30M;
\nalter database add logfile thread 1 group 5 ('\/oracle\/oradata\/test\/redo05.log') size 30M;
\nDatabase altered.<\/p>\n

SQL><\/p>\n

Database altered.<\/p>\n

SQL> select member from v$logfile;<\/p>\n

MEMBER
\n--------------------------------------------------------------------------------
\n\/oracle\/oradata\/test\/redo04.log
\n\/oracle\/oradata\/test\/redo02.log
\n\/oracle\/oradata\/test\/redo01.log
\n\/oracle\/oradata\/test\/redo05.log<\/p>\n

SQL> select group#,status from v$log;<\/p>\n

GROUP# STATUS
\n---------- ------------------------------------------------
\n1 CURRENT
\n2 INACTIVE
\n4 UNUSED
\n5 UNUSED<\/p>\n

3\u3001\u8fdb\u884c\u65e5\u5fd7\u5207\u6362\uff0c\u5207\u6362\u5230\u65b0\u7684\u7ec4\u4e0a\u3002<\/strong>
\nSQL> alter system switch logfile;<\/p>\n

System altered.<\/p>\n

SQL> select group#,status from v$log;<\/p>\n

GROUP# STATUS
\n---------- ------------------------------------------------
\n1 ACTIVE
\n2 INACTIVE
\n4 CURRENT\u00a0 \u00a0 \u00a0 ---\u300b\u5f53\u524d\u7684\u65e5\u5fd7\u7ec4
\n5 UNUSED<\/p>\n

SQL> select group#,status from v$log;<\/p>\n

GROUP# STATUS
\n---------- ------------------------------------------------
\n1 ACTIVE
\n2 INACTIVE
\n4 CURRENT
\n5 UNUSED<\/p>\n

\u7531\u4e8e\u65e5\u5fd7\u5207\u6362\u7684\u589e\u91cf\u68c0\u67e5\u70b9ACTIVE\u72b6\u6001\u6709\u53ef\u80fd\u4f1a\u5f88\u4e45\u624d\u4f1a\u53d8\u66f4\u4e3aINACTIVE\uff0c\u9700\u8981\u53d1\u5e03\u5168\u91cf\u68c0\u67e5\u70b9\u3002<\/p>\n

SQL> alter system checkpoint;<\/p>\n

System altered.<\/p>\n

SQL> select group#,status from v$log;<\/p>\n

GROUP# STATUS
\n---------- ------------------------------------------------
\n1 INACTIVE
\n2 INACTIVE
\n4 INACTIVE
\n5 CURRENT<\/p>\n

4\u3001\u5220\u9664group 1\u3001group 2<\/strong><\/p>\n

SQL> alter database drop logfile group 1;<\/p>\n

Database altered.<\/p>\n

SQL> alter database drop logfile group 2;<\/p>\n

Database altered.<\/p>\n

SQL> select group#,status from v$log;<\/p>\n

GROUP# STATUS
\n---------- ------------------------------------------------
\n4 INACTIVE
\n5 CURRENT<\/p>\n

SQL> alter system switch logfile;<\/p>\n

System altered.<\/p>\n

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

1\u3001\u67e5\u770b\u5f53\u524d\u7684\u65e5\u5fd7\u6587\u4ef6\u4fe1\u606f SQL> sel<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,18,19],"tags":[],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-oracle-10g","category-oracle-11g","category-oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/92","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=92"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":94,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/92\/revisions\/94"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}