cancel
Showing results for 
Search instead for 
Did you mean: 

Slow progress of offline backup

Former Member
0 Kudos

Dear All,

We are facing a problem regarding our backup times .It is taking much more time as it was taking before. Backup time details are given below :-

Backup Mode Time (Present) Time (Before)

Offline 5 hours 45 mins

Online 5 hours 35 mins

Note : Last week we had performed a power shutdown and we are observing the time difference for backups after that .

System Information :

OS - HP-UX (ia64)

DB - Oracle 9.2

Kernel Release- 640 Patch - 129

BrTools -BRBACKUP 6.40 (15)

Online backup command : (Schedule from DB13)

brbackup -u / -c force -t online -m all -p <paramfile> -a -c force -p <paramfile> -sd

Offline backup command :

brbackup -u / -p <paramfile> -o time -c force -a -p <paramfile> -sd

-c force

Can anybody put light in this matter to reduce the time of backups ?

Regards,

Souren

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Have you recently changed the Oracle parameter FILESYSTEMIO_OPTIONS or have you switched the mount options of a SAPDATA file system? If yes, from which value to which value? And did the change correlate with the increased backup runtimes?

Regards

Martin

former_member204746
Active Contributor
0 Kudos

you are doing backups on disk. if this disk is on a SAN, perhaps another process from another server using the same disks is running at the same time?

0 Kudos

Check

- if there is any disk failure (in RAID) for the system

- the operating system log

- if any process is running in background at the sametime which is causing high disk accesses

- if the backup device is processing any backups at the same time and putting this particular backup in the queue

markus_doehr2
Active Contributor
0 Kudos

> Dear All,

>

> We are facing a problem regarding our backup times

> .It is taking much more time as it was taking before.

Before WHAT? What happened to the machine? Operating system patches?

--

Markus

former_member204746
Active Contributor
0 Kudos

please provide backup log (the 5 hours version)

Former Member
0 Kudos

Dear Eric,

Please find below the Offline and Online backup logs respectively (from db14 [off.]and db13 [on] ). Please suggest accordingly : -

<b>Offline Backup log :</b>

Database backup log from 23.08.2007 17:40:28 bdvzkvrg.afd

Return code: 0000 Success Database host: itcchqbd

Tape name Pos. Backup time Compr. File ID File name

23.08.2007 17:56:14 3 /oracle/BD2/sapdata4/bd2_1/bd2.data1

23.08.2007 18:10:28 4 /oracle/BD2/sapdata4/bd2_2/bd2.data2

23.08.2007 18:29:00 5 /oracle/BD2/sapdata4/bd2_3/bd2.data3

23.08.2007 19:03:42 11 /oracle/BD2/sapdata4/bd2_4/bd2.data4

23.08.2007 19:14:58 6 /oracle/BD2/sapdata4/bd2640_1/bd2640.data

23.08.2007 19:47:51 8 /oracle/BD2/sapdata4/bd2640_3/bd2640.data

23.08.2007 20:09:32 12 /oracle/BD2/sapdata4/bd2640_5/bd2640.data

23.08.2007 20:15:57 9 /oracle/BD2/sapdata4/bd2640_4/bd2640.data

23.08.2007 20:42:44 7 /oracle/BD2/sapdata4/bd2640_2/bd2640.data

23.08.2007 20:42:50 10 /oracle/BD2/sapdata4/bd2usr_1/bd2usr.data

23.08.2007 20:43:58 1 /oracle/BD2/sapdata3/temp_1/temp.data1

23.08.2007 22:33:16 2 /oracle/BD2/sapdata2/undo_1/undo.data1

23.08.2007 22:44:04 1 /oracle/BD2/sapdata1/system_1/system.data

23.08.2007 22:44:14 1 /oracle/BD2/origlogA/log_g11m1.dbf

23.08.2007 22:44:18 2 /oracle/BD2/origlogB/log_g12m1.dbf

23.08.2007 22:44:26 3 /oracle/BD2/origlogA/log_g13m1.dbf

23.08.2007 22:44:32 4 /oracle/BD2/origlogB/log_g14m1.dbf

23.08.2007 22:44:47 /oracle/BD2/origlogA/cntrl/cntrlBD2.dbf

<b>Online backup log:</b>

22.08.2007 18:00:21 Job started

22.08.2007 18:00:21 Step 001 started (program RSDBAJOB, variant &0000000000024, user ID SOUREN)

22.08.2007 18:00:21 Execute logical command BRBACKUP On host itcchqbd

