> -----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
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
