Greetings, I am attempting to migrate my SAPDB 7.3.0.25 database to MaxDB 7.5.014.
On the 7.3 server I execute: dbmcli -d SID -u dbm,pass db_offline db_cold medium_put MigrationDataBackup\mdb1 /usr/local/sapdb/dbs/mdb1 file data 0 8 yes medium_put MigrationDataBackup\mdb2 /usr/local/sapdb/dbs/mdb2 file data 0 8 yes util_execute migrate utiL_connect backup_start MigrationDataBackup util_release db_warm exit I copy the two database files to the MaxDB server and execute: dbmcli -d SID -u dbm,pass db_offline db_admin medium_put MigrationDataBackup\mdb1 /usr/local/sapdb/backups/mdb1 file data 0 8 yes medium_put MigrationDataBackup\mdb2 /usr/local/sapdb/backups/mdb2 file data 0 8 yes util_connect db_activate recover MigrationDataBackup This gives me this output: OK Returncode -8020 Date 20040709 Time 00065738 Server pcqa1 Database QA Kernel Version Kernel 7.3.0 Build 025-000-085-912 Pages Transferred 227888 Pages Left 198 Volumes 2 Medianame MigrationDataBackup Location /usr/local/sapdb/backups/mdb2 Errortext Label DAT_00917 Is Consistent true First LOG Page 1027725 Last LOG Page 2147483647 DB Stamp 1 Date 20040708 DB Stamp 1 Time 00135243 DB Stamp 2 Date DB Stamp 2 Time Page Count 228086 Devices Used 2 Database ID pcqa1:QA_20040702_031611 Max Used Data Page 824791 and, based on the research I've done, I do a recover_ignore and get this: OK Returncode 0 Date 20040709 Time 00065738 Server pcqa1 Database QA Kernel Version Kernel 7.3.0 Build 025-000-085-912 Pages Transferred 228112 Pages Left 0 Volumes 2 Medianame MigrationDataBackup Location /usr/local/sapdb/backups/mdb1 Errortext Label DAT_00917 Is Consistent true First LOG Page 1027725 Last LOG Page 2147483647 DB Stamp 1 Date 20040708 DB Stamp 1 Time 00135243 DB Stamp 2 Date DB Stamp 2 Time Page Count 228086 Devices Used 2 Database ID pcqa1:QA_20040702_031611 Max Used Data Page 824791 BUT, when I db_warm I get this: ERR -24895,ERR_SHUTDOWN: shutdown of database occured -71,connection broken server state 6 In the knldiag I receive this: 2004-07-09 07:23:45 9136 ERR 53250 B*TREE BAD INDEX 12044 (ROOT) 2004-07-09 07:23:45 9136 ERR 53250 B*TREE BAD INDEX 92756 (ROOT) 2004-07-09 07:23:45 9136 ERR 53250 B*TREE BAD INDEX 149160 (ROOT) 2004-07-09 07:23:45 9136 ERR 53250 B*TREE BAD INDEX 1137 (ROOT) 2004-07-09 07:23:45 9136 ERR 51381 MIGRAT migrating failed with error -7055 2004-07-09 07:23:45 9136 37 Admin Kernel state: 'OFFLINE' reached 2004-07-09 07:23:45 9136 12696 DBSTATE Change DbState to 'SHUTDOWN'(25) So I looked up error -7055 and it is in relation to indexes and says that no user action is required. Any thoughts? Thanks! -knme -- ------ Kenneth N. M. Eisner Senior Software Engineer Bricsnet The CRE Automation Company www.bricsnet.com w: 603.559.2528 f: 603.436.5760
signature.asc
Description: This is a digitally signed message part
