Home » RDBMS Server » Server Administration » NOLOGGING TABLES in DATAGUARD (12c)
NOLOGGING TABLES in DATAGUARD [message #639464] Wed, 08 July 2015 04:25 Go to next message
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.
Re: NOLOGGING TABLES in DATAGUARD [message #639465 is a reply to message #639464] Wed, 08 July 2015 04:29 Go to previous messageGo to next message
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.
Re: NOLOGGING TABLES in DATAGUARD [message #639466 is a reply to message #639464] Wed, 08 July 2015 04:36 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Tell them to revisit their code Wink
Re: NOLOGGING TABLES in DATAGUARD [message #639499 is a reply to message #639464] Wed, 08 July 2015 12:52 Go to previous message
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
Previous Topic: SQL Advisor Job failed
Next Topic: ORA-12514 log_archive_dest changed and now db instance won't start
Goto Forum:
  


Current Time: Thu Mar 28 08:07:17 CDT 2024