{"id":79,"date":"2020-07-07T17:02:00","date_gmt":"2020-07-07T08:02:00","guid":{"rendered":"http:\/\/www.shamonabe.com\/?p=79"},"modified":"2020-07-07T17:02:01","modified_gmt":"2020-07-07T08:02:01","slug":"post-79","status":"publish","type":"post","link":"http:\/\/www.shamonabe.com\/?p=79","title":{"rendered":"REDO\u30ed\u30b0\u30e1\u30f3\u30d0\u30fc\u306e\u8ffd\u52a0"},"content":{"rendered":"<p>SQL&gt; set lin300<br \/>\ncol MEMBER for a60<br \/>\nselect * from v$logfile;SQL&gt; SQL&gt;<\/p>\n<p>GROUP# STATUS TYPE MEMBER IS_<br \/>\n\u2014\u2014\u2014- \u2014\u2014- \u2014\u2014- \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 \u2014<br \/>\n3 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03.log NO<br \/>\n2 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02.log NO<br \/>\n1 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01.log NO<\/p>\n<p>\u25a0\u30b0\u30eb\u30fc\u30d7\uff11\u306b\u30e1\u30f3\u30d0\u3092\u8ffd\u52a0<br \/>\nSQL&gt; alter database add logfile member \u2018\/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01_2.log\u2019 to group 1;<\/p>\n<p>Database altered.<\/p>\n<p>SQL&gt; select * from v$logfile;<\/p>\n<p>GROUP# STATUS TYPE MEMBER IS_<br \/>\n\u2014\u2014\u2014- \u2014\u2014- \u2014\u2014- \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 \u2014<br \/>\n3 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03.log NO<br \/>\n2 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02.log NO<br \/>\n1 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01.log NO<br \/>\n1 INVALID ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01_2.log NO<\/p>\n<p>\u25a0\u30b0\u30eb\u30fc\u30d7\uff11\u306b\u30e1\u30f3\u30d0\u3092\u8ffd\u52a0<br \/>\nSQL&gt; alter database add logfile member \u2018\/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02_2.log\u2019 to group 2;<\/p>\n<p>Database altered.<\/p>\n<p>\u25a0\u30b0\u30eb\u30fc\u30d7\uff11\u306b\u30e1\u30f3\u30d0\u3092\u8ffd\u52a0<br \/>\nSQL&gt; alter database add logfile member \u2018\/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03_2.log\u2019 to group 3;<\/p>\n<p>Database altered.<\/p>\n<p>SQL&gt; select * from v$logfile;<\/p>\n<p>GROUP# STATUS TYPE MEMBER IS_<br \/>\n\u2014\u2014\u2014- \u2014\u2014- \u2014\u2014- \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 \u2014<br \/>\n3 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03.log NO<br \/>\n2 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02.log NO<br \/>\n1 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01.log NO<br \/>\n1 INVALID ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01_2.log NO<br \/>\n2 INVALID ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02_2.log NO<br \/>\n3 INVALID ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03_2.log NO<\/p>\n<p>6 rows selected.<\/p>\n<p>\u25a0\u30e1\u30f3\u30d0\u8ffd\u52a0\u5f8c\u306f\u30b9\u30c6\u30fc\u30bf\u30b9\u304cINVALID\u306b\u306a\u308b\u306e\u3067\u3001\u30ed\u30b0\u30fb\u30b9\u30a4\u30c3\u30c1\u306e\u5f37\u5236\u5b9f\u884c\u3092\u304a\u3053\u306a\u3046\u3002<\/p>\n<p>SQL&gt; alter system switch logfile;<\/p>\n<p>System altered.<\/p>\n<p>INVALID\u306b\u306a\u3063\u3066\u3044\u308b\u30b0\u30eb\u30fc\u30d7\u306b\u30b9\u30a4\u30c3\u30c1\u3059\u308b\u3068STATUS\u304cONLINE\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\nSQL&gt; select * from v$logfile;<\/p>\n<p>GROUP# STATUS TYPE MEMBER IS_<br \/>\n\u2014\u2014\u2014- \u2014\u2014- \u2014\u2014- \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 \u2014<br \/>\n3 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03.log NO<br \/>\n2 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02.log NO<br \/>\n1 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01.log NO<br \/>\n1 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01_2.log NO<br \/>\n2 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02_2.log NO<br \/>\n3 ONLINE \/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03_2.log NO<\/p>\n<p>*********************************\u30b3\u30de\u30f3\u30c9*********************************<\/p>\n<p>REDO\u30ed\u30b0\u30b9\u30c6\u30fc\u30bf\u30b9\u78ba\u8a8d<br \/>\nselect * from v$log;<\/p>\n<p>REDO\u30ed\u30b0\u78ba\u8a8d<br \/>\nset lin300<br \/>\ncol MEMBER for a60<br \/>\nselect * from v$logfile;<\/p>\n<p>\u30ed\u30b0\u30fb\u30b9\u30a4\u30c3\u30c1\u306e\u5f37\u5236\u5b9f\u884c<br \/>\nalter system switch logfile;<br \/>\n\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u306e\u5f37\u5236\u5b9f\u884c<br \/>\nALTER SYSTEM CHECKPOINT;<\/p>\n<p>REDO\u30ed\u30b0\u30e1\u30f3\u30d0\u30fc\u306e\u8ffd\u52a0<br \/>\nalter database add logfile member \u2018\/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01_2.log\u2019 to group 1;<br \/>\nalter database add logfile member \u2018\/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo02_2.log\u2019 to group 2;<br \/>\nalter database add logfile member \u2018\/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo03_2.log\u2019 to group 3;<\/p>\n<p>REDO\u30ed\u30b0\u30e1\u30f3\u30d0\u30fc\u306e\u524a\u9664<br \/>\nalter database drop logfile member \u2018\/opt\/oracle\/product\/10.2.0\/oradata\/orcl\/redo01_2.log\u2019;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL&gt; set lin300 col MEMBER for a60 select * from v$logfil<\/p>\n<p><a class=\"more-link\" href=\"http:\/\/www.shamonabe.com\/?p=79\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/79"}],"collection":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=79"}],"version-history":[{"count":1,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/79\/revisions"}],"predecessor-version":[{"id":80,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/79\/revisions\/80"}],"wp:attachment":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=79"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=79"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}