22.08.2007 18:00:21 Parameters:-u / -c force -t online -m all -p initBD2.sap.daily -a -c force -p initBD2.sap.daily -sd

22.08.2007 23:19:24 BR0051I BRBACKUP 6.40 (15)

22.08.2007 23:19:24 BR0055I Start of database backup: bdvzfzqc.and 2007-08-22 18.00.22

22.08.2007 23:19:24 BR0477I Oracle pfile /oracle/BD2/920_64/dbs/initBD2.ora created from spfile /oracle/BD2/920_64/dbs/spfileBD2.ora

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0319I Control file copy created: /oracle/BD2/sapbackup/cntrlBD2.dbf 9248768

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.00.24

22.08.2007 23:19:24 BR0057I Backup of database: BD2

22.08.2007 23:19:24 BR0058I BRBACKUP action ID: bdvzfzqc

22.08.2007 23:19:24 BR0059I BRBACKUP function ID: and

22.08.2007 23:19:24 BR0110I Backup mode: ALL

22.08.2007 23:19:24 BR0077I Database file for backup: /oracle/BD2/sapbackup/cntrlBD2.dbf

22.08.2007 23:19:24 BR0061I 13 files found for backup, total size 32082.914 MB

22.08.2007 23:19:24 BR0143I Backup type: online

22.08.2007 23:19:24 BR0112I Files will not be compressed

22.08.2007 23:19:24 BR0130I Backup device type: disk

22.08.2007 23:19:24 BR0106I Files will be saved on disk in directory:/dailybkpbd2/bdvzfzqc

22.08.2007 23:19:24 BR0289I BRARCHIVE will be started at the end of processing

22.08.2007 23:19:24 BR0134I Unattended mode with 'force' active - no operator confirmation allowed

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0370I Directory /dailybkpbd2/bdvzfzqc created

22.08.2007 23:19:24 BR0370I Directory /dailybkpbd2/BD2 created

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving init_ora

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/BD2 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/920_64/dbs/initBD2.sap.daily

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/BD2 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.00.24

22.08.2007 23:19:24 BR0198I Profiles saved successfully

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.00.25

22.08.2007 23:19:24 BR0315I 'Alter tablespace PSAPBD2 begin backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2_1/bd2.data1

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2.data1 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2_1/bd2.data1

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2.data1 #1/1

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.12.56

22.08.2007 23:19:24 BR0063I 1 of 13 files processed - 2340.008 MB of 32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 7.29%, estimated end time: 20:52

22.08.2007 23:19:24 BR0001I ****______________________________________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2_2/bd2.data2

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2.data2 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2_2/bd2.data2

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2.data2 #1/2

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.27.14

22.08.2007 23:19:24 BR0063I 2 of 13 files processed - 4980.016 MB of 32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 15.52%, estimated end time: 20:53

22.08.2007 23:19:24 BR0001I ********__________________________________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2_3/bd2.data3

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2.data3 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2_3/bd2.data3

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2.data3 #1/3

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.40.00

22.08.2007 23:19:24 BR0063I 3 of 13 files processed - 7400.023 MB of 32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 23.07%, estimated end time: 20:52

22.08.2007 23:19:24 BR0001I ************______________________________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2_4/bd2.data4

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2.data4 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2_4/bd2.data4

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2.data4 #1/4

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.56.23

22.08.2007 23:19:24 BR0063I 4 of 13 files processed - 10472.031 MB of32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 32.64%, estimated end time: 20:51

22.08.2007 23:19:24 BR0001I ****************__________________________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.56.24

22.08.2007 23:19:24 BR0317I 'Alter tablespace PSAPBD2 end backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 18.56.24

22.08.2007 23:19:24 BR0315I 'Alter tablespace PSAPBD2640 begin backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2640_1/bd2640.data1

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2640.data1 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2640_1/bd2640.data1

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2640.data1 #1/5

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 19.27.26

22.08.2007 23:19:24 BR0063I 5 of 13 files processed - 12852.039 MB of32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 40.06%, estimated end time: 21:37

22.08.2007 23:19:24 BR0001I ********************______________________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2640_3/bd2640.data3

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2640.data3 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2640_3/bd2640.data3

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2640.data3 #1/6

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 20.24.52

22.08.2007 23:19:24 BR0063I 6 of 13 files processed - 15332.047 MB of32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 47.79%, estimated end time: 23:02

22.08.2007 23:19:24 BR0001I ************************__________________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2640_5/bd2640.data5

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2640.data5 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2640_5/bd2640.data5

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2640.data5 #1/7

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 21.36.31

