Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is the role of Lns process in oracle 10g data guard

972755Nov 8 2012 — edited Nov 8 2012
Hi ,
plz help me out to find out the actual working of lns process in oracle 10g data guard

when i use SYNC redo transport

the output of v$managed_stanbdy is like that ..

PROCESS PID STATUS CLIENT_PROCESS GR# SEQ#
--------- ---------- ------------ -------- ---------------------------------------- ----------
ARCH 9258 CLOSING ARCH 2 498
ARCH 9260 CLOSING ARCH 1 499
ARCH 9262 CLOSING ARCH 2 496
ARCH 9264 CLOSING ARCH 1 497
LGWR 9206 CLOSING LGWR 2 482

its not display any info about lns,thats means lns is not working in SYNC redo transport mode ?

but if i changed it to ASYNC then the out put of v$managed_stanbdy is like this ..


PS PID STS CPS GR# SEQ#
--------- ---------- ------------ -------- ---------------------------------------- ----------
ARCH 9258 CLOSING ARCH 1 509
ARCH 9260 CLOSING ARCH 2 510
ARCH 9262 CLOSING ARCH 1 505
ARCH 9264 CLOSING ARCH 2 508
LGWR 9206 CLOSING LGWR 1 503
LNS 10528 CLOSING LNS 2 510

Now it display all the info about lns process...

i read in oracle documentation that lns process send redo data from primary,( through network service ) to RFS on standby side.

but first output means that lns is not working,if not then which process send redo from primary to RFS on standby ?

i also read in some blog that lgwr use some extra buffer size from primary db SGA ,to write redo in that buffer ,ans lns read redo from that buffer and send it to RFS on stanby side,

i m totally confused ..can u plz help me with correct logic behind this .

thanx in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2012
Added on Nov 8 2012
7 comments
6,465 views