Oracle Database Backups Fail Due to "cp: cannot stat `/usr/bp/mnt/<user_directory>': No such file or directory - Connect IT Community

/* * These styles apply ONLY to the header and footer assets. */ * { padding: 0; margin: 0; box-sizing: border-box; } .super-nav { display: flex; justify-content: flex-end; align-items: center; margin: 0 auto; max-width: 1264px; padding-left: 40px; padding-right: 40px; height: 40px; text-align: right; } .super-nav a { color: #34427c; margin-right: 20px; padding: 10px; text-decoration: none; } .super-nav a:hover, .super-nav a:focus { background-color: #f7f9fa; } .footer { background: #f5f5f6; color: #555a62; font-size: 14px; line-height: 1.5; padding: 0; } .footer-image { background-image: url("/themes/kaseya/assets/images/footerImage.png"); height: 500px; background-repeat: no-repeat; background-size: cover; margin-top: -100px; } .footer-wrap { padding-left: 18px; padding-right: 18px; max-width: 1236px; margin: 0 auto; } .footer-main-content { background-color: #000; padding: 100px 0; } .footer .footer-col-title { color: #ffffff; font-weight: 700; font-size: 13px; padding-bottom: 10px; text-transform: uppercase; } .footer .footer-link { color: #9b9ca0; text-decoration: none; } .footer .footer-link:hover, .footer .footer-link:focus, .footer .footer-link:active { text-decoration: underline; } .footer-main-content .footer-link { padding-top: 10px; } .footer-row { display: flex; flex-wrap: wrap; justify-content: space-between; align-items: center; margin: -3px; } .footer-main-content-row { align-items: flex-start; } .footer-bottom-content { padding: 10px; align-items: center; } .footer-col { padding: 0 3px; display: flex; flex-direction: column; } .footer-col-copyRight { justify-content: flex-start; color: #9b9ca0; flex: 1; display: flex; } .footer-last-col { flex-direction: row; } .footer-last-col .footer-link { padding-right: 10px; text-transform: uppercase; } @media screen and (max-width: 768px) { .super-nav { padding-right: 0; } .footer-image { height: 250px; } .footer-main-content { padding: 40px 0; } .footer .footer-col-title { padding-top: 10px; } .footer-row:not(.footer-main-content-row) { display: block; } .footer-col:not(.footer-main-content-col) { width: 100%; text-align: center; padding: 10px 0; } .footer-main-content-col { width: 50%; } .footer-last-col { flex-direction: column; } .footer-last-col .footer-link { padding-bottom: 10px; } } /*# sourceMappingURL=styles.css.map */ Ask the Community Groups

Oracle Database Backups Fail Due to "cp: cannot stat `/usr/bp/mnt/<user_directory>': No such file or directory - Connect IT Community | Kaseya

SUMMARY

Oracle backups fail due to local mounted directory (/usr/bp/mnt/

ISSUE

Oracle backups fail due to local mounted directory (/usr/bp/mnt/<oracle_db_name>/<backup_type>.task) cannot be found. For Instance, customer has an Oracle database called 'test', and we are running a full backup on that database. Error in rae logs would indicate (note: n=the backup number that failed):

[LOG4] pghelper.c:1861: Executing query with text: SELECT status FROM bp.jobs WHERE job_no = n
[LOG4] pghelper.c:1247: row 0, col 0(status): '512'
[LOG4] pghelper.c:1861: Executing query with text: SELECT status FROM bp.jobs WHERE job_no = n
[LOG4] pghelper.c:1247: row 0, col 0(status): '512'
[LOG4] [methods.c:134] Reading complete. Read 83 bytes
[LOG0] [methods.c:597] Command "(no description)" completed with exit code 1
[LOG0] [methods.c:604] Details:
Method: BP-Proto
Execute: cp -f /usr/bp/mnt/test/oracle_full.n.task /tmp/oracle_full.n.task
Output:
cp: cannot stat `/usr/bp/mnt/test/oracle_full.n.task': No such file or directory

RESOLUTION

Perform the following steps to add fsid=0 to the exportfs command in the /usr/bp/bpinit/rae.conf.d/utilities.conf file:

Save current file:

cp /usr/bp/bpinit/rae.conf.d/utilities.conf  /usr/bp/bpinit/rae.conf.d/utilities.conf.orig

Open /usr/bp/bpinit/rae.conf.d/utilities.conf for editing:

vi /usr/bp/bpinit/rae.conf.d/utilities.conf

Search for 'exportfs:

/exportfs

Line before change:

<Execute>exportfs -o rw,all_squash,anonuid=0,anongid=0 ${ClientName}:${SharePath}</Execute>

Line after change:

<Execute>exportfs -o rw,all_squash,anonuid=0,anongid=0,fsid=0 ${ClientName}:${SharePath}</Execute>

Save the file:

:wq!

Restart nfs service on Oracle if stale
Run a full backup of the Oracle Database

CAUSE

The issue occurs because we are not cleanly unmounting the NFS share, and causing a stale mount. The fix will properly mount and unmount the NFS share used for Oracle database backups.