22.08.2007 23:19:24 BR0063I 7 of 13 files processed - 18404.055 MB of32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 57.36%, estimated end time: 0:17

22.08.2007 23:19:24 BR0001I *****************************_____________________

22.08.2007 23:19:24 BR0001I *****************************_____________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2640_4/bd2640.data4

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2640.data4 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2640_4/bd2640.data4

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2640.data4 #1/8

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 22.01.14

22.08.2007 23:19:24 BR0063I 8 of 13 files processed - 19864.062 MB of32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 61.91%, estimated end time: 0:29

22.08.2007 23:19:24 BR0001I *******************************___________________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2640_2/bd2640.data2

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2640.data2 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2640_2/bd2640.data2

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2640.data2 #1/9

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 22.22.07

22.08.2007 23:19:24 BR0063I 9 of 13 files processed - 22344.070 MB of32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 69.64%, estimated end time: 0:16

22.08.2007 23:19:24 BR0001I ***********************************_______________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 22.22.08

22.08.2007 23:19:24 BR0317I 'Alter tablespace PSAPBD2640 end backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 22.22.08

22.08.2007 23:19:24 BR0315I 'Alter tablespace PSAPBD2USR begin backup' successful

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata4/bd2usr_1/bd2usr.data1

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/bd2usr.data1 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata4/bd2usr_1/bd2usr.data1

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/bd2usr.data1 #1/10

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 22.22.18

22.08.2007 23:19:24 BR0063I 10 of 13 files processed - 22364.078 MB of 32082.914 MB don

22.08.2007 23:19:24 BR0204I Percentage done: 69.71%, estimated end time: 0:16

22.08.2007 23:19:24 BR0001I ***********************************_______________

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 22.22.18

22.08.2007 23:19:24 BR0317I 'Alter tablespace PSAPBD2USR end backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 22.22.19

22.08.2007 23:19:24 BR0315I 'Alter tablespace PSAPUNDO begin backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata2/undo_1/undo.data1

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/undo.data1 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata2/undo_1/undo.data1

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/undo.data1 #1/11

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.17.08

22.08.2007 23:19:24 BR0063I 11 of 13 files processed - 31524.086 MB of 32082.914 MB don

22.08.2007 23:19:24 BR0204I Percentage done: 98.26%, estimated end time: 23:22

22.08.2007 23:19:24 BR0001I *************************************************_

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.17.08

22.08.2007 23:19:24 BR0317I 'Alter tablespace PSAPUNDO end backup' successful

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.17.08

22.08.2007 23:19:24 BR0317I 'Alter tablespace PSAPUNDO end backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.17.08

22.08.2007 23:19:24 BR0315I 'Alter tablespace SYSTEM begin backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapdata1/system_1/system.data1

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/system.data1 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapdata1/system_1/system.data1

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/system.data1 #1/12

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.19.02

22.08.2007 23:19:24 BR0063I 12 of 13 files processed - 32074.094 MB of 32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 99.97%, estimated end time: 23:19

22.08.2007 23:19:24 BR0001I **************************************************

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.19.02

22.08.2007 23:19:24 BR0317I 'Alter tablespace SYSTEM end backup' successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapbackup/cntrlBD2.dbf

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/bdvzfzqc/cntrlBD2.dbf ...

22.08.2007 23:19:24

22.08.2007 23:19:24 #FILE..... /oracle/BD2/sapbackup/cntrlBD2.dbf

22.08.2007 23:19:24 #SAVED.... /dailybkpbd2/bdvzfzqc/cntrlBD2.dbf #1/13

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.19.04

22.08.2007 23:19:24 BR0063I 13 of 13 files processed - 32082.914 MB of 32082.914 MB done

22.08.2007 23:19:24 BR0204I Percentage done: 100.00%, estimated end time: 23:19

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.19.06

22.08.2007 23:19:24 BR0340I Switching to next online redo log file for database instance BD2 ...

22.08.2007 23:19:24 BR0321I Switch to next online redo log file for database instance BD2 successful

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving space_log

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/BD2 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapbackup/bdvzfzqc.and

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/BD2 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0202I Saving /oracle/BD2/sapbackup/backBD2.log

22.08.2007 23:19:24 BR0203I to /dailybkpbd2/BD2 ...

22.08.2007 23:19:24

22.08.2007 23:19:24 BR0056I End of database backup: bdvzfzqc.and 2007-08-22 23.19.06

22.08.2007 23:19:24 BR0280I BRBACKUP time stamp: 2007-08-22 23.19.06

22.08.2007 23:19:24 BR0052I BRBACKUP completed successfully

Regards,

Souren