Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Bad Restore?

Bad Restore?

2007-02-27       - By Chris Barlow

 Back
Reply:     1     2     3  

Hi,

           I'm attempting to refresh an SAP LiveCache system from Prod
to Dev.  I have made a full backup of the production DB and I've copied
it to Q.  I'm using MaxDB 7.5.0.35 on Windows 2003 64 Bit.  I'm trying
to run through the installation wizard, pointing to the Prod backup
(which I've copied to Q) changing the work directory accordingly as well
as the data and log file locations.  When it completes I receive a
-24895 shutdown of database occurred [db_online -f]; -71, connection
broken.  When I look in the data and log directories I see the data
files were recovered, but there are no log files?  Obviously this is why
it won't start, but I cannot figure out why the log files won't restore.
I verified the backup does not require logs as it was a complete backup.
I tried to be clever (and failed) by copying log files into the
directory from just doing a restore configuration, but I get
DBIdentifier of DataVolume xxxx and yyyy does not match.



I'm obviously doing something wrong, either the backups are all bad
(I've tried different ones) or I'm restoring incorrectly.  I've tried
db_activate, which let me bring it back online, but all the data was
gone.



Can someone please guild me in the right direction or give me some tips?



Thanks



Chris