Online Backup error

[Former Member]

Dear all

during the Online Backup , i got error below error

1 , TDP is waiting so i kill the bacjkup process ,

so again i tried to take the backup , i got error

============================================

2, BR0051I BRBACKUP 7.00 (34)

BR0055I Start of database backup: becshjdg.anf 2010-03-05 14.47.04

BR0484I BRBACKUP log file: /oracle/IRP/sapbackup/becshjdg.anf

BR0049W Last BRBACKUP run was probably killed

BR0252E Function fopen() failed for '/oracle/IRP/sapbackup/.lock.brb' at locatio

n brb_run_check-5

BR0253E errno 13: Permission denied

BR0073E Setting of BRBACKUP lock failed

---> i had removed >.lock.brb from oracle/IRP/sapbackup.

===========================================================

After i tried to take a backup , i got the below error ,

BR0252E Function fopen() failed for '/oracle/IRP/sapbackup/backIRP.log' at locat

ion main-11

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/IRP/sapbackup/backIRP.log failed

BR0056I End of database backup: becshjjq.anf 2010-03-05 14.49.50

BR0280I BRBACKUP time stamp: 2010-03-05 14.49.50

BR0054I BRBACKUP terminated with errors

so i have given Permission to backIRP.log.

===================================================

after i had tried to take the Backup i got the below error

BR0280I BRCONNECT time stamp: 2010-03-05 14.58.47

#BEGIN /oracle/IRP/sapdata3/undo_1/undo.data1

BR0280I BRCONNECT time stamp: 2010-03-05 14.58.47

BR0345E Error in backup utility while switching the status of file /oracle/IRP/s

apdata3/undo_1/undo.data1

BR0280I BRCONNECT time stamp: 2010-03-05 14.58.47

BKI0412E: BRBACKUP wasn't able to switch requested tablespace in BEGIN/END BACKU

P mode.

BKI0412E: BRBACKUP wasn't able to switch requested tablespace in BEGIN/END BACKU

P mode.

BKI9203E: Additional support information: An exception was thrown at position: /

home/builder/autobuild/TSM_mySAP_BUILD/xint/library/base/esd-countedpointer.hpp(

221).

( esd-exception.cpp(113): )

esd-sessionmanager.cpp(548):

esd-sessionmanager.cpp(529):

esd-sessionmanager.cpp(388):

esd-task.cpp(292):

esd-sessionmanager.cpp(350):

esd-datamover.cpp(300):

esd-datamover.cpp(280):

backint.cpp(156):

BKI9309E: Operation terminated due to an explicit abort request.

BKI9300E: Additional support information: Aborting 'send' operation. See previou

s error.

BKI0405I: TDP waited 4 sec. for BRBACKUP in util_file_online communication.

BKI0020I: End of program at: Fri Mar 5 15:14:44 IST 2010 .

BKI0021I: Elapsed time: 16 min 15 sec .

BKI0024I: Return code is: 2.

BR0280I BRBACKUP time stamp: 2010-03-05 15.14.44

BR0279E Return code from '/usr/sap/IRP/SYS/exe/run/backint -u IRP -f backup -i /

oracle/IRP/sapbackup/.becshkdo.lst -t file_online -p /oracle/IRP/102_64/dbs/init

IRPdaily.utl -c': 2

BR0232E 0 of 42 files saved by backup utility

BR0280I BRBACKUP time stamp: 2010-03-05 15.14.44

BR0231E Backup utility call failed

BR0278I Command output of '/usr/sap/IRP/SYS/exe/run/brconnect':

BR0801I BRCONNECT 7.00 (34)

PID=303230

BR0280I BRCONNECT time stamp: 2010-03-05 14.58.47

BR0345E Error in backup utility while switching the status of file /oracle/IRP/s

apdata3/undo_1/undo.data1

BR0280I BRCONNECT time stamp: 2010-03-05 14.58.47

#ERROR

BR0280I BRCONNECT time stamp: 2010-03-05 15.14.45

#SIGNAL CAUGHT: 15

#INBACKUP PSAPSR3700

BR0074W BRCONNECT call failed

BR0280I BRBACKUP time stamp: 2010-03-05 15.14.46

BR0317I 'Alter tablespace PSAPSR3700 end backup' successful

BR0056I End of database backup: becshkdo.anf 2010-03-05 15.14.44

BR0280I BRBACKUP time stamp: 2010-03-05 15.14.46

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2010-03-05 15.14.46

BR0291I BRARCHIVE will be started with options '-U -d util_file -p initIRPdaily.

sap -cds c'

BR0280I BRBACKUP time stamp: 2010-03-05 15.14.46

BR0292I Execution of BRARCHIVE finished with return code 3

PRODORADB:orairp 3>

Kindly su

[Former Member · Accepted solution]

Hi,

Maybe with the initial trouble you had with the backups one or more data files are left in backup mode. Check the following:

