Skip to Content
Former Member
Apr 04, 2007 at 03:27 PM

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


Running R/3 6.20/0019 with Oracle 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.