Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Save the backup history log #896

Open
BraveLz opened this issue May 6, 2022 · 3 comments
Open

Save the backup history log #896

BraveLz opened this issue May 6, 2022 · 3 comments

Comments

@BraveLz
Copy link
Contributor

BraveLz commented May 6, 2022

Is your feature request related to a problem? Please describe.
在查看日志备份状态时,有时会发现日志备份max_next_time延后时间大于log_archive_checkpoint_interval参数配置值, 想排查下原因,但现在oceanbase 版本只能查看当前日志备份状态,即查CDB_OB_BACKUP_ARCHIVELOG_SUMMARY这个表,这个表里只有min_first_time和max_next_time,没有每个租户每次日志备份的耗时或者每次备份到达的时间戳的历史记录。

Describe the solution you'd like
能否在之后版本将各租户历史日志备份记录保存到表(由于日志备份频率高,可以只保留一段时间的),并提供视图可查询

@JLY2015
Copy link
Contributor

JLY2015 commented May 7, 2022

你好,我先理解一下你的诉求:
1)日志备份滞后的排查手段 ;
2)日志备份的每次备份的起始时间以及状态
是这样吗?

@longdafeng longdafeng changed the title 日志备份历史记录保存 Save the backup history log Jul 27, 2022
@longdafeng longdafeng added this to the 3.1.5 milestone Jul 27, 2022
@longdafeng
Copy link
Member

We are going to support this feature in the next version 3.1.5.

@JLY2015
Copy link
Contributor

JLY2015 commented Aug 1, 2022

你好,OB的归档不是个周期性任务,而是流式的在后台持续进行的事情。但是为了 一些优化比如对存储介质更友好,会聚合起来尽量大的IO,这个checkpoint_interval就是聚合的时间。我理解你的诉求是想要oracle那种周期性的归档,并且可以感知每次归档的时间开销?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants