----- Original Message ----- From: "Brunzema, Martin" <[EMAIL PROTECTED]> To: "'Denis Minnikhanov'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 05, 2004 1:22 PM Subject: RE: SAP DB 7.4 backup and restore
> > > > -----Original Message----- > > From: Denis Minnikhanov [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, February 04, 2004 4:31 PM > > To: [EMAIL PROTECTED] > > Subject: SAP DB 7.4 backup and restore > > > > > > Hi SAP DB developers! > > > > History: > > SAP DB v. 7.4.3.31(but the same issue with v.v. > > 7.4.3.10/7.4.3.17/7.4.3.27) > > > > Log Mode: Autosave is ON. > > > > Medium for Backup created as: > > "medium_put data %DATA%\%SID%\DATA\datasave FILE DATA 0 8 YES" > > "medium_put auto %DATA%\%SID%\LOG\autosave FILE AUTO" > > > > Problem: > > How to restore the DB`s state completely from the backup > > within the C++ programm (i.e. not using the DBMGUI)? > > > > For example I performed the Complete Data Backup at > > 01.01.2004. After that some important data were deleted... At > > 02.01.2004 I need to restore DB`s state for the last Complete > > Data Backup state. How can I do it? > > > > 1. "recover_start data DATA" failed: > > - "recover_start data DATA UNTIL <date> <time>" returnes error; > > - "recover_start auto LOG UNTIL <date> <time>" doesn`t > > work because the absence of the "Log Backup". 2. With DBMGUI > > recovery does succeed but after that DB is on the "Log Mode > > -Autosave is OFF" state and failed to turn to the "Log Mode > > -Autosave is ON". It is possible to turn the DB to the "Log > > Mode -Autosave is ON" but only after once more Complete Data > > Backup. Is that normal? Are my actions wrong? > > Hi, > > these steps should (in principle) work: > > - restore your data-backup > - check the result of > db_restartinfo > - if the database is restartable then > db_online -u <yyyymmdd> <hhmmss> > else > recover your log with > recover_start ..... UNTIL <yyyymmdd> <hhmmss> > > - now the database should be online, but the backup- > history is interrupted. You have to create a complete > before you can switch on autosave again. > > regards, martin > > Hi! Tnanks. And what to do if: data volume: param_addvolume 1 DATA DISKD0001 F 51200 param_addvolume 2 DATA DISKD0002 F 51200 param_addvolume 3 DATA DISKD0003 F 51200 param_addvolume 4 DATA DISKD0004 F 51200 log volume: param_addvolume 1 LOG DISKL001 F 20480 param_addvolume 2 LOG DISKL002 F 20480 param_addvolume 3 LOG DISKL003 F 20480 param_addvolume 4 LOG DISKL004 F 20480 medium: medium_put auto autosave FILE AUTO medium_put data datasave FILE DATA 0 8 YES" medium_put data1 datasave1 FILE DATA 0 8" medium_put data2 datasave2 FILE DATA 0 8" LogMode Autosave is ON. And I performed Complete Data Backup at different dates: "backup_start data1 DATA" - 2004/01/01 12:00:00 "backup_start data2 DATA" - 2004/01/02 12:00:00 And then I recover the "2004/01/02 12:00:00" state: "recover_start data2 DATA" - OK "db_restartinfo" - Restartable 1(database restartable) "db_online -u 20040102 120000" - OK After that I have to do Complete Data Backup to switch DB to "LogMode Autosave is ON" state (because the backup history is interrupted) "backup_start data DATA" - OK Now I want to restore "2004/01/01 12:00:00" state: "recover_start data1 DATA" - OK "db_restartinfo" - Restartable 0(database not restartable) I can`t recover my log with "recover_start auto LOG UNTIL 20040101 120000" because I don`t have log backup. Can I restore the arbitrary date DB state? If it`s impossible to use the "dbmcli" can the "loadercli" help me? I used to solve the problem through the "loadercli": - unloading: "tableextract ALL DATA OUTSTREAM backup_file PAGES" - success - loading: "tableload ALL DATA INSTREAM backup_file0001 PAGES" - error // E -25602: Error restoring table A; table is not empty // E -25801: Internal error [vls28_TLoad.cpp, 2292, -25602]; contact technical support Help documentation says: "The target tables must be empty. If the tables are not empty, the Loader attempts to delete the contents of the tables." Table A doesn`t linked with any other table. Cleaning the tables by hand is not right because it`s impossible to perform RollBack to restore to the previous state. And it`s quite imagineable situation that loading (filling) the tables after cleaning is failed and therefore DB is empty. Is there way to solve problem? Is there any way to restore the state of sequences and columns defined as "DEFAULT SERIAL(n)"? With Best Regards, Denis. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
