An explanation of how the backup history gets into the Database is in order here.
The backup history is written to a temp file. At the end of the session the temp file is changed to a xxxx.cat file. This file is then written to tape at the end of the session.
At the end of the backup mergecat.exe is spawned and it will merge all the cat files into the Database.
In this case since the session was not finished the temp file was not changed to a cat file and written to tape. That is why the Merge keeps asking for the next sequence number tape.
Try this Registry setting. One thing I do not have ARCserve 9 installed and so the path given might not be ARCserveIT, but it will still be Base\Task
Open regidt32.exe
Go to HKEY_LOCAL_MACHINE on Local Machine
Open it to
HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\ARCserveIT\Base\Task
Highlight Task and select Edit Add Key from the menue bar.
Key Name: Merge
Class: <leave blank>
Hightlight Merge and select Edit Add Value
Value Name: DonotUseCatalogMerge
Data Type: REG_DWORD
click OK
Data: 1 *// 1 = Enabled, 0 = Disabled
This changes the Merge to start at the begining of the session and read the data on tape all the while writting the backup history to the Database, instead of looking for the cat file. Just be sure to disable it after the Merge.