Brtools, PIT recovery fails after roll forward, BR0301E SQL error -1722 at

[Former Member]

Running R/3 6.20/0019 with Oracle 9.2.0.8 on AIX 5.3

Brtools to restore and recover to point in time, this rolls through 300+ archive logs, and a datafile was added to an index tablespace after the backup, but this appears to be delt with successfully when applying the logs.

when I try to open the database through brtools I get the error:

BR0280I BRRECOVER time stamp: 2007-03-26 11.57.22

BR0595I Selecting indexes with NOLOGGING created during or after the selected backup bduuxcqq.anf 2007-03-14 20.00.00 ...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRRECOVER time stamp: 2007-03-26 11.57.28

BR0301E SQL error -1722 at location BrIndNologGet-8

ORA-01722: invalid number

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

I can open the database from SQLPLUS, but Brtools fails.

Thank you.

[Former Member]

Randy,

I too would start with Eric's suggestion. Get to the latest BRTOOL set. Looks like BRRECOVER is trying to set a alpha character into what is susposed to be a numeric field. That's definatly an odd one.

What version of BRTOOLs are you using?

-TIm

[Former Member]

We are currently using brtools 6.40 (36)

[Former Member]

Randy,

Try going to patch level 41/42 for starters.

-Tim

[Former Member]

Installed brtools 640 patch level 42

Re-ran the restore, all successful.

Still seeing the error:

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRRECOVER time stamp: 2007-04-10 11.26.29

BR0301E SQL error -1722 at location BrIndNologGet-8

ORA-01722: invalid number

No errors show up in the database alert log.

[Former Member]

Randy,

This sounds like an issue with the BRTOOLs then. 1722 is a rare error where the SQL statement attempts to convert a string into a number - like a date in this instance.

You may need to open a ticket with SAP Support and have them look at the issue, as you may need a fix for the toolset itself.

Sorry I could not be of more assisatance Randy.

-Tim

[former_member204746]

try getting latest BRTOOLS from SAPNET.