Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

1

主题
1#
发表于 2014-11-4 10:00:47 | 查看: 4293| 回复: 4
请问
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.
5#
发表于 2014-11-4 11:22:11
Maclean Liu(刘相兵 发表于 2014-11-4 10:46
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的信息 就会从内存中删除 不再占用内存了吗

回复 只看该作者 道具 举报

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

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

    。。  

回复 只看该作者 道具 举报

3#
发表于 2014-11-4 10:46:20
extract进程running  无任何异常,每隔4个小时出现这样的信息,这个信息具体表示什么意思,进程在做什么操作

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

回复 只看该作者 道具 举报

2#
发表于 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



回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-18 20:40 , Processed in 0.051765 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569