Forum Discussion

Bharath_Achar's avatar
Bharath_Achar
Level 6
9 years ago

Oracle RMAN backup completing succesfully with No KB & no child streams

Hello All,

Oracle RMAN backup completing succesfully with No KB in activity monitor & no child streams.

Required permission have been set to logs directries and sub-directories.

bpdbclient & bpcd logs are not generating.

 

bphdb log:

17:28:50.545 [31875] <2> logparams: -sb -rdbms oracle -S master.domina.com -to 300 -c E_Test_ORA_UNX_Full_TBS -s Full -clnt Client.domain.com -FULL
-kl 28 -b Client.domain.com_1444685325 -jobid 2123
17:28:50.546 [31875] <4> bphdb: INF - setenv NB_ORA_POLICY=E_Test_ORA_UNX_Full_TBS
17:28:50.546 [31875] <4> bphdb: INF - setenv NB_ORA_CLIENT=Client.domain.com
17:28:50.546 [31875] <4> bphdb: INF - setenv NB_ORA_MODE=B
17:28:50.546 [31875] <4> bphdb: INF - NB_ORA_POLICY=E_Test_ORA_UNX_Full_TBS
17:28:50.546 [31875] <4> bphdb: INF - NB_ORA_SCHED not defined.
17:28:50.546 [31875] <4> bphdb: INF - NB_ORA_PC_SCHED=Full
17:28:50.546 [31875] <4> bphdb: INF - NB_ORA_SERV=master.domina.com
17:28:50.546 [31875] <4> bphdb: INF - NB_ORA_PC_BTYPE not set
17:28:50.546 [31875] <4> bphdb: INF - setenv NB_ORA_FULL=1
17:28:50.546 [31875] <4> bphdb: INF - setenv NB_ORA_INCR=0
17:28:50.547 [31875] <4> bphdb: INF - setenv NB_ORA_CINC=0
17:28:50.547 [31875] <4> bphdb: INF - setenv NB_ORA_SCHEDULED=1
17:28:50.547 [31875] <4> bphdb: INF - setenv NB_ORA_PARENT_JOBID=2123
17:28:50.547 [31875] <4> bphdb: INF - BACKUP START 31875
17:28:50.617 [31875] <4> bphdb: INF - CONTINUE BACKUP message received

17:28:50.617 [31875] <4> bphdb: INF - Processing /oracle/tbsbin/rman_full_nb.sh
17:28:50.618 [31876] <4> bphdb: INF - Child executing /oracle/tbsbin/rman_full_nb.sh
17:28:50.619 [31875] <4> bphdb: INF - Waiting for the child status
17:28:53.622 [31875] <4> bphdb: INF - Script exited with status = 0 <the requested operation was successfully completed>
17:28:53.623 [31875] <4> bphdb: INF - bphdb exit normal

17:28:53.623 [31875] <4> bphdb: INF - EXIT STATUS 0: the requested operation was successfully completed

 

 

 

Plese help.

7.6
Agents
Backing Up
Backup and Recovery
Basics
Installing
Integration
NetBackup
Rules
Training
  • Marianne's avatar
    Marianne
    9 years ago

    Please have a look at the sample scripts as suggested before.

    When triggered from the master server, the script is run by root user. root user does not have oracle db rights. There needs to be a test for username, if not oracle, then 'su - oracle' to run rman commands.

    Extract from sample script (which is missing in your backup script):

    # Determine the user which is executing this script.
    # ---------------------------------------------------------------------------
    CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`
    ....
    ...

    # Initiate the command string
     
    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

16 Replies

Sort By
Show More
  • winter_prince's avatar
    winter_prince
    Level 4
    9 years ago

    Hi Bharath,


    How the issue will be resolved..? Please use the sample netbackup scripts.. Ask your DBA to compare the script and write new one... 

    The script you provided seems a different one.

     

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago
    It's been 3 days since the opening post.... What is taking your dba's so long? One would think that a knowledgeable dba would look at the output and fix the script error in 30 seconds flat....
  • Bharath_Achar's avatar
    Bharath_Achar
    Level 6
    9 years ago

    Hi All,

     

    When backup triggered from DBAs (User backup), it generates child streams & its shows KBs backed up.

    However if we manually try triggering from Netbckup, its completing with status 0 & no child streams.

     

    Please help.

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    Please have a look at the sample scripts as suggested before.

    When triggered from the master server, the script is run by root user. root user does not have oracle db rights. There needs to be a test for username, if not oracle, then 'su - oracle' to run rman commands.

    Extract from sample script (which is missing in your backup script):

    # Determine the user which is executing this script.
    # ---------------------------------------------------------------------------
    CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`
    ....
    ...

    # Initiate the command string
     
    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
  • winter_prince's avatar
    winter_prince
    Level 4
    9 years ago

    This is pointless... Did you manage to use the sample scripts..? Your replies doesnt make any sense...