Hello David, Thanks for sending me the modification time of the log backups /filer/vol1/MaxDBarch/log.001 and /filer/vol1/MaxDBarch/log.002.
>Log.001: Tue Sep 6 15:37:29 2005 >Log.002: Tue Sep 6 15:43:25 2005 archive_stage is not working because the log backups in question have a modification time outside the time interval stated for those backups in the backup history. dbm.knl: ...|LOG_000000001|...|2005-09-06 15:46:51|2005-09-06 15:46:51|... ...|LOG_000000002|...|2005-09-06 15:52:48|2005-09-06 15:52:48|... There seems to be a 9 minutes and 21 or 22 seconds time difference between the machine time and the file system time. Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: David Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, September 08, 2005 10:02 AM To: Heinrich, Tilo; maxdb@lists.mysql.com Subject: RE: Can't get archive_stage to work I couldn't post the files to the mailing list - the mailing list daemon rejected them, too big. I can post them in (Win)zipped form if needed. I've been doing a bit more research. If I explicitly specify the logfile numbers, it works: dbmcli> archive_stage BACKlog AutoArch FNL 1 I guess in this case it doesn't go looking in the backup history. -----Original Message----- From: Heinrich, Tilo [mailto:[EMAIL PROTECTED] Sent: 06 September 2005 17:24 To: maxdb@lists.mysql.com Subject: RE: Can't get archive_stage to work Hello David, I would say you did nothing wrong. Do you mind sending the files dbm.prt, dbm.knl, dbm.mdf and dbm.ebf (if existing) to me or to the mailing list? Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: David Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 06, 2005 6:02 PM To: maxdb@lists.mysql.com Subject: Can't get archive_stage to work Hi, I'm trying to develop an implementation of the backint for MaxDB interface. I can't get the archive_stage command to work. This is MaxDB 7.6 on Solaris 10. Any help would be much appreciated. - I've created a backup medium for automatic logging. Here is the definition from dbm.mmm [AutoArch] LOCATION=/filer/vol1/MaxDBarch/log TYPE=FILE SAVETYPE=AUTO SIZE=0 BLOCKSIZE=8 OVERWRITE=NO AUTOLOADER=NO OSCOMMAND= BACKUPTOOL=NONE CREATED=20050811151112 MODIFIED=20050811151112 - I've enabled automatic logging, and I have a couple of logfiles in the staging area (log.001 and log.002). - I've created an external backup medium: [BACKlog] LOCATION=/tmp/maxdb/datapipe0 TYPE=PIPE SAVETYPE=LOG SIZE=0 BLOCKSIZE=8 OVERWRITE=NO AUTOLOADER=NO OSCOMMAND= BACKUPTOOL=BACK CREATED=20050812152744 MODIFIED=20050812152744 Now I issue the command: archive_stage BACKlog AutoArch NOVERIFY KEEP And I get this in dbm.ebl: 2005-09-06 16:04:27 Preparing stage backup. Reading backup histories. Finished reading backup histories successfully. Determining stage files in directory '/filer/vol1/MaxDBarch'. Found directory entry '.'. It is not a stage file. Found directory entry '..'. It is not a stage file. Found directory entry 'log.001'. It could be a stage file. Found directory entry 'log.002'. It could be a stage file. Stage file /filer/vol1/MaxDBarch/log.001 has label LOG_000000001 and the backup started at 2005-09-06 15:46:51. Stage file /filer/vol1/MaxDBarch/log.002 has label LOG_000000002 and the backup started at 2005-09-06 15:52:48. Found 2 stage files. Have encountered error -24925: Could not find all the needed data in the backup history files (e.g. for '/filer/vol1/MaxDBarch/log.001'). Constructed the following reply: ERR -24925,ERR_PREPARE: preparation of backup operation failed Could not find all the needed data in the backup history files (e.g. for '/filer/vol1/MaxDBarch/log.001'). Finished determination of stage files unsuccessfully. Prepare failed. What am I doing wrong? **** IMPORTANT INFORMATION & CONFIDENTIALITY NOTICE **** David Lane Tel: +44 (0)1372 221958 Web: www.BridgeHeadSoftware.com <http://www.bridgeheadsoftware.com/> The information in this Email is confidential and may be legally privileged. It is intended solely for the named recipient. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, please note that any use, disclosure, copying, distribution of this Email or any action taken or omitted to be taken in reliance on it is prohibited. If you are not the intended recipient, please inform us by Email to the sending address or by telephoning the number above and then delete the Email and any copies of it. This Email is from BridgeHead Software, a software development company, whose registered offices are in the UK, USA and Germany. _____________________________________________________________________ BridgeHead Software is pleased to confirm this e-mail has been scanned for viruses by MessageLabs. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _____________________________________________________________________ BridgeHead Software is pleased to confirm this e-mail has been scanned for viruses by MessageLabs. -- 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]
