联机备份时删除已归档日志是否会导致db挂起,收集latches如下:
Latches:Address Holder Waiter Filename LOC LatchType HoldCount 0x00002B1864000A20 22 0 Unknown 2042 SQLO_LT_sqlofmga_C__SQLO_TLFL_m_fileLatch 4 0x00002B188E3B88A8 27 0 Unknown 13692 SQLO_LT_SQLB_CLNR_PAUSE_CB__preventSuspendLatch 1 0x00002B2278000AC0 27 0 Unknown 2042 SQLO_LT_sqlofmga_C__SQLO_TLFL_m_fileLatch 2 0x00002B2294000A80 33 0 Unknown 2042 SQLO_LT_sqlofmga_C__SQLO_TLFL_m_fileLatch 2 0x00002B22980009C0 34 0 Unknown 2042 SQLO_LT_sqlofmga_C__SQLO_TLFL_m_fileLatch 2 0x0000000200480FE0 112 27 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 28 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 39 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 40 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 42 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 84 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 110 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 111 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 114 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 115 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 120 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 125 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 130 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 133 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 0x0000000200480FE0 112 207 Unknown 59 SQLO_LT_SQLE_KRCB__sqleDirCacheLatch 1 Latch Waiters With No Holders:Address Holder Waiter Filename LOC LatchType 0x00002B2278000A60 0 112 Unknown 2042 SQLO_LT_sqlofmga_C__SQLO_TLFL_m_fileLatch
联机备份的同时不要清理日志。干吗不多等一会呢? 呵呵
关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们 © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30