Online Database Backup failed

[Former Member]

Dear Friends,

We have SAP ECC6.0 on HP-UX11 v2 and Oracle 10g.

Online databse backup is scheduled daily but since last 1 months this backup get failed and displays the error message as below.

BR0319I Control file copy created: /oracle/PDR/sapbackup/cntrlPDR.dbf 33538048

BR0328E Database file /oracle/PDR/sapdata1/system_1/system.data1 of tablespace SYSTEM is already in backup status

BR0328E Database file /oracle/PDR/sapdata3/undo_1/undo.data1 of tablespace PSAPUNDO is already in backup status

BR0328E Database file /oracle/PDR/sapdata1/sysaux_1/sysaux.data1 of tablespace SYSAUX is already in backup status

BR0328E Database file /oracle/PDR/sapdata1/pdr_1/pdr.data1 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata1/pdr_2/pdr.data2 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata1/pdr_3/pdr.data3 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata1/pdr_4/pdr.data4 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata1/pdr_5/pdr.data5 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata2/pdr_6/pdr.data6 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata2/pdr_7/pdr.data7 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata2/pdr_8/pdr.data8 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata2/pdr_9/pdr.data9 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata2/pdr_10/pdr.data10 of tablespace PSAPPDR is already in backup status

BR0328E Database file /oracle/PDR/sapdata3/pdr_11/pdr.data11 of tablespace PSAPPDR is already in backup status

But after that we execute comand as below then we take same backup successfully.

SQL>ALTER DATABASE END BACKUP;

We do this excercise every time.

Please help me why the table spaces remaines in backup status ?

Regrads

Ganesh Datt Tiwari

[Former Member]

Dear Friends,

I have recieved very helpfull replies from all of you. Thanks for this to all of you.

My issue has been resolved. We are using a HP RSM tool for replication of data base that was creating problem.

Regards

Ganesh Datt Tiwari

[Former Member]

Tablespaces are not getting altered after your backup, Check SAP notes 1041 and 1042 for the symptoms.

And what is the command that you are using in DP to call BRBACKUP?

Regards,

Nick Loy

[Former Member]

Please check db02 for any backup that is currently in running status . It might be hung . just delete the session in HPDP and restart the backup . it should work fine .make sure you do not start multiple backups at the same time .

[Former Member]

Hi Ganesh ,

Can you please provide the backup log for a successfull backup after which the tablespaces still remain in backup mode.May be if you check the tail end of brbackup logs you may fine something fishy.

Regards

Amit

[Former Member]

Hi Amit,

Thanks for your valuable reply.

Please find the below log

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 02:28:29 Starting OB2BAR Backup: dbpdr:PDR.3 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 2:28:29 AMStarting OB2BAR Backup: dbpdr:PDR.1 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 2:28:29 AMStarting OB2BAR Backup: dbpdr:PDR.2 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 02:28:29 Starting OB2BAR Backup: dbpdr:PDR.2 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 02:28:29 Starting OB2BAR Backup: dbpdr:PDR.1 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 02:28:29 Starting OB2BAR Backup: dbpdr:PDR.0 "SAP"

BR0280I BRBACKUP time stamp: 2011-05-29 02.34.04#FILE..... /oracle/PDR/sapdata1/pdr_3/pdr.data3

#SAVED.... 20110529.0003.02BR0280I BRBACKUP time stamp: 2011-05-2902.34.04#FILE..... /oracle/PDR/sapdata1/pdr_4/pdr.data4

#SAVED.... 20110529.0003.03BR0280I BRBACKUP time stamp: 2011-05-29 02.34.04#FILE..... /oracle/PDR/sapdata1/pdr_1/pdr.data1

#SAVED.... 20110529.0003.00BR0280I BRBACKUP time stamp: 2011-05-29 02.34.04#FILE..... /oracle/PDR/sapdata1/pdr_2/pdr.data2

