Offline Backup take more times

[Former Member]

Dear Team ,

Our Production Server Offline backup taking more and more time.But archive Log and Online backup is Ok.

My database size is 160 GB Online backup 90 minutes and Offline backup takes 4 hours 40 Minutes.

I am using IBM tape libarary and using Ultrim 4 tape.

our initPRD.sap setting as below , should we change some one in initPRD.sap

HP-UX sapprd B.11.23 U ia64 (ta)

login: root

Password:

sapprd :/#cd /oracle/PRD/102_64/dbs/

sapprd :/oracle/PRD/102_64/dbs#ll

########################################################################

1. backup mode [all | all_data | full | incr | sap_dir | ora_dir

2. | all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>)]

4. default: all

backup_mode = all

1. restore mode [all | all_data | full | incr | incr_only | incr_full

2. | incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>) | partial | non_db

4. redirection with '=' is not supported here - use option '-m' instead

5. default: all

restore_mode = all

1. backup type [offline | offline_force | offline_standby | offline_split

2. | offline_mirror | offline_stop | online | online_cons | online_split

3. | online_mirror | online_standby | offstby_split | offstby_mirror

4. default: offline

backup_type = online

1. backup device type

2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

5. | rman_prep]

6. default: tape

backup_dev_type = tape

1. backup root directory [<path_name> | (<path_name_list>)]

2. default: $SAPDATA_HOME/sapbackup

backup_root_dir = /oracle/PRD/sapbackup

1. stage root directory [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

stage_root_dir = /oracle/PRD/sapbackup

1. compression flag [no | yes | hardware | only]

2. default: no

compress = hardware

1. compress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <target_file_name> = <source_file_name>.Z

5. for compress command the -c option must be set

6. recommended setting for brbackup -k only run:

7. "compress -b 12 -c $ > $"

8. no default

compress_cmd = "compress -c $ > $"

1. uncompress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <source_file_name> = <target_file_name>.Z

5. for uncompress command the -c option must be set

6. no default

uncompress_cmd = "uncompress -c $ > $"

1. directory for compression [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

compress_dir = /oracle/PRD/sapreorg

1. brarchive function [save | second_copy | double_save | save_delete

2. | second_copy_delete | double_save_delete | copy_save

3. | copy_delete_save | delete_saved | delete_copied]

4. default: save

archive_function = save

1. directory for archive log copies to disk

2. default: first value of the backup_root_dir parameter

archive_copy_dir = /oracle/PRD/sapbackup

1. directory for archive log copies to stage

2. default: first value of the stage_root_dir parameter

archive_stage_dir = /oracle/PRD/sapbackup

1. delete archive logs from duplex destination [only | no | yes | check]

2. default: only

3. archive_dupl_del = only

4. new sapdata home directory for disk_copy | disk_standby

5. no default

6. new_db_home = /oracle/C11

7. stage sapdata home directory for stage_copy | stage_standby

8. default: value of the new_db_home parameter

9. stage_db_home = /oracle/C11

10. original sapdata home directory for split mirror disk backup

11. no default

12. orig_db_home = /oracle/C11

13. remote host name

14. no default

15. remote_host = <host_name>

16. remote user name

17. default: current operating system user

18. remote_user = <user_name>

19. tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu

20. rman_dd | rman_dd_gnu]

21. default: cpio

tape_copy_cmd = dd

1. disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu]

2. default: copy

disk_copy_cmd = copy

1. stage copy command [rcp | scp | ftp]

2. default: rcp

stage_copy_cmd = rcp

1. pipe copy command [rsh | ssh]

2. default: rsh

pipe_copy_cmd = rsh

1. flags for cpio output command

2. default: -ovB

cpio_flags = -ovB

1. flags for cpio input command

2. default: -iuvB

cpio_in_flags = -iuvB

1. flags for cpio command for copy of directories to disk

2. default: -pdcu

3. use flags -pdu for gnu tools

cpio_disk_flags = -pdcu

1. flags for dd output command

2. default: "obs=16k"

3. recommended setting:

4. Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"

5. Windows: "bs=nk", example: "bs=64k"

dd_flags = "obs=128k bs=128k"

1. flags for dd input command

2. default: "ibs=16k"

3. recommended setting:

4. Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"

5. Windows: "bs=nk", example: "bs=64k"

dd_in_flags = "ibs=128k bs=128k"

1. number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]

2. default: 1

saveset_members = 1

1. additional parameters for RMAN

2. rman_channels and rman_filesperset are only used when rman_util,

3. rman_disk or rman_stage

4. rman_channels defines the number of parallel sbt channel allocations

5. rman_filesperset = 0 means:

6. one file per save set - for non-incremental backups

7. all files in one save set - for incremental backups

8. the others have the same meaning as for native RMAN

9. rman_channels = 1

10. rman_filesperset = 0

11. rman_maxpiecesize = 0 # in KB - former name rman_kbytes

12. rman_rate = 0 # in KB - former name rman_readrate

13. rman_maxopenfiles = 0

14. rman_maxsetsize = 0 # in KB - former name rman_setsize

15. additional parameters for RMAN version 8.1

16. the parameters have the same meaning as for native RMAN

17. rman_diskratio = 0 # deprecated in Oracle 10g

18. rman_pool = 0

19. rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex

20. rman_proxy = no | yes | only

21. special parameters for an external backup library, example:

22. rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"

23. rman_send = "'<command>'"

24. rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",

25. "channel sbt_2 '<command2>' parms='<parameters2>'")

26. rman_compress = no | yes

27. rman_maxcorrupt = (<dbf_name>|<dbf_id>:<corr_cnt>, ...)

28. remote copy-out command (backup_dev_type = pipe)

29. $-character is replaced by current device address

30. no default

copy_out_cmd = "dd ibs=8k obs=128k of=$"

1. remote copy-in command (backup_dev_type = pipe)

2. $-character is replaced by current device address

3. no default

copy_in_cmd = "dd ibs=128k obs=8k if=$"

1. rewind command

2. $-character is replaced by current device address

3. no default

4. operating system dependent, examples:

5. HP-UX: "mt -f $ rew"

6. TRU64: "mt -f $ rewind"

7. AIX: "tctl -f $ rewind"

8. Solaris: "mt -f $ rewind"

9. Windows: "mt -f $ rewind"

10. Linux: "mt -f $ rewind"

rewind = "mt -f $ rew"

1. rewind and set offline command

2. $-character is replaced by current device address

3. default: value of the rewind parameter

4. operating system dependent, examples:

5. operating system dependent, examples:

6. Solaris: "mt -f $ fsf $"

7. Windows: "mt -f $ fsf $"

8. Linux: "mt -f $ fsf $"

tape_pos_cmd = "mt -f $ fsf $"

1. mount backup volume command in auto loader / juke box

2. used if backup_dev_type = tape_box | pipe_box

3. split_cmd = "<split_cmd> [$]"

4. resynchronize mirror disks command

5. used if backup_type = offline_split | online_split | offline_mirror

6. | online_mirror

7. no default

8. resync_cmd = "<resync_cmd> [$]"

9. additional options for SPLITINT interface program

10. no default

11. split_options = "<split_options>"

12. 90 m 4 mm DAT DDS-1 tape: 1800M

13. 120 m 4 mm DAT DDS-2 tape: 3800M

14. 125 m 4 mm DAT DDS-3 tape: 11000M

15. 112 m 8 mm Video tape: 2000M

16. 112 m 8 mm high density: 4500M

17. DLT 2000 10/20 GB: 10000M

18. DLT 2000XT 15/30 GB: 15000M

19. DLT 4000 20/40 GB: 20000M

20. level of parallel execution

21. default: 0 - set to number of backup devices

exec_parallel = 0

1. address of backup device without rewind

2. [<dev_address> | (<dev_address_list>)]

3. no default

4. AIX: /dev/rmt0.1

5. Solaris: /dev/rmt/0mn

6. Windows: /dev/nmt0

7. Linux: /dev/nst0

tape_address = /dev/rmt/1mn

1. Solaris: /dev/rmt/0m

2. used by brarchive

3. default: value of the tape_address_rew_arch parameter

4. operating system dependent

5. tape_address_ctl_arch = /dev/...

6. volumes for brarchive

7. [<volume_name> | (<volume_name_list>) | SCRATCH]

8. no default

