BRBACKUP wasn't able to switch requested tablespace in BEGIN/END BACKUP mod

[dan_pfingsten2]

Backups started failing recently (had been working just fine) for production BW database. This is brbackup, Oracle 10.2.0.2 on AIX 5.3 using TSM.

Partway through the backup, it fails with the log messages below.

I verified all tablespaces can be switched in and out of backup mode, and that before the backup all tablespaces are out of backup mode and all tables online.

The datafile indicated was successfully backed up after it was added.

The error does not occur in the same place every time.

I ran the backup during a different time slot but same issue.

Any input would be appreciated.

BR0100E Internal error for '/oracle/PW1/sapdata1/pw1usr_3/pw1usr.data3' at location db_file_switch-16

BR0280I BRCONNECT time stamp: 2007-07-23 12.43.24

BKI0412E: BRBACKUP wasn't able to switch requested tablespace in BEGIN/END BACKUP mode.

BKI0412E: BRBACKUP wasn't able to switch requested tablespace in BEGIN/END BACKUP mode.

BKI9204E: Additional support information: An Exception was thrown at position: esd-portalcommunicator.cpp(177) (tex

t=BKI9217E: Additional support information: An Exception was thrown at position: esd-socket.cpp(380).

).

BKI9203E: Additional support information: An Exception was thrown at position: /lhome/builder/projects/xint/library

/base/esd-countedpointer.hpp(221).

( esd-exception.cpp(112): )

esd-sessionmanager.cpp(545):

esd-sessionmanager.cpp(526):

esd-sessionmanager.cpp(385):

esd-task.cpp(292):

esd-sessionmanager.cpp(347):

esd-datamover.cpp(297):

esd-datamover.cpp(271):

esd-sessionmanager.cpp(545):

esd-sessionmanager.cpp(526):

esd-sessionmanager.cpp(385):

esd-task.cpp(232):

esd-filebackupservice.cpp(68):

esd-service.cpp(214):

esd-thread.cpp(64):

BKI9309E: Operation terminated due to an explicit abort request.

[markus_doehr2 · Accepted solution]

Just a quick shot: do you use the latest BR*tools version?

--

Markus

[dan_pfingsten2 · Accepted solution]

Yes, BRTOOLS 7.00 (11)

[markus_doehr2 · Accepted solution]

The latest BR*TOOLS patchlevel is 27:

DBATL700O10_27-20000979.SAR DBATOOLS Package for Oracle 10g 27

Your version is from 2006-01-11.

Try with the new one, many fixes have been incorporated:

http://service.sap.com/patches

--> SAP NetWeaver

--> SAP NETWEAVER 2004S

--> Entry by Component

--> Application Server ABAP

--> SAP KERNEL 7.00 64-BIT

--> AIX 64bit

--> ORACLE

If the error still persist, I'd open an OSS call on this issue.

--

Markus

[dan_pfingsten2 · Accepted solution]

An online backup with the new brbackup 7.00 (27) worked just fine.

Couldn't re-create the scenario in any of the other 3 BW environments we have.

Strange and a little unsettling that it 'just started happening out of the blue' in a production environment with no changes occuring in the environment.

Thanks for the feedback!

[markus_doehr2 · Accepted solution]

This is really strange...

you use the same BR*TOOLS version on the other three BW servers?

--

Markus

[dan_pfingsten2 · Accepted solution]

Yes, we were using the same 7.0 patch 11 on all BW environments. To be consistent, all the BW's now have the 7.0 patch 27 version. But the situation only occurred in one environment.