Dataguard issue

April 10th, 2009 | Categories: Boring | Tags:
Leave a comment | Trackback

1)当设置好log_archive_dest_2后,Primary第一次switch logfile的时候，由于LGWR要做额外的工作(联系LNSn),会由一段时间不写redo log(猜测)。如果primary数据库DML特别繁忙的话，可以明显的看到一阵high active session，这些active session大部分等待log file sync或者undo enqueue.

可以truss LGWR,看到一些内部信息。

SQL> alter system set log_archive_dest_2=’service=joestby reopen=5 lgwr async’;
System altered.

SQL> !ps -ef | grep JOE | grep -i lns
oracle 11901 11872   0 00:35:25 pts/5       0:00 /bin/csh -c ps -ef | grep JOE | grep -i lns

SQL> alter system switch logfile;
System altered.

SQL> !ps -ef | grep JOE | grep -i lns
oracle 11909 11872   0 00:35:57 pts/5       0:00 /bin/csh -c ps -ef | grep JOE | grep -i lns

switch log的时候,truss的输出

/1: semtimedop(50331652, 0xFFFFFFFF7FFFDBF4, 1, 0xFFFFFFFF7FFFDBE0) (sleeping…)
/1: semtimedop(50331652, 0xFFFFFFFF7FFFDBF4, 1, 0xFFFFFFFF7FFFDBE0) = 0
/1: pread(256, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/1: pread(257, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/1: pread(256, “15C2\0\0\0\0\0\b\0\0 JAF”.., 16384, 131072) = 16384
/1: pread(256, “15C2\0\0\0\0\0\n\0\0 JAF”.., 16384, 163840) = 16384
/1: pread(256, “15C2\0\0\0\0\0\f\0\0 JAB”.., 16384, 196608) = 16384
/1: pread(256, “15C2\0\0\0\0\00E\0\0 JAC”.., 16384, 229376) = 16384
/1: semctl(50331652, 10, SETVAL, 1) = 0
/1: lwp_unpark(5) = 0
/5: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(7) = 0
/7: lwp_park(0×00000000, 0) = 0
/5: pwrite(256, “15C2\0\0\0\0\0\r\0\0 JB0″.., 16384, 212992) = 16384
/5: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCE70) = 1
/7: pwrite(257, “15C2\0\0\0\0\0\r\0\0 JB0″.., 16384, 212992) = 16384
/7: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCE70) = 1
/1: lwp_unpark(9) = 0
/9: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(11) = 0
/11: lwp_park(0×00000000, 0) = 0
/9: pwrite(256, “15C2\0\0\0\0\0\t\0\0 JB0″.., 16384, 147456) = 16384
/11: pwrite(257, “15C2\0\0\0\0\0\t\0\0 JB0″.., 16384, 147456) = 16384
/9: kaio(AIONOTIFY, 0) = 0
/11: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCF20) = 1
/1: lwp_unpark(12) = 0
/12: lwp_park(0×00000000, 0) = 0
/5: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(5) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCF20) = 1
/5: pwrite(257, “15C2\0\0\0\0\007\0\0 JB0″.., 16384, 114688) = 16384
/12: pwrite(256, “15C2\0\0\0\0\007\0\0 JB0″.., 16384, 114688) = 16384
/5: kaio(AIONOTIFY, 0) = 0
/12: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCF20) = 1
/1: lwp_unpark(7) = 0
/7: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(9) = 0
/9: lwp_park(0×00000000, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCFF0) = 1
/7: pwrite(256, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/9: pwrite(257, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/7: kaio(AIONOTIFY, 0) = 0
/9: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCFF0) = 1
/1: pread(256, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/1: semctl(50331652, 38, SETVAL, 1) = 0
/1: pread(259, “01 “\0\0\0\0\001\0\0\0F5″.., 512, 512) = 512
/1: pread(256, “15C2\0\0\0\0\0 `\0\0 JAD”.., 16384, 1572864) = 16384
/1: pwrite(260, “01 “\0\0\0\0\001\0\0\0F6″.., 512, 512) = 512
/1: write(2, ” * * * 2 0 0 9 - 0 4 -”.., 27) = 27
/1: write(2, “\n”, 1) = 1
/1: write(2, ” * * * 2 0 0 9 - 0 4 -”.., 40) = 40
/1: write(2, “\n”, 1) = 1
/1: write(2, ” I n i t i a l i z i n g”.., 56) = 56
/1: write(2, “\n”, 1) = 1
/1: write(2, ” I n i t i a l i z i n g”.., 52) = 52
/1: write(2, “\n”, 1) = 1
/1: write(2, ” L N S b i s n o t “.., 29) = 29
/1: write(2, “\n”, 1) = 1
/1: write(2, ” C h e c k i f n e w”.., 45) = 45
/1: write(2, “\n”, 1) = 1
/1: write(2, ” . . y e s i t n”.., 30) = 30
/1: write(2, “\n”, 1) = 1
/1: write(2, ” S t a r t i n g L N S”.., 17) = 17
/1: write(2, “\n”, 1) = 1
/1: semctl(50331652, 7, SETVAL, 1) = 0
/1: semtimedop(50331652, 0xFFFFFFFF7FFFB3D4, 1, 0xFFFFFFFF7FFFB3C0) = 0
/1: write(2, ” S u b s c r i b i n g “.., 33) = 33
/1: write(2, “\n”, 1) = 1
/1: write(2, ” s u”.., 18) = 18
/1: write(2, “\n”, 1) = 1
/1: write(2, ” I n d i c a t i n g r”.., 45) = 45
/1: write(2, “\n”, 1) = 1
/1: write(2, ” s u c c e s s”, 9) = 9
/1: write(2, “\n”, 1) = 1
/1: write(2, ” W a i t i n g f o r “.., 37) = 37
/1: write(2, “\n”, 1) = 1
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/5: lwp_park(0×00000000, 0) (sleeping…)
/7: lwp_park(0×00000000, 0) (sleeping…)
/9: lwp_park(0×00000000, 0) (sleeping…)
/11: lwp_park(0×00000000, 0) (sleeping…)
/12: lwp_park(0×00000000, 0) (sleeping…)
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: semtimedop(50331652, 0xFFFFFFFF7FFFBAB4, 1, 0xFFFFFFFF7FFFBAA0) Err#11 EAGAIN
/1: write(2, ” * * * 2 0 0 9 - 0 4 -”.., 40) = 40
/1: write(2, “\n”, 1) = 1
/1: write(2, ” N e t s e r v e r L N”.., 62) = 62
/1: write(2, “\n”, 1) = 1
/1: write(2, ” P e r f o r m i n g a”.., 55) = 55
/1: write(2, “\n”, 1) = 1
/1: write(2, ” C o n n e c t i n g a”.., 45) = 45
/1: write(2, “\n”, 1) = 1
/1: write(2, ” S u c c e s s f u l l y”.., 89) = 89
/1: write(2, “\n”, 1) = 1
/1: write(2, ” * * * 2 0 0 9 - 0 4 -”.., 40) = 40
/1: write(2, “\n”, 1) = 1
/1: write(2, ” M a k i n g u p i a h”.., 107) = 107
/1: write(2, “\n”, 1) = 1
/1: semctl(50331652, 31, SETVAL, 1) = 0
/1: semctl(50331652, 31, SETVAL, 1) = 0
/1: pread(259, “01 “\0\0\0\0\001\0\0\0F5″.., 512, 512) = 512
/1: pwrite(259, “01 “\0\0\0\0\001\0\0\0F5″.., 512, 512) = 512
/1: lwp_unpark(11) = 0
/11: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(12) = 0
/12: lwp_park(0×00000000, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFC410) = 1
/11: pwrite(256, “15C2\0\0\0\0\00E\0\0 JB1″.., 16384, 229376) = 16384
/12: pwrite(257, “15C2\0\0\0\0\00E\0\0 JB1″.., 16384, 229376) = 16384
/11: kaio(AIONOTIFY, 0) = 0
/12: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFC410) = 1
/1: pread(256, “15C2\0\0\0\003 ,\0\0 J N”.., 16384, 13303808) = 16384
/1: pread(256, “15C2\0\0\0\001C9\0\0 JAA”.., 16384, 7487488) = 16384
/1: pread(256, “15C2\0\0\0\0\00E\0\0 JB1″.., 16384, 229376) = 16384
/1: lwp_unpark(5) = 0
/5: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(7) = 0
/7: lwp_park(0×00000000, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCC40) = 1
/5: pwrite(256, “15C2\0\0\0\001CA\0\0 JB1″.., 16384, 7503872) = 16384
/5: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCC40) = 1
/7: pwrite(257, “15C2\0\0\0\001CA\0\0 JB1″.., 16384, 7503872) = 16384
/7: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCC40) = 1
/1: pread(256, “15C2\0\0\0\0\0\f\0\0 JAB”.., 16384, 196608) = 16384
/1: lwp_unpark(9) = 0
/9: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(11) = 0
/11: lwp_park(0×00000000, 0) = 0
/9: pwrite(256, “15C2\0\0\0\0\0\v\0\0 JB1″.., 16384, 180224) = 16384
/11: pwrite(257, “15C2\0\0\0\0\0\v\0\0 JB1″.., 16384, 180224) = 16384
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFCFD0) = 1
/11: kaio(AIONOTIFY, 0) = 0
/9: kaio(AIONOTIFY, 0) = 0
/1: lwp_unpark(12) = 0
/12: lwp_park(0×00000000, 0) = 0
/5: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(5) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD080) = 1
/12: pwrite(256, “15C2\0\0\0\0\0\n\0\0 JB1″.., 16384, 163840) = 16384
/5: pwrite(257, “15C2\0\0\0\0\0\n\0\0 JB1″.., 16384, 163840) = 16384
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD080) = 1
/5: kaio(AIONOTIFY, 0) = 0
/12: kaio(AIONOTIFY, 0) = 0
/7: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(7) = 0
/1: lwp_unpark(9) = 0
/9: lwp_park(0×00000000, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD080) = 1
/7: pwrite(256, “15C2\0\0\0\0\0\b\0\0 JB1″.., 16384, 131072) = 16384
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD080) = 1
/7: kaio(AIONOTIFY, 0) = 0
/9: pwrite(257, “15C2\0\0\0\0\0\b\0\0 JB1″.., 16384, 131072) = 16384
/9: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD080) = 1
/11: lwp_park(0×00000000, 0) = 0
/1: lwp_unpark(11) = 0
/1: lwp_unpark(12) = 0
/12: lwp_park(0×00000000, 0) = 0
/11: pwrite(256, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/11: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD150) = 1
/12: pwrite(257, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/12: kaio(AIONOTIFY, 0) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD150) = 1
/1: pread(256, “15C2\0\0\0\0\001\0\0\0\0″.., 16384, 16384) = 16384
/1: semctl(50331652, 38, SETVAL, 1) = 0
/1: pread(256, “15C2\0\0\0\0\0 `\0\0 JAD”.., 16384, 1572864) = 16384
/1: semctl(50331652, 31, SETVAL, 1) = 0
/1: close(9) = 0
/1: open(”/oracle/TENG/data01/JOE/admin/bdump/alert_JOE.log”, O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 9
/1: time() = 1239348949
/1: writev(9, 0xFFFFFFFF7FFFC7D0, 3) = 96
/1: semctl(50331652, 10, SETVAL, 1) = 0
/1: semctl(50331652, 9, SETVAL, 1) = 0
/1: semctl(50331652, 12, SETVAL, 1) = 0
/1: semctl(50331652, 11, SETVAL, 1) = 0
/1: open(”/proc/11811/psinfo”, O_RDONLY) = 17
/1: read(17, “02\0\0\0\0\0\001\0\0 . #”.., 416) = 416
/1: close(17) = 0
/1: semctl(50331652, 23, SETVAL, 1) = 0
/1: close(9) = 0
/1: open(”/oracle/TENG/data01/JOE/admin/bdump/alert_JOE.log”, O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 9
/1: time() = 1239348949
/1: writev(9, 0xFFFFFFFF7FFFC7D0, 3) = 77
/1: close(9) = 0
/1: open(”/oracle/TENG/data01/JOE/admin/bdump/alert_JOE.log”, O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 9
/1: writev(9, 0xFFFFFFFF7FFFC500, 2) = 67
/1: semtimedop(50331652, 0xFFFFFFFF7FFFDBF4, 1, 0xFFFFFFFF7FFFDBE0) = 0
/1: kaio(AIOWRITE, 260, 0×3C0000000, 512, 0×000004007AE25140) = 0
/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD740) = -2233315008

虽然LGWR是多线程的,在处理LNS的时候，仍然需要一些同步的等待。上面输出中，线程/1做的事情最多。

可惜测试机器上没有dtrace权限,找不到谁fork的LNS.

2) Standby上的RFS进程竟然不是后台进程。全名叫做remote file server (RFS) process,而且根据日志传输情况可能会有多个RFS进程。

Del.icio.us Google书签 Digg Live Bookmark Technorati Furl Yahoo书签 Facebook 百度搜藏 新浪 ViVi 365Key 网摘 天极网摘 和讯网摘 博拉网 POCO 网摘 饭否 QQ 书签 Digbuzz 我挖网 Mister Wong
No comments yet.