volume_archive = (PRDA01, PRDA02, PRDA03, PRDA04, PRDA05,

PRDA06, PRDA07, PRDA08, PRDA09, PRDA10,

PRDA11, PRDA12, PRDA13, PRDA14, PRDA15,

PRDA16, PRDA17, PRDA18, PRDA19, PRDA20,

PRDA21, PRDA22, PRDA23, PRDA24, PRDA25,

PRDA26, PRDA27, PRDA28, PRDA29, PRDA30)

1. volumes for brbackup

2. [<volume_name> | (<volume_name_list>) | SCRATCH]

3. no default

volume_backup = (PRDB01, PRDB02, PRDB03, PRDB04, PRDB05,

PRDB06, PRDB07, PRDB08, PRDB09, PRDB10,

PRDB11, PRDB12, PRDB13, PRDB14, PRDB15,

PRDB16, PRDB17, PRDB18, PRDB19, PRDB20,

PRDB21, PRDB22, PRDB23, PRDB24, PRDB25,

PRDB26, PRDB27, PRDB28, PRDB29, PRDB30)

1. default: no parameter file

2. mount_par_file = initPRD.mnt

#

Should I change any parameter

Sunil

[Former Member · Accepted solution]

Sunil, check if there is any third party connection to this database, for example a monitoring tool running a script to report on tablespace freespace.

Often times, when there is a database connection that doesn't let go (or keep reconnecting in quick succession), the database takes a while to shutdown for the offline backup.

The brbackup log files capture time very accurately. If you follow the timestamps in the logs, you can see where it takes the most time. That will be a starting point.

Regards,

Shan

[Former Member]

In addition:

You might find a hint in the log files of brbackup, in sapbackup directory. Where is time lost?

Just a guess: Sometimes it will take long to shut down the database.

[markus_doehr2]

> our initPRD.sap setting as below , should we change some one in initPRD.sap

Very difficult to read. I suggest you post only the lines that have entries, not all comments like

grep -v "\#" initPRD.sap

Markus

[Former Member]

Dear sir,

I am senidng initPRD.sap log file that was without # mark

sapprd :/oracle/PRD/102_64/dbs#more initPRD.sap

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = tape

backup_root_dir = /oracle/PRD/sapbackup

stage_root_dir = /oracle/PRD/sapbackup

compress = hardware

compress_cmd = "compress -c $ > $"

uncompress_cmd = "uncompress -c $ > $"

compress_dir = /oracle/PRD/sapreorg

archive_function = save

archive_copy_dir = /oracle/PRD/sapbackup

archive_stage_dir = /oracle/PRD/sapbackup

disk_copy_cmd = copy

stage_copy_cmd = rcp

pipe_copy_cmd = rsh

cpio_flags = -ovB

cpio_in_flags = -iuvB

cpio_disk_flags = -pdcu

dd_flags = "obs=128k bs=128k"

saveset_members = 1

copy_out_cmd = "dd ibs=8k obs=128k of=$"

copy_in_cmd = "dd ibs=128k obs=8k if=$"

tape_pos_cmd = "mt -f $ fsf $"

tape_size = 800G

tape_address = /dev/rmt/1mn

tape_address_rew = /dev/rmt/1m

expir_period = 0

tape_use_count = 100

sapprd :/oracle/PRD/102_64/dbs#

[gurbirbhatia]

Hi Sunil

How do you taking the offline backup. What procedure / commands are you using

Gurbir Singh

[Former Member]

Dear,

I am taking bakup via T_Code:DB13.

and select whole database offline + Redo log backup

regards

[Former Member]

Hi Sunil,

Your init<SID>.sap file looks bit strange for me.

Mainly "tape_copy_cmd" and "util_par_file" parameters are not seems to be configured.

You might not using any thirdparty backup library.

If you are using thirdparty backup solution then check the below things.

We are also using IBM Tivoli as Backup solution.

and below additional parameters configured in init<SID>.sap

backup_dev_type = util_file
tape_copy_cmd = dd
util_par_file = <path/to/util_file>

Check with your configuration.

One thing I have observed in our setup. If another backup is using tape drive and there is no FREE tape drive available, SAP backup waits for that backup to be finished. In that case SAP backup duration get extended...

Regards.

Rajesh Narkhede