{"id":38,"date":"2025-07-17T10:34:22","date_gmt":"2025-07-17T02:34:22","guid":{"rendered":"https:\/\/www.shoubashou.com\/?p=38"},"modified":"2025-07-17T10:34:22","modified_gmt":"2025-07-17T02:34:22","slug":"%e7%89%a9%e7%90%86%e5%a4%87%e4%bb%bd%e6%81%a2%e5%a4%8d%e9%97%ae%e9%a2%98%e6%8e%92%e6%9f%a5%e7%9b%b8%e5%85%b3","status":"publish","type":"post","link":"https:\/\/www.shoubashou.com\/?p=38","title":{"rendered":"\u7269\u7406\u5907\u4efd\u6062\u590d\u95ee\u9898\u6392\u67e5\u76f8\u5173"},"content":{"rendered":"\n

\u672c\u6587\u9488\u5bf9\u7684\u7fa4\u4f53\uff0c\u662f\u5df2\u7ecf\u5bf9\u5907\u4efd\u6062\u590d\u7684\u57fa\u672c\u539f\u7406\u4e86\u89e3\u7684\u7528\u6237\u7fa4\u3002\u7b14\u8005\u4ece\u5185\u90e8\u4f7f\u7528\uff0c\u5916\u90e8\u7528\u6237\u7b49\u6e20\u9053\u6536\u96c6\u7684\u76f8\u5173\u5907\u4efd\u548c\u6062\u590d\u8fc7\u7a0b\u6bd4\u8f83\u5e38\u89c1\u7684\u95ee\u9898\uff0c\u8fdb\u884c\u4e86\u76f8\u5173\u7684\u6392\u67e5\u7ecf\u9a8c\u68b3\u7406\u3002\u5bf9\u4e8e\u521a\u63a5\u89e6\u5907\u4efd\u6062\u590d\u7684\u7528\u6237\uff0c\u5efa\u8bae\u5148\u53bb\u5f00\u6e90\u5b98\u7f51\u4e86\u89e3\u76f8\u5173\u77e5\u8bc6\uff1aOceanBase \u5907\u4efd\u4e0e\u6062\u590d 29<\/a><\/p>\n\n\n\n

\u5907\u4efd\u4e0e\u6062\u590d\u662f\u6570\u636e\u5e93\u9ad8\u53ef\u7528\u4e2d\u975e\u5e38\u91cd\u8981\u7684\u73af\u8282\u4e4b\u4e00, \u4e5f\u662f DBA \u65e5\u5e38\u5de5\u4f5c\u4e2d\u57fa\u7840\u7684\u4e00\u73af, \u5f53\u5e94\u7528\u4e1a\u52a1\u903b\u8f91\u53d1\u751f\u9519\u8bef, \u4ea7\u751f\u5927\u91cf\u810f\u6570\u636e\u65f6, \u6216\u8005\u5f53 DBA \u6216\u5e94\u7528\u8bef\u5220\u6570\u636e\u65f6, \u6216\u8005\u5f53\u9700\u8981\u5c06\u6570\u636e\u4ece\u4e00\u4e2a\u96c6\u7fa4\u8fc1\u79fb\u5230\u53e6\u5916\u4e00\u4e2a\u96c6\u7fa4\u5f0f, \u90fd\u53ef\u80fd\u9700\u8981\u4f7f\u7528\u4e0a\u5907\u4efd\u4e0e\u6062\u590d\u3002\u5728 OceanBase \u4e2d\uff0c\u5907\u4efd\u4e0e\u6062\u590d\u662f OceanBase \u6570\u636e\u9ad8\u53ef\u9760\u7684\u6838\u5fc3\u7ec4\u4ef6\uff0c\u901a\u8fc7\u7eaf SQL \u7684\u547d\u4ee4\u5c31\u53ef\u4ee5\u4f7f\u7528\u5b8c\u6574\u7684\u5907\u4efd\u548c\u6062\u590d\u529f\u80fd\u3002<\/p>\n\n\n\n

<\/a><\/a>\u6392\u67e5\u601d\u8def<\/h1>\n\n\n\n

1\uff09\u6839\u636e\u89c6\u56fe\u6216\u5185\u90e8\u8868\uff0c\u627e\u5230\u5173\u952e\u4fe1\u606f\uff0c\u4f8b\u5982\u62a5\u9519\u673a\u5668ip\uff0c\u9519\u8bef\u7801\uff0c\u5907\u4efd\u72b6\u6001\uff0ctrace_id\uff0c\u4e8b\u53d1\u65f6\u95f4\u6233\u7b49<\/p>\n\n\n\n

2\uff09\u5229\u7528\u5173\u952e\u4fe1\u606f\uff0c\u5230\u5bf9\u5e94\u673a\u5668\u4e0a\u5168\u5c40\u641c\u7d22\u5e76\u8fc7\u6ee4\u65e5\u5fd7\uff0c\u4e00\u822c\u90fd\u80fd\u4ece\u65e5\u5fd7\u4e2d\u627e\u5230\u9519\u8bef\u539f\u56e0<\/p>\n\n\n\n

3\uff09\u5982\u679c\u4e0a\u8ff0\u4e24\u6b65\u4e0d\u80fd\u89e3\u51b3\uff0c\u5230 \u793e\u533a\u5b98\u7f51<\/a> \u6216\u9489\u9489\u4ea4\u6d41\u7fa4 (ID:33254054) \u6c42\u52a9<\/p>\n\n\n\n

<\/a><\/a>\u5907\u4efd\u95ee\u9898<\/h1>\n\n\n\n

<\/a><\/a>\u5173\u952e\u5185\u90e8\u8868\/\u89c6\u56fe<\/h2>\n\n\n\n
<\/th><\/th><\/tr><\/thead>
CDB_OB_BACKUP_PROGRESS<\/td>\u67e5\u770b\u5907\u4efd\u4efb\u52a1\u60c5\u51b5<\/td><\/tr>
__all_rootservice_event_history<\/td>\u67e5\u770bRS\u5386\u53f2\u4efb\u52a1\uff08\u5305\u62ec\u5907\u4efd\u6062\u590d\uff09<\/td><\/tr>
__all_virtual_pg_backup_log_archive_status<\/td>\u67e5\u770b\u5206\u533a\u7ea7\u65e5\u5fd7\u5907\u4efd\u72b6\u6001<\/td><\/tr>
__all_restore_info<\/td>\u67e5\u770b\u6062\u590d\u4efb\u52a1\u72b6\u6001<\/td><\/tr>
__all_restore_history<\/td>\u67e5\u770b\u6062\u590d\u5386\u53f2\u8bb0\u5f55<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/a><\/a>\u67e5\u770b\u6700\u8fd1\u7684\u5907\u4efd\u4e8b\u4ef6<\/h2>\n\n\n\n
select<\/strong> * from<\/strong> __all_rootservice_event_history where<\/strong> event like<\/strong> '%backup%' order<\/strong> by<\/strong> gmt_create desc<\/strong> limit 30;\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u67e5\u770b\u5206\u533a\u7684\u5907\u4efd\u8fdb\u5ea6<\/h2>\n\n\n\n
select<\/strong> * from<\/strong>  __all_virtual_pg_backup_log_archive_status where<\/strong> table_id=xxx and<\/strong> partition_id=yyy;\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u67e5\u770b\u5355\u4e2a OBServer \u4e0a\u6240\u6709\u5206\u533a\u5f52\u6863\u843d\u540e\u7684\u65e5\u5fd7\u603b\u6761\u6570<\/h2>\n\n\n\n
select<\/strong> sum(max_log_id-log_archive_cur_log_id) from<\/strong> __all_virtual_pg_backup_log_archive_status where<\/strong> svr_ip=\"xxx\" and<\/strong> svr_port=yyy;\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u67e5\u770b\u67d0\u4e2a\u5206\u533a\u5f52\u6863\u662f\u5426\u5728\u5f52\u6863<\/h2>\n\n\n\n
select<\/strong> * from<\/strong> __all_virtual_pg_log_archive_stat where<\/strong> table_id=xxx and<\/strong> partition_id=yyy; \/\/ \u67e5\u770b\u662f\u5426\u6709server\u5728\u4e3a\u8be5\u5206\u533a\u5f52\u6863\uff0c\u4ee5\u53ca\u5b9e\u65f6\u7684\u5f52\u6863\u72b6\u6001<\/em>\nselect<\/strong> * from<\/strong> __all_virtual_clog_stat where<\/strong> table_id=xxx and<\/strong> partition_idx=yyy; \/\/ \u67e5\u770b\u5206\u533a\u662f\u5426\u4e3aleader\uff0c\u4ee5\u53ca\u5206\u533a\u6240\u5728\u673a\u5668ip\u5730\u5740<\/em>\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u6392\u67e5\u65e5\u5fd7\u5907\u4efd\u6700\u6162\u7684 pg<\/h2>\n\n\n\n
select<\/strong> usec_to_time<\/strong>(log_archive_cur_ts), * from<\/strong> __all_virtual_pg_backup_log_archive_status order by<\/strong> log_archive_cur_ts limit 10;\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u6392\u67e5\u57fa\u7ebf\u5907\u4efd\u5931\u8d25\u4efb\u52a1<\/h2>\n\n\n\n
\u901a\u8fc7\u8fc7\u6ee4\u5df2\u7ecf\u5b8c\u6210\u7684\u5907\u4efd\u4e8b\u4ef6\u7684\u9519\u8bef\u7801\u6765\u7b5b\u9009\u51fa\u5931\u8d25\u5907\u4efd\u4efb\u52a1<\/p>\n\n\n\n
select<\/strong> * from<\/strong> __all_rootservice_event_history where<\/strong> event<\/strong> like '%finish_backup%' and<\/strong> order by<\/strong> gmt_create desc and<\/strong> value4 not<\/strong> in<\/strong> (0, -4268, -4554) limit 30; \/\/ \u5176\u4e2dvalue4\u4e3aresult\u5b57\u6bb5\uff0c\u4e3a\u5907\u4efd\u4efb\u52a1\u7684\u9519\u8bef\u7801\u4fe1\u606f <\/em>\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u6392\u67e5\u6700\u8fd1\u7684\u5907\u4efd\u4efb\u52a1\u60c5\u51b5<\/h2>\n\n\n\n
select<\/strong> * from<\/strong> __all_rootservice_event_history where<\/strong> event like<\/strong> '%backup%' order<\/strong> by<\/strong> gmt_create desc<\/strong> limit 10;\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u6392\u67e5\u5355\u4e2a pg \u7684\u5907\u4efd\u60c5\u51b5<\/h2>\n\n\n\n
select<\/strong> * from<\/strong> __all_rootservice_event_history where<\/strong> event<\/strong> like '%backup%' and<\/strong> value1 like 'xxx' \/\/ \u5176\u4e2dxxx\u4e3atable_id<\/em>\n<\/code><\/pre>\n\n\n\n
<\/a><\/a>\u6267\u884c\u5907\u4efd\u540e\uff0c\u5907\u4efd\u8def\u5f84\u4e0b\u6ca1\u6709 data \u6587\u4ef6<\/h2>\n\n\n\n
\u53ef\u80fd\u7684\u539f\u56e0\u662f\uff0c\u96c6\u7fa4\u4e2d\u53ea\u6709 sys \u79df\u6237\uff0c\u6ca1\u6709\u65b0\u5efa\u5176\u4ed6\u79df\u6237\uff0c\u7531\u4e8e\u7cfb\u7edf\u79df\u6237\u4e0b\u7684\u6570\u636e\u4e0d\u5907\u4efd\uff0c\u56e0\u6b64\u6ca1\u6709 data \u6587\u4ef6\u662f\u6b63\u5e38\u73b0\u8c61\u3002<\/p>\n\n\n\n
<\/a><\/a>\u6392\u67e5\u5907\u4efd\u6587\u4ef6\u6ca1\u6709\u81ea\u52a8\u5220\u9664<\/h2>\n\n\n\n
\u9996\u5148\uff0c\u5907\u4efd\u6e05\u7406\u76f8\u5173\u53ef\u53c2\u8003\uff1a\u5907\u4efd\u81ea\u52a8\u6e05\u7406 9<\/a><\/p>\n\n\n\n
\u5176\u6b21\uff0c\u53ef\u4ee5\u4ece\u4e24\u4e2a\u89d2\u5ea6\u6392\u67e5<\/p>\n\n\n\n
1\uff09\u67e5\u7cfb\u7edf\u53d8\u91cf\u786e\u8ba4\u81ea\u52a8\u5220\u9664\u5f00\u5173\u662f\u5426\u6253\u5f00\uff08\u67e5\u770b \u201cvalue\u201d \u5b57\u6bb5\u662f\u5426\u4e3a\u201ctrue\u201d\uff09<\/p>\n\n\n\n
show<\/strong> parameters like<\/strong> \"%auto_delete_expired_backup%\";\n<\/code><\/pre>\n\n\n\n
2\uff09\u82e5\u4e0a\u8ff0\u786e\u8ba4\u81ea\u52a8\u5f00\u5173\u5df2\u7ecf\u6253\u5f00\u540e\uff0c\u53ef\u901a\u8fc7\u4ee5\u4e0b\u51e0\u6b65\u6392\u67e5\uff1a<\/p>\n\n\n\n
    \n
  1. \u67e5\u770b CDB_OB_BACKUP_CLEAN_HISTORY \u89c6\u56fe\uff0c\u786e\u5b9a\u4e0a\u4e00\u6b21\u5907\u4efd\u6e05\u7406\u7684\u65f6\u95f4\u70b9\uff0c\u5047\u8bbe\u4e3a t1<\/li>\n\n\n\n
  2. \u67e5\u770b CDB_OB_BACKUP_SET_DETAILS \u89c6\u56fe\uff0c\u786e\u8ba4\u6700\u8fd1\u5907\u4efd\u7684\u5f00\u59cb\u65f6\u95f4\u70b9\uff0c\u5047\u8bbe\u4e3a t2<\/li>\n\n\n\n
  3. \u67e5\u770b backup_recovery_window \u7cfb\u7edf\u53c2\u6570\uff0c\u9ed8\u8ba4\u4e3a 7d\uff08\u4fdd\u75597\u5929\u5907\u4efd\u6570\u636e\uff09<\/li>\n\n\n\n
  4. \u901a\u8fc7\u5907\u4efd\u6587\u4ef6\u6e05\u7406\u7684\u65f6\u95f4\u70b9\uff0c\u7ed3\u5408\u7cfb\u7edf\u53c2\u6570 backup_recovery_window \u7684\u503c\uff0c\u4ee5\u53ca\u4e0a\u4e00\u6b21\u5907\u4efd\u6587\u4ef6\u7684\u65f6\u95f4\u70b9\uff0c\u6765\u5224\u65ad\u54ea\u4e9b\u5907\u4efd\u6587\u4ef6\u9700\u8981\u4fdd\u7559<\/li>\n<\/ol>\n\n\n\n
    \u6211\u4eec\u4e0d\u59a8\u5047\u8bbe\u67d0\u4e2a\u79df\u6237\u6700\u8fd1\u7684\u5907\u4efd\u65f6\u95f4 t2 \u4e3a2022\u5e742\u670813\u65e520:00\uff0c\u4e0a\u4e00\u6b21\u81ea\u52a8\u6e05\u7406\u89e6\u53d1\u7684\u65f6\u95f4 t1 \u4e3a2022\u5e742\u670820\u65e518:00\uff0c\u6839\u636e\u5f53\u524d\u81ea\u52a8\u6e05\u9664\u7684\u903b\u8f91\uff0c\u4f1a\u4fdd\u7559 backup_recovery_window\uff087\u5929\uff09\u5185\u7684\u5907\u4efd\u6570\u636e\uff0c\u56e0\u6b64\u4f1a\u4fdd\u75592022\u5e742\u670813\u65e518:00 \u52302022\u5e74 2\u670820\u65e518:00\u4e4b\u95f4\u7684\u5907\u4efd\u6570\u636e\uff0c\u4f46\u7531\u4e8e2\u670813\u65e5\u7684\u5907\u4efd\u6587\u4ef6\u65f6\u95f4\u4e3a20:00\uff0c\u56e0\u6b64\u4f1a\u5b58\u57282\u670813\u65e518:00\u52302\u670813\u65e520:00\u4e24\u4e2a\u5c0f\u65f6\u7684\u5907\u4efd\u6587\u4ef6\u7684\u7a7a\u6d1e\uff0c\u4e3a\u4e86\u4fdd\u8bc1\u6062\u590d\u7684\u5b8c\u6574\u6027\uff0c\u6b64\u65f6\u4f1a\u4fdd\u7559\u4e0a\u4e0a\u6b21\u7684\u5907\u4efd\u6587\u4ef6\uff0c\u4e5f\u5c31\u662f\u8bf4\u5907\u4efd\u6587\u4ef6\u4e4b\u95f4\u5b58\u5728\u5bf9\u66f4\u65e9\u7248\u672c\u7684\u4f9d\u8d56\uff0c\u5373\u7cfb\u7edf\u4f1a\u4fdd\u75592022\u5e742\u67087\u53f7\u7684\u5907\u4efd\u6587\u4ef6\uff0c\u8fd9\u5c31\u53ef\u80fd\u4f1a\u8ba9\u7528\u6237\u8ba4\u4e3a\u8fc7\u671f\u7684\u5907\u4efd\u6587\u4ef6\u6ca1\u6709\u5220\u9664\u3002<\/p>\n\n\n\n
    <\/a><\/a>\u6392\u67e5\u65e5\u5fd7\u5907\u4efd\u65ad\u6d41<\/h2>\n\n\n\n
    \u53ef\u4ee5\u4ece\u4e24\u4e2a\u89d2\u5ea6\u770b<\/p>\n\n\n\n
    1\uff09OBServer \u7684 event \u8868\uff0c\u5982\u679c\u786e\u8ba4\u662f OBServer \u62a5\u7684\u65ad\u6d41\uff0c\u53ef\u4ee5\u4ece\u8fd9\u4e2a\u8868\u627e\u5230\u3002<\/p>\n\n\n\n
    2\uff09RootService \u7684 event \u8868\uff0c\u5982\u679c\u662f RS \u89e6\u53d1\u7684\u65ad\u6d41\uff0c\u53ef\u4ee5\u4ece\u8fd9\u4e2a\u8868\u627e\u5230\u3002<\/p>\n\n\n\n
    <\/a><\/a>\u6392\u67e5 __all_server_event_history \u8868<\/h4>\n\n\n\n
    select<\/strong> * from<\/strong> __all_server_event_history where<\/strong> event like<\/strong> '%mark_fatal_error%' order<\/strong> by<\/strong> gmt_create desc<\/strong> limit 30;\n<\/code><\/pre>\n\n\n\n
    \u5982\u679c\u4e0a\u8ff0\u547d\u4ee4\u6267\u884c\u540e\uff0c\u663e\u793a\u201cevent\u201d\u4e00\u680f\u4e3a\u201cmark_fatal_error\u201d\uff0c\u5219\u67e5\u770b\u8be5\u884c\u5bf9\u5e94\u7684 svr_ip\uff0c\u6700\u540e\u4ece\u8be5 ip \u673a\u5668\u7684 log \u65e5\u5fd7\u641c\u9519\u8bef\u6253\u5370\uff1b<\/p>\n\n\n\n
    <\/a><\/a>\u6392\u67e5 __all_rootservice_event_history \u8868<\/h4>\n\n\n\n
    select<\/strong> * from<\/strong> __all_rootservice_event_history where<\/strong> module<\/strong> like<\/strong> '%archive%' order<\/strong> by<\/strong> gmt_create desc<\/strong> limit 30;\n<\/code><\/pre>\n\n\n\n
    \u4e0a\u8ff0\u547d\u4ee4\u6267\u884c\u540e\uff0c\u5982\u679c\u5728\u201cvalue1\u201d\u4e00\u680f\u4e2d\u51fa\u73b0\u5173\u952e\u5b57\u201cINTERRUPTED\u201d\uff0c\u5219\u67e5\u770b\u8be5\u884c\u5bf9\u5e94\u7684 RS ip \u5730\u5740\uff0c\u9700\u8981\u5230\u5bf9\u5e94\u7684 OBServer \u673a\u5668\u4e0a\u67e5\u770b RS \u7684\u65e5\u5fd7\u3002\u4e0b\u5217\u4e3a RS \u7684\u9519\u8bef\u65e5\u5fd7\u6253\u5370\u793a\u4f8b\uff1a<\/p>\n\n\n\n
    [2020-06-01 22:24:25.476910] ERROR [SHARE] fetch_log_archive_backup_status_map_ (ob_log_archive_scheduler.cpp:1231) [8863][618]\n[YB426458A15C-0005A704C89C96CD] [lt=3] [LOG_ARCHIVE] log archive status is interrupted, need human intervention(ret=-9027, addr=\"xxx\", \nstatus={tenant_id:1003, start_ts:1591013841337584, checkpoint_ts:1591021437430755, status:5, incarnation:1, round:1, status_str:\"INTERRUPTED\"}) \n<\/code><\/pre>\n\n\n\n
    \u4e0a\u8ff0\u4e24\u79cd\u65b9\u6cd5\u7684\u601d\u8def\u662f\u627e\u5230\u62a5\u9519\u4fe1\u606f\u7684\u673a\u5668\uff0c\u518d\u6839\u636e\u9519\u8bef\u7801\u4ee5\u53ca trace_id\uff08\u4e0a\u8ff0\u4e3aYB426458A15C-0005A704C89C96CD\uff09\u8fdb\u884c\u5168\u65e5\u5fd7\u641c\u7d22\u6392\u67e5\u95ee\u9898\u539f\u56e0\uff0c\u4e00\u822c\u53ef\u4ee5\u4ece\u65e5\u5fd7\u4e2d\u627e\u5230\u95ee\u9898\u6839\u56e0\u3002<\/p>\n\n\n\n
    <\/a><\/a>\u6392\u67e5\u65e5\u5fd7\u5907\u4efd\u5361\u5728\u67d0\u4e2a\u9636\u6bb5<\/h2>\n\n\n\n
    \u6ce8\u610f\uff1a\u4ee5\u4e0b SQL \u67e5\u8be2\u90fd\u4f7f\u7528 sys \u79df\u6237\u767b\u5f55\u96c6\u7fa4<\/strong><\/p>\n\n\n\n
    <\/a><\/a>RootService \u5361\u5728 beginning \u9636\u6bb5<\/h3>\n\n\n\n
    \u6392\u67e5\u601d\u8def<\/strong><\/p>\n\n\n\n
    1\u3001\u786e\u5b9a\u8be5\u79df\u6237\u5f52\u6863\u72b6\u6001<\/p>\n\n\n\n
    a. \u6267\u884c SQL \u8bed\u53e5 select * from CDB_OB_BACKUP_ARCHIVELOG; \u786e\u5b9a status \u662f BEGINNING \u72b6\u6001<\/p>\n\n\n\n
    2\u3001\u770b\u54ea\u4e2a\u5206\u533a\u9020\u6210\u7684\u843d\u540e<\/p>\n\n\n\n
    a. \u6267\u884c SQL \u8bed\u53e5 select * from __all_virtual_pg_backup_log_archive_status order by log_archive_cur_ts limit 10\uff1b\u5176\u4e2d log_archive_cur_ts \u5217\u8868\u793a\u8be5\u5206\u533a\u8be5\u526f\u672c\u5f53\u524d\u5f52\u6863\u8fdb\u5ea6\uff0c\u627e\u5230\u843d\u540e\u5206\u533a\u3002log_archive_status\u4e3a3\u8868\u793adoing\uff0c1 \u8868\u793a stop\uff0c0 \u8868\u793a invalid\uff08\u521d\u59cb\u72b6\u6001\uff09<\/p>\n\n\n\n
    b. \u6267\u884c SQL \u8bed\u53e5 select * from __all_virtual_clog_stat where table_id=xxx and partition_idx=yyy; \u67e5\u770b\u8be5\u5206\u533a\u662f\u5426\u6709 LEADER\uff0c\u5982\u679c\u65e0\u4e3b\u662f\u65e0\u6cd5\u505a\u5f52\u6863\u7684<\/p>\n\n\n\n
    c. \u5982\u679c\u786e\u5b9a\u662f\u6709 leader \u7684\uff0c\u6267\u884c SQL \u8bed\u53e5 select * from __all_virtual_pg_log_archive_stat where table_id=xxx and partition_id=yyy; \u53ef\u4ee5\u770b\u5230\u8be5\u5206\u533a\u8be6\u7ec6\u7684\u5f52\u6863\u5404\u4e2a\u73af\u5883\u7684\u72b6\u6001\uff0c\u5176\u4e2d max_archived_checkpoint_ts \u5217\u7b49\u4ef7\u4e8e a \u8868\u4e2d log_archive_cur_ts\u3002<\/p>\n\n\n\n
    d. \u5982\u679c\u5728 c \u8868\u4e2d\u6ca1\u67e5\u5230\u8be5\u5206\u533a\uff0c\u53bb b \u4e2d LEADER \u673a\u5668 grep ARCHIVE observer.log | grep \u8be5\u5206\u533a\uff0c\u770b\u5177\u4f53\u95ee\u9898\uff0c\u5fc5\u8981\u60c5\u51b5\u4e0b\u53ef\u80fd\u9700\u8981\u89e3\u6790\u5f52\u6863\u51fa\u53bb\u7684\u6570\u636e\uff0c\u4f7f\u7528 ob_admin archive_tool \u5de5\u5177\uff0c\u6709\u5177\u4f53\u6307\u5bfc<\/p>\n\n\n\n
    3\u3001\u5982\u679c\u5728 2.d \u4e2d\u6ca1\u6709\u770b\u5230\u8be5\u5206\u533a\uff0c\u53ef\u80fd\u662f\u5907\u4efd dest \u95ee\u9898(\u6bd4\u5982 NFS hang \u7b49)<\/p>\n\n\n\n
    4\u3001\u5176\u4ed6\u9020\u6210\u5f52\u6863\u5361\u5728 BEGINNING \u7684\u60c5\u51b5\u9700\u8981\u5177\u4f53\u95ee\u9898\u5177\u4f53\u5206\u6790<\/p>\n\n\n\n
    <\/a><\/a>RootService \u5361\u5728 stopping \u72b6\u6001<\/h3>\n\n\n\n
    \u6392\u67e5\u601d\u8def<\/strong><\/p>\n\n\n\n
      \n
    1. \u786e\u5b9a\u662f\u5426\u5728\u6301\u7eed\u5927\u91cf\u521b\u5efa\u5206\u533a\uff0c\u5982\u679c\u6709\uff0c\u90a3\u4e48\u901a\u5e38 stop \u9700\u8981\u4e00\u6bb5\u65f6\u95f4<\/li>\n\n\n\n
    2. \u6392\u67e5 __all_virtual_pg_backup_log_archive_status \u8868\uff0c\u786e\u5b9a\u662f\u5426\u6240\u6709 pg \u7684\u72b6\u6001 log_archive_status \u90fd\u662f 1\uff0c\u6267\u884c\u5982\u4e0b SQL \u8bed\u53e5 select svr_ip, log_archive_status, count(*) from __all_virtual_pg_backup_log_archive_status group by svr_ip, log_archive_status;<\/li>\n\n\n\n
    3. \u5982\u679c\u6709 pg \u72b6\u6001 log_archive_status \u4e0d\u662f 1\uff0c\u901a\u8fc7 __all_virtual_partition_info \u8868\u627e\u5230 leader \u6240\u5728 server\uff0c\u6267\u884c grep ARCHIVE observer.log* \uff5c less \u67e5\u770b\u6700\u65b0\u65e5\u5fd7\u662f\u5426\u6709 log archive stopped \u6253\u5370\uff0c\u5982\u679c\u6709\u90a3\u4e48\u7b49\u5f85\u4e00\u6bb5\u65f6\u95f4\uff0c\u5e94\u8be5\u5c31\u8fdb\u5165 stop \u72b6\u6001;<\/li>\n\n\n\n
    4. \u5982\u679c\u7b49\u5f85 30s \u4f9d\u7136\u5361\u5728 stpping\uff0c\u8fdb\u4e00\u6b65\u786e\u5b9a __all_virtual_pg_backup_log_archive_status \u8868\u6240\u6709\u5206\u533a\u72b6\u6001\u90fd\u662f 1(R \u7c7b\u578b\u526f\u672c\u9664\u5916)\uff0c\u5982\u679c\u786e\u5b9a\u4e86\u5206\u533a\u6240\u5728 server \u627e\u4e86 log archive stopped \u65e5\u5fd7\u5e76\u4e14\u8be5 pg \u8fd8\u4e0d\u662f stop\uff0c\u8bf7\u8054\u7cfb\u793e\u533a\u503c\u73ed\u7fa4\u6216\u5230\u793e\u533a\u95ee\u7b54\u533a\u63d0\u95ee;<\/li>\n\n\n\n
    5. \u6392\u9664\u4ee5\u4e0a\u60c5\u51b5\uff0cRS \u8fd8\u4e0d\u662f stop\uff0c\u90a3\u4e48 grep log_archive_scheduler rootservice.log.* | less \u770b RS \u65e5\u5fd7\uff0cOBServer \u6c47\u62a5\u7684\u72b6\u6001\u5e94\u8be5\u662f STOP\uff0c\u5982\u679c\u6709 MIX \u7b49\u72b6\u6001\uff0c\u8bf7\u8054\u7cfb\u793e\u533a\u503c\u73ed\u7fa4\u6216\u5230\u793e\u533a\u95ee\u7b54\u533a\u63d0\u95ee\u3002<\/li>\n<\/ol>\n\n\n\n
      <\/a><\/a>RootService \u5728 doing \u72b6\u6001\uff0c\u4f46\u662f\u51fa\u73b0\u843d\u540e<\/h3>\n\n\n\n
      RS \u5904\u4e8e\u8be5\u9636\u6bb5\uff0c\u8bf4\u660e\u5f00\u542f\u5f52\u6863\u6210\u529f\uff0c\u5f53\u4e0d\u65ad\u51fa\u73b0\u843d\u540e\u65f6\uff0c\u901a\u5e38\u662f\u7531\u4e8e\u67d0\u4e9b\u5206\u533a\u5f02\u5e38\u6216\u8005\u67d0\u4e9b\u673a\u5668\u5f02\u5e38\u3002<\/p>\n\n\n\n
      <\/a><\/a>\u6392\u67e5\u601d\u8def\u4e00<\/h4>\n\n\n\n
        \n
      1. \u9996\u5148\u770b\u5185\u90e8\u8868 __all_virtual_pg_backup_log_archive_status \u8868\uff08log_archive_cur_ts\u8868\u793a\u5f52\u6863\u8fdb\u5ea6\uff09\uff0c\u6267\u884c SQL \u8bed\u53e5 select * from __all_virtual_pg_backup_log_archive_status order by log_archive_cur_ts limit 10\uff1b\u53ef\u4ee5\u627e\u5230\u6700\u843d\u540e\u5206\u533a\u4ee5\u53ca\u5f52\u6863\u8fdb\u5ea6 log_archive_cur_ts\uff1b<\/li>\n\n\n\n
      2. \u5f53\u51fa\u73b0\u67d0\u4e2a\u5206\u533a\u6240\u6709\u526f\u672c\u843d\u540e\u65f6\uff0c\u5728 1 \u4e2d\u8868\u91cc\u53ef\u4ee5\u770b\u5230\u8be5\u5206\u533a\u5168\u90e8\u526f\u672c\u90fd\u662f\u843d\u540e\u7684\uff0c\u5c1d\u8bd5\u770b\u8868 __all_virtual_pg_log_archive_stat\uff08max_archived_checkpoint_ts \u8868\u793a\u5f52\u6863\u8fdb\u5ea6\uff09\uff0c \u6267\u884c SQL \u8bed\u53e5 select * from __all_virtual_pg_log_archive_stat where table_id=xxx and partition_id=yyy\uff1b\u53ef\u4ee5\u770b\u5230\u5b9e\u65f6\u7684\u5f52\u6863\u72b6\u6001\uff1b<\/li>\n\n\n\n
      3. \u5982\u679c\u5728 2 \u4e2d\u8868\u4e2d\u80fd\u627e\u5230\u8be5\u5206\u533a\uff0c\u8bf4\u660e\u5728\u4e3a\u8be5\u5206\u533a\u670d\u52a1\uff0c\u5982\u679c\u6ca1\u6709\u627e\u5230\u8be5\u5206\u533a\uff0c\u7ee7\u7eed\u6392\u67e5\u662f\u5426\u6709 leader\uff0c\u6267\u884c SQL \u8bed\u53e5 select * from __all_virtual_clog_stat where table_id=xxx and partition_idx=yyy; \u901a\u8fc7 role \u5217\u770b\u662f\u5426\u6709 leader<\/li>\n\n\n\n
      4. \u5982\u679c\u6709 leader \u4f46\u662f\u5728 2 \u4e2d\u6ca1\u6709\u8be5\u5206\u533a\uff0c\u5c1d\u8bd5\u4ee5 svr_ip\uff0csvr_port \u770b leader \u6240\u5728\u673a\u5668\u5728 __all_virtual_pg_log_archive_stat \u662f\u5426\u6709\u8bb0\u5f55\uff0c\u6392\u67e5\u662f\u5426\u662f\u673a\u5668\u95ee\u9898\u5bfc\u81f4\u7684\u8be5\u673a\u5668\u5f52\u6863\u51fa\u73b0\u95ee\u9898\uff1b<\/li>\n\n\n\n
      5. \u901a\u8fc7 grep ARCHIVE observer.log* | less \u67e5\u770b\u662f\u5426\u6709\u62a5\u9519\uff0c\u5224\u65ad\u8be5\u673a\u5668\u662f\u5426\u51fa\u73b0\u95ee\u9898\u3002<\/li>\n<\/ol>\n\n\n\n
        \u53e6\u5916\uff0c\u53ef\u80fd\u5206\u533a leader \u72b6\u6001\u662f\u6b63\u5e38\u7684\uff0c\u4f46\u662f follower \u5f52\u6863\u8fdb\u5ea6\u843d\u540e\u3002<\/p>\n\n\n\n
        <\/a><\/a>\u6392\u67e5\u601d\u8def\u4e8c<\/h4>\n\n\n\n
          \n
        1. \u5982\u4e0a\uff0c\u9996\u5148\u770b\u5185\u90e8\u8868 __all_virtual_pg_backup_log_archive_status \u8868\uff0c\u6267\u884c SQL \u8bed\u53e5 select * from __all_virtual_pg_backup_log_archive_status order by log_archive_cur_ts desc limit 10; \u53ef\u4ee5\u627e\u5230\u6700\u843d\u540e\u5206\u533a\u4ee5\u53ca\u5f52\u6863\u8fdb\u5ea6 log_archive_cur_ts\uff1b<\/li>\n\n\n\n
        2. \u770b\u5230\u975e\u67d0\u4e2a\u5206\u533a\u4e0d\u662f\u5168\u90e8\u526f\u672c\u90fd\u662f\u843d\u540e\u5f88\u591a\u7684\uff0c\u4ee5 table_id=xxx and partition_id=yyy \u8fc7\u6ee4 1 \u4e2d\u8868\uff0c\u53ef\u4ee5\u770b\u5230\u81f3\u5c11\u4e00\u4e2a\u526f\u672c\u8fdb\u5ea6\u6bd4\u5176\u4ed6\u526f\u672c\u5feb\u5f88\u591a\uff0c\u5927\u6982\u7387\u662f leader \u5f52\u6863\u8fdb\u5ea6\u5feb\uff1b<\/li>\n\n\n\n
        3. \u67e5\u770b __all_virtual_pg_log_archive_stat \u8868\u786e\u8ba4\u4e00\u4e0b\uff0c\u5982\u679c\u5b58\u5728\u5219\u8868\u793a leader \u5728\u5f52\u6863\uff1b<\/li>\n\n\n\n
        4. \u5927\u6982\u7387\u662f leader \u5411 follower \u540c\u6b65\u5f52\u6863\u8fdb\u5ea6\u51fa\u73b0\u95ee\u9898\uff0c\u770b leader \u548c follower \u65e5\u5fd7\u6253\u5370\uff0c\u662f\u5426\u6709 \u201cObLogArchiveAndRestoreDriver round_cost_time\u201d \u6253\u5370\uff0c\u4ee5\u53ca\u4ee5 CLOG \u548c archive \u5173\u952e\u5b57\u641c\u7d22\u51fa\u73b0\u7684\u5f02\u5e38<\/li>\n\n\n\n
        5. \u53e6\u5916\u5728\u843d\u540e\u5206\u533a leader \u6240\u5728\u673a\u5668\u4e0a\u641c\u7d22 ARCHIVE \u548c\u5206\u533a id \u76f8\u5173\u65e5\u5fd7\uff0c\u5982\u679c\u80fd\u53d1\u73b0\u8bf8\u5982 start_archive_helper \u65e5\u5fd7\u53ef\u80fd\u662f\u65b0 leader \u4e0a\u4efb\u5f00\u542f\u5f52\u6863\u9047\u5230\u95ee\u9898\u3002<\/li>\n<\/ol>\n\n\n\n
          \u6b64\u5916\uff0c\u8fd8\u6709\u53ef\u80fd\u662f\u5206\u533a\u72b6\u6001\u5f02\u5e38\u5bfc\u81f4\u7684\u5f52\u6863\u72b6\u6001\u843d\u540e\uff0c\u8bf7\u54a8\u8be2\u503c\u73ed\u7fa4\u6216\u5230\u793e\u533a\u5b98\u7f51\u63d0\u4ea4\u95ee\u9898\u3002<\/p>\n\n\n\n
          \u53e6\u5916\uff0cNFS \u914d\u7f6e\u7b49\uff0c\u53ef\u80fd\u5bfc\u81f4\u5f52\u6863\u51fa\u95ee\u9898\uff0c\u9700\u8981\u6ce8\u610f\u4ee5\u4e0b\u51e0\u70b9<\/strong>\uff1a<\/p>\n\n\n\n
            \n
          1. \u4e00\u4e2a\u96c6\u7fa4\u5f52\u6863\u5fc5\u987b\u72ec\u5360\u4e00\u5757(\u51e0\u5757)\u76d8\uff0c\u4e0d\u80fd\u6709\u4e00\u540d\u7528\u6237\u591a\u4e2a\u96c6\u7fa4\u6216\u8005\u591a\u540d\u7528\u6237\u5171\u540c\u4f7f\u7528\u4e00\u4e2a\u76d8\u4f5c\u4e3a\u5f52\u6863\u76ee\u7684\u7aef<\/li>\n\n\n\n
          2. \u4f5c\u4e3a NFS \u670d\u52a1\u5668\u7684\u78c1\u76d8\u5982 \/data\/1\/\uff0c\u4e0d\u80fd\u6709\u672c\u5730\u8bfb\u5199\uff0c\u6bd4\u5982\u4e09\u4e2a OBServer\uff0c\u5176\u4e2d\u4e24\u53f0 server mount NFS\u76d8\u5982 \/data\/nfs\/\uff0c\u5199\u5230 NFS \u76d8\uff1b\u53e6\u5916\u4e00\u53f0 server \u7531\u4e8e\u662f NFS \u670d\u52a1\u5668\uff0c\u76f4\u63a5\u5199\u5230\u672c\u5730\u78c1\u76d8 \/data\/1\/ \u3002\u8fd9\u79cd\u60c5\u51b5\u4e5f\u662f\u5fc5\u987b\u907f\u514d\u7684\uff0cNFS \u7684\u63a7\u5236\u7b97\u6cd5\u5e94\u8be5\u5c31\u5931\u6548\u4e86\uff0c\u4f1a\u5bfc\u81f4NFS\u5361\u4f4f\uff1b<\/li>\n\n\n\n
          3. NFS \u914d\u7f6e\u63a8\u8350\u4f7f\u7528\u5982\u4e0b\u914d\u7f6e mount -t nfs4 -o nolock,rw,noatime,nodiratime,sync,lookupcache=positive,timeo=100<\/li>\n\n\n\n
          4. \u9700\u8981\u786e\u4fdd\u4f7f\u7528\u7684\u662f sync\uff0c\u800c\u4e0d\u662f async\uff1btimeo \u8bbe\u7f6e\u4e3a 100<\/li>\n<\/ol>\n\n\n\n
            <\/a><\/a>\u6062\u590d\u95ee\u9898<\/h1>\n\n\n\n
            <\/a><\/a>\u6392\u67e5\u53d1\u8d77\u6062\u590d\u5931\u8d25\u95ee\u9898<\/h2>\n\n\n\n
              \n
            1. \u627e\u5230 RS \u673a\u5668\uff0c\u6267\u884c grep \u201c[RESTORE] physical restore tenant start\u201d rootservice.log* | less<\/li>\n\n\n\n
            2. \u627e\u5230\u9519\u8bef\u7801\uff0c\u6392\u67e5\u53ef\u80fd\u5931\u8d25\u7684\u539f\u56e0\u5982\u4e0b\uff1a<\/li>\n<\/ol>\n\n\n\n
              \u9519\u8bef\u7801<\/th>\u53ef\u80fd\u7684\u539f\u56e0<\/th><\/tr><\/thead>
              -4179<\/td>1. \u5728\u5907\u5e93\u4e0a\u6267\u884c\u6062\u590d\u547d\u4ee4
              2. \u5728\u5347\u7ea7\u8fc7\u7a0b\u4e2d\u6267\u884c\u6062\u590d
              3. \u5728\u4e3b\u5e93\u63a5\u4e86\u5907\u5e93\u65f6\u6267\u884c
              4. \u914d\u7f6e\u9879 restore_concurrency = 0<\/td><\/tr>
              -4023<\/td>restore_timestamp\u8fc7\u5c0f<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              <\/a><\/a>\u6392\u67e5\u6062\u590d\u65f6\u95f4\u957f\u95ee\u9898<\/h2>\n\n\n\n
              <\/a><\/a>\u67e5\u770b\u6062\u590d\u5404\u9636\u6bb5\u5f00\u59cb\u65f6\u95f4<\/h3>\n\n\n\n
              1\u3001\u53ef\u4ee5\u4ece\u5185\u90e8\u8868\u91cc\u67e5\u7269\u7406\u6062\u590d\u5404\u9636\u6bb5\u7684\u5927\u81f4\u8017\u65f6<\/p>\n\n\n\n
              select<\/strong> * from<\/strong> __all_rootservice_event_history where<\/strong> module<\/strong> like<\/strong> \"%physical_restore%\" \nand<\/strong> value1 like<\/strong> \"%job_id%\" order<\/strong> by<\/strong> gmt_create desc<\/strong> limit 10;\n<\/code><\/pre>\n\n\n\n
              2\u3001\u53ef\u4ee5\u8fdb\u4e00\u6b65\u4ece RS \u673a\u5668\u4e0a\u641c rootservice.log \u65e5\u5fd7\u786e\u5b9a\u4ec0\u4e48\u65f6\u5019\u8fdb\u5165\u8be5\u9636\u6bb5<\/p>\n\n\n\n