Ask the Community
Groups
Oracle Database: Incremental Forever Schedules on Linux Platforms - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Oracle Database: Incremental Forever Schedules on Linux Platforms</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="purpose">Purpose</h3> <p>If you are running application level Oracle Database backups you should exclude Oracle Database objects from the journal. This article applies to the following:</p> <h3 data-id="description">Description</h3> <p>The Unitrends Linux Agent runs a journaling daemon called mynotify to track changes to individual files on the client. This journal is used when running incremental and differential backups to reduce the overhead associated with identifying recently modified or deleted files. If you are running application level Oracle Database backups you should exclude Oracle Database objects from the journal.</p> <h3 data-id="cause">Cause</h3> <p>Oracle Database generates a high volume of events for the journal. This can lead to frequent file-level incremental backup failures due to a Journal Range Exceeded error. To prevent this you need to exclude Oracle Database directories from journal tracking and ensure you are running both file-level and application-level backups.</p> <h3 data-id="resolution">Resolution</h3> <p>Run the following from a terminal on the client while logged in as root:</p> <ol start="1"><li>Load your Oracle Instance location into the shells environment:</li></ol><pre class="code codeBlock" spellcheck="false" tabindex="0"> . /etc/oraInst.loc echo ${inventory_loc}</pre> <ol start="2"><li>Identify the Oracle Home locations for each instance of Oracle Database:</li></ol><pre class="code codeBlock" spellcheck="false" tabindex="0"> grep LOC ${inventory_loc}/ContentsXML/inventory.xml </pre> <ol start="3"><li>Identify the Oracle Base directory for each instance of Oracle Database. For each Oracle Home path identified in step 2. run the following:</li></ol><pre class="code codeBlock" spellcheck="false" tabindex="0"> export ORACLE_HOME=path ${ORACLE_HOME}/bin/orabase</pre> <ol start="4"><li>Add each of the Oracle Home and Oracle Base locations to the journals excusion file. For each Oracle Home and Oracle Base path run the following:</li></ol><pre class="code codeBlock" spellcheck="false" tabindex="0"> echo path >> /usr/bp/incremental_forever/journal.excludes</pre> <ol start="5"><li>Restart the mynotify daemon.</li></ol><pre class="code codeBlock" spellcheck="false" tabindex="0"> /usr/local/bin/mynotify stop /usr/local/bin/mynotify start</pre> </article> </main>