oracle日志应用慢,recover standby database 应用日志很慢

1.recover managed standby database disconnect from session;

2.查看alert文件，发现一个300m日志需要应用20分钟

3.查看metalink MAA - Data Guard Redo Apply and Media Recovery Best Practices 10gR1

也按照文档修改参数了，发现还是不行

3.查看v$managed_standby

发现最后一个block等了差不多8分钟，才结束

-------- ---------- ---------- ---------- ---------- -----------------------

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:49:09

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:56

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:57

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:57

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:58

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:58

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:58

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:59

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:59

SQL>

SQL> //

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:51:59

SQL> //

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:52:00

SQL> //

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:52:00

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:52:00

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:52:00

SQL> //

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:52:01

SQL> /

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:52:01

SQL> //

PROCESS    SEQUENCE#    THREAD#     BLOCK#     BLOCKS TIME

--------- ---------- ---------- ---------- ---------- -----------------------

MRP0          133538          1     581533     581534 15-APR-2011 10:52:01

4. dump mrp

查看trace文件

----------------------------------------

SO: 0xc103c9b58, type: 4, owner: 0xc172b7820, flag: INIT/-/-/0x00

(session) sid: 1087 trans: (nil), creator: 0xc172b7820, flag: (51) USR/- BSY/-/-/-/-/-

DID: 0001-0013-00000002, short-term DID: 0000-0000-00000000

txn branch: (nil)

oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS

service name: SYS$BACKGROUND

waiting for 'PX Deq: Par Recov Reply' blocking sess=0x(nil) seq=6397 wait_time=0 seconds since wait started=3

sleeptime/senderid=10010000, passes=19f, =0

Dumping Session Wait History

for 'PX Deq: Par Recov Reply' count=1 wait_time=1953964

sleeptime/senderid=10010000, passes=19e, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954140

sleeptime/senderid=10010000, passes=19d, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954066

sleeptime/senderid=10010000, passes=19c, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954065

sleeptime/senderid=10010000, passes=19b, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954129

sleeptime/senderid=10010000, passes=19a, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954061

sleeptime/senderid=10010000, passes=199, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1953991

sleeptime/senderid=10010000, passes=198, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954123

sleeptime/senderid=10010000, passes=197, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954120

sleeptime/senderid=10010000, passes=196, =0

for 'PX Deq: Par Recov Reply' count=1 wait_time=1954073

sleeptime/senderid=10010000, passes=195, =0

5.请问如何阅读trace文件

[本帖最后由 joe_mii 于 2011-4-17 21:43 编辑]

2011-4-16 16:59 上传

点击文件名下载附件

8.31 KB, 下载次数: 4

dump mrp process