Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Offline backup executes child jobs of online backup

Created: 15 Oct 2013 | 8 comments

Hi all,

When we initiate the offline SAP DB backup the parent job starts fine, but it executes the online backup child jobs.

Netbackup Master and client Server is 7.0.1

Backup 0 Done ABC_XX Default-Application-Backup Sun Oct 13 20:24:07 CEST 2013
Backup 0 Done ABC_XX Default-Application-Backup Sun Oct 13 20:01:22 CEST 2013
Backup 0 Done ABC_XX Default-Application-Backup Sun Oct 13 20:01:22 CEST 2013
Backup 0 Done ABC_XX Default-Application-Backup Sun Oct 13 20:01:22 CEST 2013
Backup 0 Done ABC_XX Default-Application-Backup Sun Oct 13 20:01:22 CEST 2013
Backup 0 Done ABC_XX Default-Application-Backup Sun Oct 13 20:01:22 CEST 2013
Backup 0 Done ABC_XX Default-Application-Backup Sun Oct 13 20:01:22 CEST 2013
Backup 0 Done ABC_XX_OFF Full Sun Oct 13 20:00:00 CEST 2013

 

Operating Systems:

Comments 8 CommentsJump to latest comment

RamNagalla's picture

this is the normal behaivor,  Data base backup tirgger the child streams and the policy names and Schedules names are based on how they defiend on the Script

if it is using the policy name as ABC_XX in the child stream that is how its defined in the Script...

 

cs3472's picture

But there is no difference in backing up the same online backup data while triggering the offline backup. When checked the data size both are same.

This is the offline script:

echo "SAP_SCHEDULED = $SAP_SCHEDULED"
echo "SAP_USER_INITIATED = $SAP_USER_INITIATED"
echo "SAP_SERVER = $SAP_SERVER"
echo "SAP_POLICY = $SAP_POLICY"

RETURN_STATUS=0

SAP_ENV=""

if [ -n "$SAP_SERVER" ]
then
        SAP_ENV="$SAP_ENV setenv SAP_SERVER $SAP_SERVER;"
fi

if [ -n "$SAP_POLICY" ]
then

        SAP_ENV="$SAP_ENV setenv SAP_POLICY $SAP_POLICY;"
fi

#
# Full offline backup
#

CMD_LINE="$SAP_ENV brbackup -c -d util_file -t offline -m all -u /"

#
# The username on the "su" command needs to be replaced with the correct
# user name.
#
echo "Stop SAP"
su - xxaadm -c "stopsap r3"
echo "Execute $CMD_LINE"
su - oraxxa -c "$CMD_LINE"
echo "Start SAP"
su - xxaadm -c "startsap r3"
RETURN_STATUS=$?

exit $RETURN_STATUS
  

Will Restore's picture

you have to specify the correct schedule with $SAP_SCHED  environment variable or in the initSID.utl

 

About parameters used in initSID.utl

This appendix shows the parameters you can specify in the initSID.utl

configuration file. The software passes these parameters to the backint interface

through its -p parfile option.

 

schedule <schedule_name>

This parameter specifies the name of an Application Backup schedule that is

associated with an SAP policy type. The schedule can define aspects of the backup

such as how long NetBackup retains images, maximum multiplexing per drive,

storage unit, and volume pool. The following is an example entry:

schedule sap_full_backup

 

If the NetBackup for SAP backint interface finds the $SAP_SCHED

(%SAP_SCHED%)environment variable, the $SAP_SCHED (%SAP_SCHED%) environment

variable value overrides the schedule parameter value. If the schedule parameter

is not specified and there is no environment variable, then the schedule parameter

value defaults to the BPBACKUP_SCHED option in the NetBackup bp.conf file or the

NetBackup Administration Console. If BPBACKUP_SCHED is not specified there,

NetBackup uses the first Application Backup schedule it finds in the first active

SAP policy.

Will Restore -- where there is a Will there is a way

Will Restore's picture

Hello cs3472, did this help??

 

Will Restore -- where there is a Will there is a way

cs3472's picture

Hello WR,

Yeah I do checked the initSID.utl file, but it calls the online backup policy.

Will there be a separate initSID.util file for backing up online and offline backups?

Or just one initSID.util file which is common to do both online and offline backups?

schedule Default-Application-Backup
#
#
# policy2: is optional and is the name of a policy to be used for the
# secondary SAP backup.  The secondary backup is performed for each SAP
# database backup on files that are needed to track SAP backup information.
# This option would be used to save the backup information on a different
# media.  If policy2 is not specified, then the policy parameter value is used.

 

Will Restore's picture

in that case, may be simpler to use the environment variable

see third paragraph in my post above ^

Will Restore -- where there is a Will there is a way

cs3472's picture

Hello wr,

Can you elaborate the third paragraph in your post. I couldnt get you. Apologize...