#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 02.39.31

#FILE..... /oracle/PDR/sapdata2/pdr_7/pdr.data7#SAVED.... 20110529.0003.02

BR0280I BRBACKUP time stamp: 2011-05-29 02.39.32

#FILE..... /oracle/PDR/sapdata2/pdr_8/pdr.data8#SAVED.... 20110529.0003.03

BR0280I BRBACKUP time stamp: 2011-05-29 02.39.33#FILE..... /oracle/PDR/sapdata2/pdr_6/pdr.data6

#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 02.39.38#FILE..... /oracle/PDR/sapdata1/pdr_5/pdr.data5

#SAVED.... 20110529.0003.00BR0280I BRBACKUP time stamp: 2011-05-29 02.44.58

#FILE..... /oracle/PDR/sapdata2/pdr_10/pdr.data10#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 02.45.02#FILE..... /oracle/PDR/sapdata2/pdr_9/pdr.data9

#SAVED.... 20110529.0003.00BR0280I BRBACKUP time stamp: 2011-05-29 02.45.04

#FILE..... /oracle/PDR/sapdata3/pdr_12/pdr.data12#SAVED.... 20110529.0003.03

BR0280I BRBACKUP time stamp: 2011-05-29 02.45.04

#FILE..... /oracle/PDR/sapdata3/pdr_11/pdr.data11#SAVED.... 20110529.0003.02

BR0280I BRBACKUP time stamp: 2011-05-29 02.50.29#FILE..... /oracle/PDR/sapdata3/pdr_14/pdr.data14

#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 02.50.31

#FILE..... /oracle/PDR/sapdata4/pdr_16/pdr.data16#SAVED.... 20110529.0003.03BR0280I BRBACKUP time stamp: 2011-05-29 02.50.32#FILE..... /oracle/PDR/sapdata3/pdr_13/pdr.data13#SAVED.... 20110529.0003.00

BR0280I BRBACKUP time stamp: 2011-05-29 02.50.35

#FILE..... /oracle/PDR/sapdata3/pdr_15/pdr.data15#SAVED.... 20110529.0003.02BR0280I BRBACKUP time stamp: 2011-05-29 02.55.59#FILE..... /oracle/PDR/sapdata4/pdr_20/pdr.data20

#SAVED.... 20110529.0003.03BR0280I BRBACKUP time stamp: 2011-05-29 02.55.59

#FILE..... /oracle/PDR/sapdata4/pdr_18/pdr.data18#SAVED.... 20110529.0003.01

BR0280I BRBACKUP time stamp: 2011-05-29 02.56.02

#FILE..... /oracle/PDR/sapdata4/pdr_17/pdr.data17#SAVED.... 20110529.0003.00

BR0280I BRBACKUP time stamp: 2011-05-29 02.56.04

#FILE..... /oracle/PDR/sapdata4/pdr_19/pdr.data19#SAVED.... 20110529.0003.02BR0280I BRBACKUP time stamp: 2011-05-29 03.01.41#FILE..... /oracle/PDR/sapdata4/pdr_24/pdr.data24

#SAVED.... 20110529.0003.03BR0280I BRBACKUP time stamp: 2011-05-29 03.01.43

#FILE..... /oracle/PDR/sapdata4/pdr_22/pdr.data22#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 03.01.44#FILE..... /oracle/PDR/sapdata4/pdr_21/pdr.data21#SAVED.... 20110529.0003.00BR0280I BRBACKUP time stamp: 2011-05-29 03.01.48#FILE..... /oracle/PDR/sapdata4/pdr_23/pdr.data23

#SAVED.... 20110529.0003.02BR0280I BRBACKUP time stamp: 2011-05-29 03.07.27

#FILE..... /oracle/PDR/sapdata4/pdr_8/pdr.data28#SAVED.... 20110529.0003.03

