on 08-24-2007 6:44 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please provide backup log (the 5 hours version)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.