Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What does the option Use Logging [in the synchronization script] do?

April 26, 2017logging option Script synchronization

0

10 Posted

What does the option Use Logging [in the synchronization script] do?

1 Answer

0

Posted

Logging provides the ability of the Oracle RDBMS to recover to the last completed transaction. This is the expected behavior of an RDBMS. There are times when you have complete control of the upgrade process and the whole database. Under these special circumstances, you may elect to turn off all logging for the synchronization process and on completion, perform a hot [or cold backup] of your database. What needs to be understood is that in the event of media failure you lose everything. A half way option is provided whereby you can disable logging for indexes only. In the event of media failure you can simply rebuild these indexes (after the database has been recovered of course).