BR0280I BRBACKUP time stamp: 2011-05-29 03.07.29#FILE..... /oracle/PDR/sapdata4/pdr_26/pdr.data26#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 03.07.30

#FILE..... /oracle/PDR/sapdata4/pdr_25/pdr.data25

#SAVED.... 20110529.0003.00BR0280I BRBACKUP time stamp: 2011-05-29 03.07.34

#FILE..... /oracle/PDR/sapdata1/pdr_27/pdr.data27

#SAVED.... 20110529.0003.02BR0280I BRBACKUP time stamp: 2011-05-29 03.13.10

#FILE..... /oracle/PDR/sapdata2/pdr_30/pdr.data30

#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 03.13.12

#FILE..... /oracle/PDR/sapdata3/pdr_29/pdr.data29

#SAVED.... 20110529.0003.00BR0280I BRBACKUP time stamp: 2011-05-29 03.13.13

#FILE..... /oracle/PDR/sapdata5/pdr_32/pdr.data32#SAVED.... 20110529.0003.03

BR0280I BRBACKUP time stamp: 2011-05-29 03.13.22#FILE..... /oracle/PDR/sapdata5/pdr_31/pdr.data31

#SAVED.... 20110529.0003.02BR0280I BRBACKUP time stamp: 2011-05-29 03.18.54

#FILE..... /oracle/PDR/sapdata5/pdr_33/pdr.data33#SAVED.... 20110529.0003.00

BR0280I BRBACKUP time stamp: 2011-05-29 03.18.54#FILE..... /oracle/PDR/sapdata5/pdr_34/pdr.data34

#SAVED.... 20110529.0003.01BR0280I BRBACKUP time stamp: 2011-05-29 03.18.57

#FILE..... /oracle/PDR/sapdata6/pdr_36/pdr.data36#SAVED.... 20110529.0003.03BR0280I BRBACKUP time stamp: 2011-05-29 03.19.04#FILE..... /oracle/PDR/sapdata5/pdr_35/pdr.data35

#FILE..... /oracle/PDR/sapdata4/pdr700_13/pdr700.data13

#SAVED.... 20110529.0003.00

BR0280I BRBACKUP time stamp: 2011-05-29 05.58.30

#FILE..... /oracle/PDR/sapdata5/pdr700_17/pdr700.data17

#SAVED.... 20110529.0003.00

BR0280I BRBACKUP time stamp: 2011-05-29 05.58.38

#FILE..... /oracle/PDR/sapdata4/pdr700_15/pdr700.data15

#SAVED.... 20110529.0003.03

BR0280I BRBACKUP time stamp: 2011-05-29 05.58.59

#FILE..... /oracle/PDR/sapdata4/pdr700_16/pdr700.data16

#SAVED.... 20110529.0003.02

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 5:59:01 AM

Completed OB2BAR Backup: dbpdr:PDR.2 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 05:59:01 Completed OB2BAR Backup: dbpdr:PDR.2 "SAP"

BR0280I BRBACKUP time stamp: 2011-05-29 05.59.08

#FILE..... /oracle/PDR/sapdata1/sysaux_1/sysaux.data1

#SAVED.... 20110529.0003.03

BR0280I BRBACKUP time stamp: 2011-05-29 05.59.09

#FILE..... /oracle/PDR/sapbackup/cntrlPDR.dbf

#SAVED.... 20110529.0003.03

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 5:59:11 AM

Completed OB2BAR Backup: dbpdr:PDR.3 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 05:59:11 Completed OB2BAR Backup: dbpdr:PDR.3 "SAP"

BR0280I BRBACKUP time stamp: 2011-05-29 05.59.13

#FILE..... /oracle/PDR/sapdata1/system_1/system.data1

#SAVED.... 20110529.0003.00

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 5:59:16 AM

Completed OB2BAR Backup: dbpdr:PDR.0 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 05:59:16 Completed OB2BAR Backup: dbpdr:PDR.0 "SAP"

