{"id":877,"date":"2024-03-11T11:16:54","date_gmt":"2024-03-11T03:16:54","guid":{"rendered":"https:\/\/www.furyblog.com\/?p=877"},"modified":"2024-03-11T11:16:55","modified_gmt":"2024-03-11T03:16:55","slug":"oracle%e9%97%aa%e5%9b%9e%e5%b8%b8%e7%94%a8%e5%91%bd%e4%bb%a4%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91","status":"publish","type":"post","link":"https:\/\/www.furyblog.com\/?p=877","title":{"rendered":"Oracle\u95ea\u56de\u5e38\u7528\u547d\u4ee4\u3010\u5907\u5fd8\u3011"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\/*\r\n\u3010\u5371\u9669\uff01\u3011\u95ea\u56de\u5230\u6307\u5b9a\u65f6\u95f4\u7684\u6570\u636e\u5e93\u72b6\u6001\u5e76\u6e05\u9664\u8fd9\u6bb5\u65f6\u95f4\u7684\u64cd\u4f5c\u65e5\u5fd7\u3002\r\n*\/\r\nSHUTDOWN IMMEDIATE;\r\nSTARTUP MOUNT;\r\nFLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2024-03-01 10:00:00', 'YYYY-MM-DD HH24:MI:SS');\r\nALTER DATABASE OPEN RESETLOGS;\r\n\r\n\r\n\/*\r\n\u67e5\u8be2\u95ea\u56de\u529f\u80fd\u662f\u5426\u5f00\u542f\r\n*\/\r\nSELECT FLASHBACK_ON FROM V$DATABASE;\r\n\r\n\/*\r\n\u6253\u5f00\u95ea\u56de\u529f\u80fd\r\n*\/\r\nSHUTDOWN IMMEDIATE;\r\nSTARTUP MOUNT;\r\nALTER DATABASE FLASHBACK ON;\r\nALTER DATABASE OPEN;\r\n\r\n\/*\r\n\u914d\u7f6e\u53ef\u95ea\u56de\u7684\u65f6\u95f4\u6bb5\uff0c\u4ee5\u5206\u949f\u4e3a\u5355\u4f4d\r\n*\/\r\nALTER SYSTEM SET db_flashback_retention_target=4320 SCOPE=BOTH;\r\n\r\n\/*\r\n\u67e5\u8be2\u5f53\u524d\u914d\u7f6e\u7684\u53ef\u95ea\u56de\u65f6\u95f4\r\n*\/\r\nSELECT \r\n    VALUE AS \"\u95ea\u56de\u4fdd\u7559\u65f6\u95f4\uff08\u5206\u949f\uff09\", \r\n    VALUE\/60 AS \"\u95ea\u56de\u4fdd\u7559\u65f6\u95f4\uff08\u5c0f\u65f6\uff09\" \r\nFROM V$PARAMETER \r\nWHERE NAME = 'db_flashback_retention_target';\r\n\r\n\r\n\r\n\/*\r\n\u67e5\u770bFRA\u7a7a\u95f4\u5404\u6587\u4ef6\u7c7b\u578b\u5360\u7528\u60c5\u51b5\r\n*\/\r\nSELECT \r\n    FILE_TYPE AS \u6587\u4ef6\u7c7b\u578b, \r\n    PERCENT_SPACE_USED AS \u5df2\u4f7f\u7528\u7a7a\u95f4\u767e\u5206\u6bd4, \r\n    PERCENT_SPACE_RECLAIMABLE AS \u53ef\u56de\u6536\u7a7a\u95f4\u767e\u5206\u6bd4, \r\n    NUMBER_OF_FILES AS \u6587\u4ef6\u6570\u91cf \r\nFROM V$FLASH_RECOVERY_AREA_USAGE;\r\n\r\n\/*\r\n\u67e5\u770bFRA\u7a7a\u95f4\u5360\u7528\u60c5\u51b5\r\n*\/\r\nSELECT \r\n    ROUND((SPACE_LIMIT \/ 1024 \/ 1024 \/1024), 2) AS \u603b\u7a7a\u95f4_GB, \r\n    ROUND((SPACE_USED \/ 1024 \/ 1024 \/1024), 2) AS \u5df2\u4f7f\u7528\u7a7a\u95f4_GB, \r\n    ROUND((SPACE_RECLAIMABLE \/ 1024 \/ 1024 \/ 1024), 2) AS \u53ef\u56de\u6536\u7a7a\u95f4_GB, \r\n    NUMBER_OF_FILES AS \u6587\u4ef6\u6570\u91cf \r\nFROM V$RECOVERY_FILE_DEST;\r\n\r\n\/*\r\n\u67e5\u8be2\u6700\u65e9\u53ef\u95ea\u56de\u65f6\u95f4\u70b9\r\n*\/\r\nSELECT\r\n\tOLDEST_FLASHBACK_SCN AS SCN,\r\n\tOLDEST_FLASHBACK_TIME AS \u6700\u65e9\u53ef\u95ea\u56de\u65f6\u95f4 \r\nFROM\r\n\tV$FLASHBACK_DATABASE_LOG;\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":879,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[],"topic":[],"class_list":["post-877","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-45"],"_links":{"self":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts\/877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=877"}],"version-history":[{"count":1,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts\/877\/revisions"}],"predecessor-version":[{"id":878,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts\/877\/revisions\/878"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/media\/879"}],"wp:attachment":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=877"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftopic&post=877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}