Hello Uwe, I tried doing it in several places, not making progress. Getting various errors. Including the following when I put it after db_start:
dbmcli on TEST4>ERR -24988,ERR_SQL: sql error -101,Message not available Can you pretty please review my script and tell me where to insert db_activate with RECOVER option? http://www.IPCoast.com/MaxDB-Restore01.txt Any other things you notice missing / incorrect in my script? I seem to have the worst luck with syntax changes to the restore process. Thank you. Stephen Gutknecht -----Original Message----- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 11:41 PM To: 'Stephen Gutknecht (SAPDB)'; [EMAIL PROTECTED] Subject: AW: MaxDB 7.5.0.5 Restore problems - log file not created Hello Stephen, db_activate without the RECOVER option initializes all defined volumes, loads the system tables and the database is then online and empty. With the RECOVER option the volumes are initialized (created) and a given data backup is restored. In the next step you can restart the database with db_online. In earlier releases this command was divided into two steps but they had always been done in a couple so we stuck them together. (earlier: INIT CONFIG + ACTIVATE or INIT CONFIG + RESTORE DATA) Kind regards, Uwe -----Urspr�ngliche Nachricht----- Von: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 4. Dezember 2003 07:46 An: [EMAIL PROTECTED] Betreff: RE: MaxDB 7.5.0.5 Restore problems - log file not created I notice that dbmcli help shows something of interest on the new db_activate command: db_activate <sysdba>,<pwd> | RECOVER <recoveroptions> Does this hint my script should go ahead and do the db_activate, but use the RECOVER parameter? Stephen Gutknecht -----Original Message----- From: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 3:27 PM To: [EMAIL PROTECTED] Subject: MaxDB 7.5.0.5 Restore problems - log file not created Hi, I got a partially working script to restore my MaxDB 7.5 backup to empty system also running MaxDB 7.5. This is on Windows 2000 or Windows XP. I am doing a database only restore, no database + log. The backup was done with the MIGRATION option. Here is a link to the script I am using for the restore: http://www.IPCoast.com/MaxDB-Restore01.txt The database does restore and starts, with this output: Returncode 0 Date 20031203 Time 00145253 Server --- obscured --- Database MYDB1 Kernel Version Kernel 7.5.0 Build 005-121-054-885 Pages Transferred 1119968 Pages Left 0 Volumes 1 Medianame completeFile Location c:\MaxDB-server1-bk001.data Errortext Label DAT_00042 Is Consistent true First LOG Page 19819896 Last LOG Page DB Stamp 1 Date 20031202 DB Stamp 1 Time 00144916 DB Stamp 2 Date DB Stamp 2 Time Page Count 1119949 Devices Used 1 Database ID --- obscured ---- Max Used Data Page 0 However, the first attempt to cold/warm the database returns: ERR -24895,ERR_SHUTDOWN: shutdown of database occured -71,connection broken The cause (as shown in kernldiag and checking disk) being that the LOG file is not being created. With SAPDB 7.4.x, the empty log file used to be created fine during a restore. Thank you. Stephen Gutknecht -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
