Home » Server Options » Data Guard » Truncate table effect on physical standby (Oracle 10gR2, Win 2003)
Truncate table effect on physical standby [message #432053] Fri, 20 November 2009 13:12 Go to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member

Hi,

Are there redo generate during truncate operation even my primary database is in FORCE LOGGGING mode? How this will effect on physical standby database.


Regards,
Vish

Report message to a moderator

Re: Truncate table effect on physical standby [message #432055 is a reply to message #432053] Fri, 20 November 2009 13:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Are there redo generate during truncate operation even my primary database is in FORCE LOGGGING mode?
NO!

Report message to a moderator

Re: Truncate table effect on physical standby [message #432058 is a reply to message #432055] Fri, 20 November 2009 13:29 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hello BlackSwan,

Thanks for reply.

If redo will not be generated for truncate operation in FORCE LOGGING mode on primary db then how it will sync with physical standby db?


Regards,
Vish

Report message to a moderator

Re: Truncate table effect on physical standby [message #432059 is a reply to message #432058] Fri, 20 November 2009 13:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The command will still propagate to the standby.

Report message to a moderator

Re: Truncate table effect on physical standby [message #432060 is a reply to message #432059] Fri, 20 November 2009 14:01 Go to previous messageGo to next message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
Hi ebrian,

I am sorry. i didn't get understand anything. Can you please explain more on this.

Regards,
Vish

Report message to a moderator

Re: Truncate table effect on physical standby [message #448375 is a reply to message #432053] Tue, 23 March 2010 01:24 Go to previous messageGo to next message
goldenshot2727
Messages: 6
Registered: March 2010
Location: delhi
Junior Member

i think as force logging is enabled , so redo will be generated for the same.

Report message to a moderator

Re: Truncate table effect on physical standby [message #448563 is a reply to message #432053] Wed, 24 March 2010 01:46 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Redo is always generated .It is actually the undo that is not generated with truncate.

So the effect would still propagate to the standby.

Report message to a moderator

Previous Topic: Unable to start ACTIVE DATAGUARD
Next Topic: Flexcube
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 29 10:48:08 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.