Home » Server Options » Data Guard » Archive log shipping (Oracle 11g,Linux 6)
Archive log shipping [message #681386] Wed, 15 July 2020 00:07 Go to next message
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 #681389 is a reply to message #681386] Wed, 15 July 2020 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It's in the documentation.
(Happy I answer to your post?)

Re: Archive log shipping [message #681428 is a reply to message #681389] Thu, 16 July 2020 08:50 Go to previous messageGo to next message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Michel,

Quote:
It's in the documentation.
Is this the documentation you are talking about?
You have not changed yet.

Can someone answer to my question other than Michel.

Regards,
Balaji
Re: Archive log shipping [message #681429 is a reply to message #681428] Thu, 16 July 2020 09:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
unwilling or incapable to use GOOGLE yourself?
Re: Archive log shipping [message #681430 is a reply to message #681386] Thu, 16 July 2020 10:28 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
BalajiDBA wrote on Wed, 15 July 2020 06:07
Hi,

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.
Re: Archive log shipping [message #681432 is a reply to message #681430] Thu, 16 July 2020 12:12 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
you should be able to work it out.
Laughing I see you don't know him...
He is here since about 15 years through a dozen of accounts (and DBA since more).

Previous Topic: ORA-01103 create physical standby database
Next Topic: Recover Physical Standby Database Error
Goto Forum:
  


Current Time: Thu Mar 28 17:33:51 CDT 2024