Forum Discussion

qyclub's avatar
qyclub
13 years ago

Oracle backup 7.1 error

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

7.1.x and Earlier
Backing Up
Backup and Recovery
NetBackup

2 Replies

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    13 years ago

    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:

    1. Login as Oracle user and run the script manually. 
      Let us know the result
    2. Login as root and run the script manually. 
      Let us know the result
  • Mike_Gavrilov's avatar
    Mike_Gavrilov
    Level 6
    13 years ago

    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.