Oracle backup 7.1 error

qyclub · ‎08-29-2012

8/30/2012 10:33:20 AM - Info nbjm(pid=3892) starting backup job (jobid=2056) for client meswipdb2, policy MESBDOnlinebackup, schedule Fullbackup

8/30/2012 10:33:20 AM - Info nbjm(pid=3892) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=2056, request id:{BAB59E5B-B614-4AE6-A836-7CCF489B0791})

8/30/2012 10:33:20 AM - requesting resource StorageMESBackupDB

8/30/2012 10:33:20 AM - requesting resource mfcnbu.mflex.com.cn.NBU_CLIENT.MAXJOBS.meswipdb2

8/30/2012 10:33:20 AM - requesting resource mfcnbu.mflex.com.cn.NBU_POLICY.MAXJOBS.BDOnlinebackup

8/30/2012 10:33:20 AM - granted resource mfcnbu.mflex.com.cn.NBU_CLIENT.MAXJOBS.meswipdb2

8/30/2012 10:33:20 AM - granted resource mfcnbu.mflex.com.cn.NBU_POLICY.MAXJOBS.MESBDOnlinebackup

8/30/2012 10:33:20 AM - granted resource StorageMESBackupDB

8/30/2012 10:33:20 AM - estimated 0 Kbytes needed

8/30/2012 10:33:20 AM - Info nbjm(pid=3892) started backup job for client meswipdb2, policy MESBDOnlinebackup, schedule Fullbackup on storage unit StorageMESBackupDB

8/30/2012 10:33:21 AM - Info bpbrm(pid=5248) meswipdb2 is the host to backup data from

8/30/2012 10:33:21 AM - Info bpbrm(pid=5248) reading file list from client

8/30/2012 10:33:21 AM - started process bpbrm (5248)

8/30/2012 10:33:21 AM - connecting

8/30/2012 10:33:23 AM - Info bpbrm(pid=5248) starting bphdb on client

8/30/2012 10:33:23 AM - Info bphdb(pid=21332) Backup started

8/30/2012 10:33:23 AM - Info bphdb(pid=21332) Processing /usr/openv/netbackup/ext/db_ext/oracle/hot_database_backup-wip2.sh

8/30/2012 10:33:23 AM - Info bphdb(pid=21332) Waiting for the child status

8/30/2012 10:33:23 AM - connected; connect time: 00:00:02

8/30/2012 10:33:24 AM - Error bpbrm(pid=5248) from client meswipdb2: ERR - Script exited with status = 29 <failed trying to exec a command>

8/30/2012 10:33:24 AM - Error bpbrm(pid=5248) from client meswipdb2: ERR - bphdb exit status = 6: the backup failed to back up the requested files

8/30/2012 10:33:25 AM - end writing

the backup failed to back up the requested files(6)

8/30/2012 10:33:30 AM - Info bphdb(pid=21332) done. status: 6: the backup failed to back up the requested files

Marianne · ‎08-29-2012

Double-check script /usr/openv/netbackup/ext/db_ext/oracle/hot_database_backup-wip2.sh:

Is there a 'su - oracle-user ....' in the script?

When backup is started from the master server, the script is exrcuted as root on the client.
Because root does not have any Oracle rights, this 'su' to Oracle user is necessary.

Have a look at this example in NBU script and compare with yours:

# Replace ora81, below, with the Oracle DBA user id (account).
ORACLE_USER=ora81
.........
........

if [ "$CUSER" = "root" ]
then
    su - $ORACLE_USER -c "$CMD_STR" >> $RMAN_LOG_FILE
    RSTAT=$?
else
    /usr/bin/sh -c "$CMD_STR" >> $RMAN_LOG_FILE
    RSTAT=$?
fi

Perform the following tests on the client:

Login as Oracle user and run the script manually.
Let us know the result
Login as root and run the script manually.
Let us know the result

Handy NetBackup Links

Mike_Gavrilov · ‎08-30-2012

Create /usr/openv/netbackup/logs/bphdb folder on client. Re-run the backup policy. You'll got some files there. For example:

-rw-rw-rw-   1 root     root       32614 Aug 30 13:29 log.083012
-rw-r--r--   1 root     root           0 Aug 30 00:44 obk_stderr.083012
-rw-r--r--   1 root     root        2707 Aug 30 13:29 obk_stdout.083012

Check obk_stderr.083012 first and other logs after that. It might give you a clue.

VOX

Oracle backup 7.1 error