SQL errors 1405 with SAP/Oracle agent

[Frenchy_Big_Blu]

Hello,

We have migrated a SAP 4.7 installation with oracle 9.2 to new servers and migrated Oracle to version 10.2.

Installed a new Netbackup infrastructure 6.5.2 with Oracle/SAP agent on SAP servers.

SAP/oracle run fine, offline and online backups run fine with the agent, but archive logs backup fails. The brarchive command issued by the netbackup agent seems fine, but then brarchive generates thousands of lines of errors with ora-1405 errors like this:

make_info                      NTAMD64 OCI_10201_SHARE Aug 22 2006
command_line                   F:\usr\sap\TFR\sys\exe\run\brarchive -u / -c -d util_file -sd
BR0280I BRARCHIVE time stamp: 2008-10-23 11.32.32
BR0301W SQL error -1405 at location BrArchOrigGet-1, SQL statement:
'SELECT MAX(RECID) FROM V$ARCHIVED_LOG WHERE THREAD# = 1 AND SEQUENCE# = 98647 AND DEST_ID = 1 AND ARCHIVED = 'YES''
ORA-01405: fetched column value is NULL
BR0280I BRARCHIVE time stamp: 2008-10-23 11.32.32
BR0301W SQL error -1405 at location BrArchOrigGet-1, SQL statement:
'SELECT MAX(RECID) FROM V$ARCHIVED_LOG WHERE THREAD# = 1 AND SEQUENCE# = 98648 AND DEST_ID = 1 AND ARCHIVED = 'YES''

I tried a manual archive on disk with brtools, it works fine.

Strange. Any idea?

Thanks.

[Frenchy_Big_Blu]

Answering to myself after further investigation. Renamed the archTFR.log file to archTFR.log.bak and now everything works fine and a new archTFR.log file has been started. On the previous servers  backint was also used but with backup exec not netbackup, I suspect something confused netbackup in this file (which still contained old entries from 2007).