cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Brbackup failing

Go to solution
Former Member

on ‎03-08-2007 1:40 AM

0 Kudos

Hi,

Our backups are failing from last two days.

Bellow are the errors from the backup logs.

<b>Yesterday Backup log</b>

BR301E SQL error 1403 at location BrTspAlter-4

ORA-01403: no data found

BR280I Time stamp 2007-03-07 08.02.05

BR318E 'Alter tablespace PSAPDDICI end backup' failed

BR280I Time stamp 2007-03-07 08.02.05

BR301E SQL error -1142 at location BrTspAlter-3

ORA-01142: cannot end online backup - none of the files are in backup

BR280I Time stamp 2007-03-07 08.02.05

BR318E 'Alter tablespace PSAPDDICI end backup' failed

<b>Today backup log</b>

BR280I Time stamp 2007-03-08 04.10.27

BR301E SQL error 1403 at location BrTspAlter-1

ORA-01403: no data found

BR280I Time stamp 2007-03-08 04.10.27

BR316E 'Alter tablespace PSAPCLUD begin backup' failed

BR280I Time stamp 2007-03-08 04.10.32

BR317I 'Alter tablespace PSAPBTABD end backup' successful

Regards

Pritam

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎03-08-2007 8:23 AM
0 Kudos

Hello Pritam,

Please upgrade you Database toold / BRTOOLS to a higher patch level.

Related Notes:

Note 628589 - BRBACKUP fails with ORA-01403 on position BrTspAlter-4

Note 819860 - Backup with "util_file_online" fails with ORA-01403

Also check:

Note 534765 - db connect fails because of wrong db schema in environment

Regards,

Ammey Kesarkar

Show replies
Show replies
Former Member
‎03-08-2007 8:55 AM
0 Kudos

Hey Thanks Ammey,

I did found that on the oss but how come suddenly i am getting these errors as the backup is running fine for almost a year now. And no one has changed any setting in the system.

Regards

Pritam

Former Member
‎03-08-2007 2:55 PM
0 Kudos

it would be interesting to see which SQL statement triggers this error

do enable sql tracing in brbackup, run the next backup with an added switch '-TRC 2' (see SAP note 29321) and see what is being done here

If I'm not mistaken, brbackup is querying v$datafile in this step

Also, can you include the brbackup version used as well as oracle version?

Former Member
‎03-09-2007 8:56 AM
0 Kudos

Hi,

Was surprised to see that todays backup ran successfully.

Regards

Pritam

Answers (0)

Ask a Question