Hello Joerg, you must delete you logvolume with "db_execute clear log" then you can restart with your current data volume.
Kind regards Uwe -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Dienstag, 7. März 2006 10:12 To: Strahl, Torsten Cc: maxdb@lists.mysql.com Subject: AW: Restore only with the datafile Hello Torsten, i don't need the recover to the point of failure. So i have restore my datafile: dbmcli on t81>db_restartinfo OK Used LOG Page 382973 First LOG Page 0 Restartable 0 Id Restart Record affhr174:T81_20051206_164747 Id LOG Info affhr174:T81_20060303_083649 Consistent 1 Log Volume Enabled 1 Log Auto Overwrite 0 Master Servernode AFFHR174 Converter Version 19150 Oldest Compatible Version 7.5.00.31 What i have to do now? Kind Regards, Joerg -----Ursprüngliche Nachricht----- Von: Strahl, Torsten [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 3. März 2006 17:26 An: Wenzel, Joerg Cc: maxdb@lists.mysql.com Betreff: AW: Restore only with the datafile Hello Joerg, so far so good. - set database to state admin - execute db_restartinfo in dbmcli and take a look at the Value of "Used LOG Page" At least you need a log backup which contains this log pageNo/Sequence. If you have no log backup which fits into this number range you will not be able to recover your database to the point of failure - set database state to offline - define a medium for your log backups and check with medium_labeloffline for the first log backup you need ->"First LOG Page/Fast LOG Page" - use DBMGUI in particular RecoveryWizard to start log recovery Kind Regards, Torsten -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 3. März 2006 15:19 An: Hempelmann, Henrik; maxdb@lists.mysql.com Betreff: AW: Restore only with the datafile Hello Henrik, so i've got one copie of the datafile and the AutoLogBackup files, no backup. I mean to restore so: - start the database in admin mode - initialize the database whith dummy Backup ( stop with errors; never mind ) - set the database offline - move my copie about initialized datafile But what is the next step? Mit freundlichen Grüßen - Best regards Jörg Wenzel -----Ursprüngliche Nachricht----- Von: Henrik Hempelmann [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 3. März 2006 14:04 An: maxdb@lists.mysql.com Betreff: Re: Restore only with the datafile [EMAIL PROTECTED] wrote: > Can i restore if i've got only the datafile? > You mean there is no backup and the logvolumes are lost? Unfortunately there is no direct way to recreate an empty log and restart to the last successful savepoint. But you can recover the database from a backup, so you have to create a backup from your datafile: - start the database in admin mode - make a 'full' backup of your database - initialize the database using the backup -> db_activate restore aka "Recovery with Initialization" Henrik -- 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]