BR0280I BRBACKUP time stamp: 2011-05-29 06.00.11

#FILE..... /oracle/PDR/sapdata3/undo_1/undo.data1

#SAVED.... 20110529.0003.01[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:13 AM Completed OB2BAR Backup: dbpdr:PDR.1 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:13 Completed OB2BAR Backup: dbpdr:PDR.1 "SAP" [Normal] From: OB2BAR_BACKINT@jkeccdb "PDR" Time: 05/29/11 06:00:13Backint exits with the code (0).BR0280I BRBACKUP time stamp: 2011-05-29 06.00.13

BR0232I 168 of 168 files saved by backup utilityBR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2011-05-29 06.00.16BR0317I 'Alter database end backup' successful

BR0280I BRBACKUP time stamp: 2011-05-29 06.00.16BR0340I Switching to next online redo log file for database instance PDR ...BR0321I Switch to next online redo log file for database instance PDR successfulBR0280I BRBACKUP time stamp: 2011-05-29 06.00.16

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of '/usr/sap/PDR/SYS/exe/run/backint -u PDR -f backup -i /oracle/PDR/sapbackup/.befzgygr.lst -t file -c':

[Normal] From: OB2BAR_BACKINT@jkeccdb "PDR" Time: 05/29/11 06:00:16

Backint is started with the following parameters /usr/sap/PDR/SYS/exe/run/backint -u PDR -f backup -i /oracle/PDR/sapbackup/.befzgygr.lst -t file -c.[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:16 AM Starting OB2BAR Backup: dbpdr:PDR.4 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:18 AM

Starting OB2BAR Backup: dbpdr:PDR.5 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:18 AM

Completed OB2BAR Backup: dbpdr:PDR.4 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:20 AM

Starting OB2BAR Backup: dbpdr:PDR.6 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:20 AM

Completed OB2BAR Backup: dbpdr:PDR.5 "SAP"[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:22 AM Starting OB2BAR Backup: dbpdr:PDR.7 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:22 AM

Completed OB2BAR Backup: dbpdr:PDR.6 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:16 Starting OB2BAR Backup: dbpdr:PDR.4 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:18 Starting OB2BAR Backup: dbpdr:PDR.5 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:20 Starting OB2BAR Backup: dbpdr:PDR.6 "SAP"

[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:22 Starting OB2BAR Backup: dbpdr:PDR.7 "SAP" BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24

#PFLOG.... /oracle/PDR/102_64/dbs/initPDR.ora#SAVED.... 20110529.0003.04BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24#PFLOG.... /oracle/PDR/102_64/dbs/spfilePDR.ora

#SAVED.... 20110529.0003.05BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24

#PFLOG.... /oracle/PDR/102_64/dbs/initPDR.sap#SAVED.... 20110529.0003.06BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24#PFLOG.... /oracle/PDR/sapreorg/strucPDR.log

#SAVED.... 20110529.0003.04BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24

#PFLOG.... /oracle/PDR/sapreorg/paramPDR.log#SAVED.... 20110529.0003.05BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24#PFLOG.... /oracle/PDR/sapbackup/backPDR.log

#SAVED.... 20110529.0003.06[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:18 Completed OB2BAR Backup: dbpdr:PDR.4 "SAP" [Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 5/29/2011 6:00:24 AM Completed OB2BAR Backup: dbpdr:PDR.7 "SAP"BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24

#PFLOG.... /oracle/PDR/sapbackup/befzgygr.anf#SAVED.... 20110529.0003.05[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:22 Completed OB2BAR Backup: dbpdr:PDR.6 "SAP" [Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:20 Completed OB2BAR Backup: dbpdr:PDR.5 "SAP" BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24#PFLOG.... /oracle/PDR/sapreorg/spacePDR.log

#SAVED.... 20110529.0003.07[Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR" Time: 05/29/11 06:00:24 Completed OB2BAR Backup: dbpdr:PDR.7 "SAP"

[Normal] From: OB2BAR_BACKINT@jkeccdb "PDR" Time: 05/29/11 06:00:24

Backint exits with the code (0).BR0280I BRBACKUP time stamp: 2011-05-29 06.00.24

BR0232I 8 of 8 files saved by backup utilityBR0230I Backup utility called successfully

BR0056I End of database backup: befzgygr.anf 2011-05-29 06.00.24

BR0280I BRBACKUP time stamp: 2011-05-29 06.00.25

BR0052I BRBACKUP completed successfully[Normal] From: BSM@sanbkp "ONLINE_JKECCDB_PDR" Time: 5/29/2011 5:33:17 AM

OB2BAR application on "dbpdr" disconnected.

[Normal] From: BMA@jkeccdb "HP:Ultrium 3-SCSI_2_jkeccdb" Time: 5/29/2011 6:02:05 AM

/dev/rmt/0mn

Medium header verification completed, 0 errors found[Normal] From: BMA@jkeccdb "HP:Ultrium 3-SCSI_2_jkeccdb" Time: 5/29/2011 6:02:22 AM

By: UMA@sanbkp@Changer0:1:1:0 Unloading medium to slot 28 from device /dev/rmt/0mn[Normal] From: BMA@jkeccdb "HP:Ultrium 3-SCSI_2_jkeccdb" Time: 5/29/2011 6:02:33 AM COMPLETED Media Agent "HP:Ultrium 3-SCSI_2_jkeccdb"

[Normal] From: BSM@sanbkp "ONLINE_JKECCDB_PDR" Time: 5/29/2011 5:35:24 AM

[volker_borowski2]

> [Normal] From: OB2BAR_SAPBACK@jkeccdb "PDR"  Time: 05/29/11 06:00:13 	Completed OB2BAR Backup: dbpdr:PDR.1 "SAP"  [Normal] From: OB2BAR_BACKINT@jkeccdb "PDR"  Time: 05/29/11 06:00:13Backint exits with the code (0).BR0280I BRBACKUP time stamp: 2011-05-29 06.00.13
> BR0232I 168 of 168 files saved by backup utilityBR0230I Backup utility called successfully
> BR0280I BRBACKUP time stamp: 2011-05-29 06.00.16BR0317I 'Alter database end backup' successful
> BR0280I BRBACKUP time stamp: 2011-05-29 06.00.16BR0340I Switching to next online redo log file for database instance PDR ...BR0321I Switch to next online redo log file for database instance PDR successfulBR0280I BRBACKUP time stamp: 2011-05-29 06.00.16

Hi,

this backup is successfull and alters the DB back to "END BACKUP" successfully.

There must be another point of failure!

Any other jobs that do anything else?

Volker

[Former Member]

Hi Ganesh,

Do you use any other 3rd party backup tool?

Check alert_<SID>.log under "/oracle/<SID>/saptrace/background". Additionally, download the latest br*tools (DBATL) and try to perform an online backup again.

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

Thanks for your valuable reply.

We are using HP DP 6.0 software and tape library to take backup.

Regards

Ganesh Datt Tiwari

[Former Member]

Hi Ganseh,

Are you facing with this error at the beginning of the online backup or at the end of the online backup?

If you are facing with this error, another process might be executed "ALTER DATABASE BEGIN BACKUP;" statement on the database, before the online backup. To find out the process, check "alert_<SID>.log" and search for "ALTER DATABASE BEGIN BACKUP" string, on it from down to top. By doing so, you may figure out that what process altered the database state to the backup mode. Please note that you should differentiate executed statements with the statements executed by HP DP. This is because, this statement is executed by HP DP also.

If you are facing with this problem at the end of the online backup, download and patch latest br*tools (DBALT) on your system, as I noted previously.

Actually, in both case I recommend that you download the latest patches, in oder to be updated

Best regards,

Orkun Gedik