Restore ok - start DB - failed - Systemcopy

[DieterLorenz]

Hello @all

I should do a system copy from SR1 backup into SR9 DB.

So I restored a SR1 Full Backup into the SR9 Database and restore the incremental - looks fine(is consistend => true). If I turn the SR9 Database into online mode - crashed !

--- Starting GMT 2017-05-02 14:53:48 7.9.08 Build 030-123-252-649
Thread 0x130C Task 204 2017-05-03 07:10:30 AdminMsg 0: 0000 RLG RESTORE LOG CANCEL
Thread 0x130C Task 204 2017-05-03 07:10:30 AdminMsg 0: 0000 RLG RETURNCODE -104;RESTORE LOG CANCEL
Thread 0x130C Task 204 2017-05-03 07:10:30 AdminMsg 0: 590966460015 0000 IC1 CREATE INSTANCE WITH RESTORE DATA FROM '\\SERVER\SQL-Backup\SR1\DB\SR1\DATA\datasave-SR1.mdb' FILE BLOCKSIZE 8 MEDIANAME 'RESTORE_FULL_SR1'
Thread 0x130C Task 204 2017-05-03 09:54:28 AdminMsg 0: 59098CB40027 0000 IC1 RETURNCODE 0;CREATE INSTANCE WITH RESTORE DATA FROM
Thread 0x130C Task 204 2017-05-03 09:57:23 AdminMsg 0: 59098D63002B 0000 RPG RESTORE PAGES FROM '\\SERVER\SQL-Backup\SR1\DB\SR1\DATA\datasave-SR1-inc.mdb' FILE BLOCKSIZE 8 MEDIANAME 'RESTORE_INC'
Thread 0x130C Task 204 2017-05-03 09:59:19 AdminMsg 0: 59098DD7002E 0000 RPG RETURNCODE 0;RESTORE PAGES FROM '\\SERVER\SQL-Backup\SR1\DB\SR1\DATA\datasave-SR1-inc.mdb' FILE
Thread 0x130C Task 204 2017-05-03 10:09:13 AdminMsg 0: 59099029003A 0000 RST RESTART
Thread 0x130C Task 204 2017-05-03 10:09:59 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=976
2017-05-03 10:09:59 KernelComm 6: Internal errorcode, Error code 3320 "duplicate_invkey"
Thread 0x10F0 Task - 2017-05-03 10:09:59 ERR Messages 7: Begin of dump of registered messages,_FILE=Msg_Registry.cpp,_LINE=507
Thread 0x10F0 Task - 2017-05-03 10:09:59 KernelComm 6: Internal errorcode, Error code 3320 "duplicate_invkey"
Thread 0x10F0 Task - 2017-05-03 10:09:59 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=976
2017-05-03 10:09:59 KernelComm 6: Internal errorcode, Error code 3320 "duplicate_invkey"
Thread 0x10F0 Task - 2017-05-03 10:09:59 ERR Messages 8: End of the message list registry dump,_FILE=Msg_Registry.cpp,_LINE=544
Thread 0x10F0 Task - 2017-05-03 10:10:03 MsgOutput 28: ___ Stopping GMT 2017-05-03 08:10:03 7.9.08 Build 030-123-252-649

Please help !

[DieterLorenz]

Yes I fixed the DB Install User and DB Restore User - it must be the same. Also I fixed the superdba and control user with the permissions.

[Nicolas]

Hello,

Could you check note 2233572 - Exchange the names of the DBA and DBM users ? Are the names of the DBA and DBM users different between the source and target databases ?

Best regads,

Nicolas