10-15-2013 04:18 AM
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 |
10-15-2013 04:49 AM
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...
10-15-2013 05:02 AM
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
10-15-2013 12:40 PM
Any update?
10-15-2013 01:12 PM
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.
10-23-2013 12:50 PM
Hello cs3472, did this help??
10-24-2013 10:01 PM
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.
10-25-2013 06:00 AM
in that case, may be simpler to use the environment variable
see third paragraph in my post above ^
10-26-2013 07:18 AM
Hello wr,
Can you elaborate the third paragraph in your post. I couldnt get you. Apologize...