{"categories":["DB"],"blog_title":"HTN20190109\u306e\u65e5\u8a18","published":"2019-05-06 16:16:05","author_name":"HTN20190109","url":"https://htn20190109.hatenablog.com/entry/2019/05/06/161605","blog_url":"https://htn20190109.hatenablog.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F05%2F06%2F161605\" title=\"\u30a2\u30fc\u30ab\u30a4\u30d6\u30ed\u30b0\u524a\u9664 - 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>","provider_url":"https://hatena.blog","image_url":null,"version":"1.0","title":"\u30a2\u30fc\u30ab\u30a4\u30d6\u30ed\u30b0\u524a\u9664","provider_name":"Hatena Blog","width":"100%","author_url":"https://blog.hatena.ne.jp/HTN20190109/","height":"190","type":"rich","description":"Oracle rman target / list archivelog all; delete archivelog until time 'sysdate - 20'; MySQL \u203b\u6307\u5b9a\u3055\u308c\u305f\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u540d\u307e\u305f\u306f\u65e5\u4ed8\u306e\u524d\u306b\u3042\u308b\u30ed\u30b0\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30d5\u30a1\u30a4\u30eb\u306b\u30ea\u30b9\u30c8\u3055\u308c\u3066\u3044\u308b\u3059\u3079\u3066\u306e\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3057\u307e\u3059\u3002 purge BINARY logs before '2019-12-05 08:00:00';purge BINARY logs to 'mysqld-bin.000026'; --\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u5168\u524a\u9664\u3010\u5371\u967a\u3011reset master; PostgreSQL /usr/pgsql-\u2026"}