Ask the Community
Groups
Oracle Backup Failure - file create error - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Oracle Backup fails with file create error</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>ORA-19504: failed to create file "/usr/bp/mnt/natest/unitrends-full-NATESTxx-20150609-220-1-881946839"<br>ORA-27040: file create error, unable to create file<br>Linux-x86_64 Error: 22: Invalid argument<br> <br>This is caused by the option FILESYSTEMIO_OPTIONS viewable by “show parameter filesystemio_options”<br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.oracle.com%2Fcd%2FB28359_01%2Fserver.111%2Fb28320%2Finitparams083.htm%23REFRN10061">https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams083.htm#REFRN10061</a><br> <br>If this option is set to “directIO” or “setall” configuration, the Oracle system will refuse to write data to the NFS (default protocol) or CIFS share on the Unitrends system, indicating that it is unable to create the file (manual testing of individual script items indicate that the filesystem is read only, when it is tested and confirmed manually not to be).<br>Due to the way we perform our RMAN backups, these configuration options are invalid for use with the Unitrends system. The valid options are “asynch” and “none”.<br> <br>Additional Reading:<br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F2475652">https://community.oracle.com/thread/2475652</a><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Foracle-base.com%2Farticles%2Fmisc%2Fdirect-and-asynchronous-io.php">http://oracle-base.com/articles/misc/direct-and-asynchronous-io.php</a><br> <br>Tested and confirmed on RHEL Oracle 11.2.02<br><br>For more detailed information on backup failures and performance issues see <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Funitrends-support.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360013174757">Unitrends KB 5062 - Backup Failures and Performance Issues</a></p> </article> </main>