AnsweredAssumed Answered

Oracle Enterprise GeoDatabase force logging vs nologging

Question asked by siluvairajansj on May 22, 2019
Latest reply on May 23, 2019 by lmontero-esristaff

Our Enterprise GeoDatabase running on Oracle has been configured at the database level to force logging. ArcSDE DBTUNE defines many tables and indexes by default to be NOLOGGING for performance reasons. Is force logging not a good approach for geodatabases?

 

Some context : Our production database runs in archivelog mode. When we do a DB restore of our non-production database from RMAN backups of our production databases, these tables/indexes defined as NOLOGGING in DBTUNE run into block level corruption while the logs are applied after restore. The DBA recommends having force logging turned ON so we don't run into issues while applying the archive logs. Ref : https://chenguangblog.wordpress.com/tag/nologging/

 

Ref:

https://resources.arcgis.com/en/help/main/10.1/index.html#/What_is_the_DBTUNE_table/002n0000001n000000/ https://www.orafaq.com/wiki/Nologging_and_force_logging

Outcomes