OraFAQ Forum: Data Guard » Truncate table effect on physical standby

Home » Server Options » Data Guard » Truncate table effect on physical standby (Oracle 10gR2, Win 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Truncate table effect on physical standby [message #432053]

Fri, 20 November 2009 13:12

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

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

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