OraFAQ Forum: Server Administration » NOLOGGING TABLES in DATAGUARD

Home » RDBMS Server » Server Administration » NOLOGGING TABLES in DATAGUARD (12c)

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

NOLOGGING TABLES in DATAGUARD [message #639464]

Wed, 08 July 2015 04:25

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

I have a recommendation from Application team to set NOLOGGING option for few tables.

But currently my DBA says the NOLOGGING option will over-seeded by DATAGUARD which will do FORCE LOGGING.

Please let me know whether we can set NOLOGGING option for few tables while using DATAGUARD? If so let me know the steps.

Thanks in advance.

Report message to a moderator

Re: NOLOGGING TABLES in DATAGUARD [message #639465 is a reply to message #639464]

Wed, 08 July 2015 04:29

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Why don't you trust the DBA?

S/He is correct.

Besides which, it's actually quite a few hoops you must jump through to ACTUALLY get logging off, just setting nologging won't do anything.

Report message to a moderator

Re: NOLOGGING TABLES in DATAGUARD [message #639466 is a reply to message #639464]

Wed, 08 July 2015 04:36

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Tell them to revisit their code Wink

Report message to a moderator

Re: NOLOGGING TABLES in DATAGUARD [message #639499 is a reply to message #639464]

Wed, 08 July 2015 12:52

bpeasland
Messages: 51
Registered: February 2015
Location: United States

Member

To be accurate, the FORCE LOGGING setting will override any NOLOGGING in use. You can have Data Guard set up that does not have FORCE LOGGING. In this situation, the redo will not be transported to the standby database. This means that your data won't be there when you perform a switchover/failover operation. It is a best practice to use FORCE LOGGING, which is why your DBA has configured it that way.

How much redo generation are you talking about? Which version of Oracle are you using?

Cheers,
Brian

Report message to a moderator

Previous Topic:	SQL Advisor Job failed
Next Topic:	ORA-12514 log_archive_dest changed and now db instance won't start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 03:40:49 CDT 2025