跳转至

根据 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

执行步骤

  1. 获取起点
    # 获取 `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"}]
    
  2. 停止实例
    # 执行停止实例命令
    $ 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}]}  
    
  3. 更新起点
    # 确认 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
    
  4. 确认起点
    $ curl localhost:8303/export/savepoint
    RAC:1 SEQ:9329 BLK:0 BKO:0 LBK:0 LSC:0 
    
  5. 启动实例
    # 启动实例
    $ 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}}]}