{"height":"190","type":"rich","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/HTN20190109/","published":"2019-04-14 00:09:15","author_name":"HTN20190109","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F04%2F14%2F000915\" title=\"\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"url":"https://htn20190109.hatenablog.com/entry/2019/04/14/000915","categories":["DB"],"provider_url":"https://hatena.blog","version":"1.0","blog_title":"HTN20190109\u306e\u65e5\u8a18","blog_url":"https://htn20190109.hatenablog.com/","title":"\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a","description":"Oracle --------------------\u30d5\u30a1\u30a4\u30eb\u30b3\u30d4\u30fc\u306b\u3088\u308b\u65b9\u6cd5-------------------- (12cR1)--\u975e\u540c\u671f\u30d5\u30a3\u30b8\u30ab\u30eb\u30fb\u30b9\u30bf\u30f3\u30d0\u30a4 --\u524d\u63d0\u30d7\u30e9\u30a4\u30de\u30ea\uff1a\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068DB\u4f5c\u6210\u3092\u5b9f\u65bd\u30bb\u30ab\u30f3\u30c0\u30ea\uff1a\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u5b9f\u65bd --1.\u5f37\u5236\u30ed\u30ae\u30f3\u30b0\u306e\u6709\u52b9\u5316[\u30d7\u30e9\u30a4\u30de\u30ea\u3067\u5b9f\u65bd]select force_logging FROM v$database;ALTER DATABASE FORCE LOGGING; --2.\u30b9\u30bf\u30f3\u30d0\u30a4REDO\u30ed\u30b0\u4f5c\u6210[\u30d7\u30e9\u30a4\u30de\u30ea\u3067\u5b9f\u65bd]SELECT group#,type,member FROM v$logfile;SELECT group#,byt\u2026"}