根据 scn 重置起点¶
场景介绍¶
名词解释:
- scn System change number 数据库严格单调递增的变化序列号,类似于 timestamp。
- savepoint 起点信息,格式为 RAC:<thread#> SEQ:<sequence#> BLK:0 BKO:0 LBK:0 LSC:0
sequence# 和 thread# 从数据库查询得到 scn 所属日志的 thread# 和 sequence#
在监听程序停止时更新 savepoint。下次启动时,则以该 savepoint 为起点启动。
常用命令¶
# 获取当前 scn
$ curl localhost:8303/tools/scn
1156657092
# 根据时间得到 scn
$ curl localhost:8303/tools/scn?time=2022-10-21T16:18:20
1191761688
执行步骤¶
- 获取起点
# 获取 `scn` 对应日志文件,即 savepoint $ curl localhost:8303/tools/logs?startScn=1153604547 [{"thr":1,"seq":9329,"name":"2_/u01/app/oracle/product/12.2.0/db_1/dbs/arch1_9329_1023213783.dbf"}] - 停止实例
# 执行停止实例命令 $ curl -XPOST localhost:8303/export/stop Undeploy c4a973e1-8bdd-4da6-9a87-931b62fbc550 # 确认停止后状态为 DOWN $ curl localhost:8303/export/health {"status":"DOWN","checks":[{"id":null,"status":null,"data":null}]} - 更新起点
# 确认 Step.1 的日志文件无误后,使用 Step.1 的返回内容更新 savepoint $ curl -XPOST localhost:8303/export/savepoint -d'[{"thr":1,"seq":9329,"name":"2_/u01/app/oracle/product/12.2.0/db_1/dbs/arch1_9329_1023213783.dbf"}]' savepoint updated - 确认起点
$ curl localhost:8303/export/savepoint RAC:1 SEQ:9329 BLK:0 BKO:0 LBK:0 LSC:0 - 启动实例
# 启动实例 $ curl -XPOST localhost:8303/export/start Deploy Oragent instance. # 查看健康状态 $ curl localhost:8303/export/health {"status":"UP","checks":[{"id":"1","status":null,"data":{"id":"1","deployment-id":"bf6fdf37-bbcb-421f-97b4-ef75fb1c5761","delay-sec":"2463","system":"cpu=25","err":null}}]}