| Archive log shipping [message #681386] |
Wed, 15 July 2020 00:07  |
 |
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
|
Senior Member |
|
|
Hi,
Can you please tell me which process is responsible for shipping archive logs from primary to standby in oracle.
Regards,
Balaji
|
|
|
|
|
|
|
|
|
|
| Re: Archive log shipping [message #681430 is a reply to message #681386] |
Thu, 16 July 2020 10:28  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
BalajiDBA wrote on Wed, 15 July 2020 06:07Hi,
Can you please tell me which process is responsible for shipping archive logs from primary to standby in oracle.
Regards,
Balaji
I'm sure it is in the doc's. However, it is perhaps a bit more complicated than one might think. Your exact question ("shipping archive logs") is a bit twentieth century: archive logs were shipped by the ARCn processes, back in release 8i. From release 9, it is either LGWR or LNSn, depending on your protection mode. In later releases, LNSn seems to have been replaced by TTnn NSSn processes. There are also, IIRC, FALn processes that handle gaps.
If you query v$managed_standby in both primary and standby, you should be able to work it out.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
I see you don't know him...