librarian 发表于 2014-11-4 10:00:47

急求解答Bounded Recovery问题

请问
1、extract进程running  无任何异常，每隔4个小时出现这样的信息，这个信息具体表示什么意思，进程在做什么操作
2、BR checkpoint 在interval时间到时  具体有什么操作

2014-10-31 18:00:21  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p33226794_extr: start=SeqNo: 42712, RBA: 290345488, SCN: 0.575338729 (57533872
9), Timestamp: 2014-10-31 18:00:18.000000, Thread: 1, end=SeqNo: 42712, RBA: 290348544, SCN: 0.575338729 (575338729), Timestamp: 2014-10-31 18:00:18.000000, Thread: 1.

2014-10-31 22:00:28  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p33226794_extr: start=SeqNo: 42714, RBA: 58393104, SCN: 0.575550114 (575550114
), Timestamp: 2014-10-31 22:00:08.000000, end=SeqNo: 42714, RBA: 63321600, SCN: 0.575555244 (575555244), Timestamp: 2014-10-31 22:00:26.000000, Thread: 1.

2014-11-01 02:00:35  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p33226794_extr: start=SeqNo: 42715, RBA: 383990288, SCN: 0.575738455 (57573845
5), Timestamp: 2014-11-01 02:00:28.000000, Thread: 1, end=SeqNo: 42715, RBA: 384000512, SCN: 0.575738455 (575738455), Timestamp: 2014-11-01 02:00:28.000000, Thread: 1.

2014-11-01 06:00:43  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p33226794_extr: start=SeqNo: 42717, RBA: 62517264, SCN: 0.575921453 (575921453
), Timestamp: 2014-11-01 06:00:05.000000, end=SeqNo: 42717, RBA: 67239936, SCN: 0.575923891 (575923891), Timestamp: 2014-11-01 06:00:36.000000, Thread: 1.

2014-11-01 10:00:46  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p33226794_extr: start=SeqNo: 42718, RBA: 240096784, SCN: 0.576102846 (57610284
6), Timestamp: 2014-11-01 10:00:42.000000, Thread: 1, end=SeqNo: 42718, RBA: 240099328, SCN: 0.576102846 (576102846), Timestamp: 2014-11-01 10:00:42.000000, Thread: 1.

2014-11-01 14:00:56  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p33226794_extr: start=SeqNo: 42719, RBA: 367037968, SCN: 0.576234245 (57623424
5), Timestamp: 2014-11-01 14:00:49.000000, Thread: 1, end=SeqNo: 42719, RBA: 367038464, SCN: 0.576234245 (576234245), Timestamp: 2014-11-01 14:00:49.000000, Thread: 1.

2014-11-01 18:01:01  INFO    OGG-01738  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p33226794_extr: start=SeqNo: 42721, RBA: 45694480, SCN: 0.576388632 (576388632
), Timestamp: 2014-11-01 18:00:54.000000, Thread: 1, end=SeqNo: 42721, RBA: 45694976, SCN: 0.576388632 (576388632), Timestamp: 2014-11-01 18:00:54.000000, Thread: 1.

Maclean Liu(刘相兵 发表于 2014-11-4 10:45:24

Capture Checkpointing: Bounded Recovery

Write out old uncommitted data to disk
Any data older than 4 hours (user controlled) written out to disk
Faster recovery
No need to read archived logs older than 8 hours
Reduces disk space need to stage archived logs
No need for archived logs older than 8 hours



Maclean Liu(刘相兵 发表于 2014-11-4 10:46:20

extract进程running  无任何异常，每隔4个小时出现这样的信息，这个信息具体表示什么意思，进程在做什么操作

==》在把最近4小时 还没有 commit的数据写入到磁盘上

librarian 发表于 2014-11-4 11:21:46

》

本帖最后由 librarian 于 2014-11-4 11:23 编辑

    。。  

librarian 发表于 2014-11-4 11:22:11

Maclean Liu(刘相兵 发表于 2014-11-4 10:46 static/image/common/back.gif
extract进程running  无任何异常，每隔4个小时出现这样的信息，这个信息具体表示什么意思，进程在做什么操 ...

首先非常感谢您详细的回答，我还有个疑问
1、如果在BR checkpoint N处，将所有long running transaction 写入到disk，并且BR checkpoint N与BR checkpoint N+1 之间没有任何其他transaction发生，且已写入disk的long running transaction 没有commit也没有任何修改，那么BR checkpoint N+1 会发生什么操作
2、已写入disk的信息 就会从内存中删除 不再占用内存了吗
页: [1]
查看完整版本: 急求解答Bounded Recovery问题