(as ora<sid> or <sid>adm)
sqlplus "/ as sysdba"
select file#,status from v$backup;

If any files are listed with status ACTIVE, then check which tablespaces are involved:

select distinct tablespace_name
from dba_data_files df, v$backup bk
where df.file_id = bk.file#
and bk.status <> 'NOT ACTIVE';

For all tablespaces misted by this last command, issue:

alter tablespace <tblspace> end backup;

Regards,

Mark

[Former Member · Accepted solution]

Hi mark

i had checked (as ora<sid> or <sid>adm)

sqlplus "/ as sysdba"

select file#,status from v$backup;

its shows all files are NOT ACTIVE.

kindly suggest me

[Former Member · Accepted solution]

Dear Mark,

kindly check the below output after executing the command

SQL> select file#,status from v$backup;

FILE# STATUS

-

---

-

---

1 NOT ACTIVE

2 NOT ACTIVE

3 NOT ACTIVE

4 NOT ACTIVE

5 NOT ACTIVE

6 NOT ACTIVE

7 NOT ACTIVE

8 NOT ACTIVE

9 NOT ACTIVE

10 NOT ACTIVE

11 NOT ACTIVE

FILE# STATUS

-

---

-

---

12 NOT ACTIVE

13 NOT ACTIVE

14 NOT ACTIVE

15 NOT ACTIVE

16 NOT ACTIVE

17 NOT ACTIVE

18 NOT ACTIVE

19 NOT ACTIVE

20 NOT ACTIVE

21 NOT ACTIVE

22 NOT ACTIVE

FILE# STATUS

-

---

-

---

23 NOT ACTIVE

24 NOT ACTIVE

25 NOT ACTIVE

26 NOT ACTIVE

27 NOT ACTIVE

28 NOT ACTIVE

29 NOT ACTIVE

30 NOT ACTIVE

31 NOT ACTIVE

32 NOT ACTIVE

33 NOT ACTIVE

FILE# STATUS

-

---

-

---

34 NOT ACTIVE

35 NOT ACTIVE

36 NOT ACTIVE

37 NOT ACTIVE

38 NOT ACTIVE

39 NOT ACTIVE

40 NOT ACTIVE

41 NOT ACTIVE

41 rows selected.

kindly suggest

[volker_borowski2 · Accepted solution]

Hi,

ok, now I see you have a sperate Thread for the Online backup

So I guess your Mount Options are OK since your backup did run 3 days ago.

just try to set the Backup mode manually

sqlplus / as sysdba

alter tablespace PSAPUNDO begin backup;

alter tablespace PSAPUNDO end backup;

alter tablespace SYSTEM begin backup;

alter tablespace SYSTEM end backup;

Just to see if this gives any errors.

And please do the same select against v$datafile

select file#,status from v$datafile;

Best regards

Volker

[ashish_mishra2]

Hi Sateesh,

This problem is just because of incorrect backint and backfm file's permission.

1: Go to your kernel directory, where backint and backfm softlinks will be existing.

2: From root user, go to that location,... where backint and backfm files are physically present.

Generally default location is /usr/tivoli/tsm/tdp_r3/ora64

3: CHANGE THE PERMISSION OF BACKINT AND BACKFM to 4775 from root user

1. chmod 4775 backint

2. chmod 4775 backfm

4: Ownership should be root:system only.

Now trigger backup from DB13. it will work.

Also please close the thread if your problem has been resolved.

Cheers !!!

Ashish

[Former Member]

Dear all,

thanks for your valuable inputs . now issue has been resolved after BrtoolsUpgrade .

Regards

[Former Member]

BR0231E Backup utility call failed

Issue seems with your backup utility, check whether you are able to connect to DB or not?

And update your configuration in backup tool(user credentials etc) and reschedule your backup.

Regards,

Nick Loy

[Former Member]

Hi Nick Loy,

last week its self i didnt get any Backup issue and the Past 3 days i am struggling to take the Backups .

how to check whether you are able to connect to DB or not

kindly suggest

[Former Member]

Hi Nick Loy,

last week its self i didnt get any Backup issue and the Past 3 days i am struggling to take the Backups .

how to check whether i can able to connect to DB or not ?

any other things i need to check regarding this issue

And i have not done any configuration in backup tool

kindly suggest

[Former Member]

Hi,

Have you the correct permissions on the directories for ora<sid> ?

Mark

[Former Member]

Hi ,

last 3 days only i am getting the Backup error , and i didnt change any permissions on the directories for ora<sid>.

could u suggest what are the Permission should be the orasid directory .

kindly suggest and provide any note regarding permissions on the ora<sid>.

Regards

[Former Member]

Hi,

What has changed in the last 3 days in your environment ?

Mark

[Former Member]

Dear Mark,

i didnt change my environment past 3 days.

any thing i need to check.

kindly suggest

Regards