Hello David, Are you using Backint for Oracle or Backint for MaxDB?
Have you set the option ORIGINAL_RUNDIRECTORY as described in http://dev.mysql.com/doc/maxdb/en/55/a81d36451f11d5992400508b6b8b11/fram eset.htm ? If you use Backint for MaxDB, have you copied the file configured as "HISTORY FILE: " (http://dev.mysql.com/doc/maxdb/en/91/24b97d483411d5992500508b6b8b11/fra meset.htm) from your original server to the new one. Do you know the DBM-Command "backup_ext_ids_get <medium> [<database_name>] [<database_server>]", that can be used to inquire the backup ID's of backups of other databases? Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: David Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 17, 2005 9:46 AM To: Kevin Wilson; Brunzema, Martin; maxdb@lists.mysql.com Subject: RE: Restore database to another server Thanks to all who have replied. I've made some progress, but I probably should have mentioned that the backups were done with the backint interface - using an external backup tool. I've been bumbling my way forward, and this is what *seems* to work. Can anyone tell me, is this really what's required, or am I making life difficult for myself: 1. Create the instance (call it RECOVERY) for recovery 2. Set BACKINT and PARAMETERFILE in the BSI_ENV file of the recovery instance, so it knows how to find backint If I start the recovery at this point, MaxDB invokes backint with this input: #NULL /var/opt/sdb/data/wrk/RECOVERY/dbm.ebf #NULL /var/opt/sdb/data/wrk/RECOVERY/dbm.knl In other words, it has noticed that RECOVERY has no backup history, and is trying to restore it. So: 3. Copy dbm.ebf and dbm.knl from the original instance to RECOVERY's rundirectory 4. Edit dbm.ebf, replacing the original database name with RECOVERY in all EBIDs 5. Create a backup medium with the same name as used in the original backup, because that is what is in dbm.ebf Now the recovery can go ahead. -----Original Message----- From: Kevin Wilson [mailto:[EMAIL PROTECTED] Sent: 16 August 2005 15:11 To: 'Brunzema, Martin'; David Lane; maxdb@lists.mysql.com Subject: RE: Restore database to another server search this list for my email about migrations (subject = 7.3 to 7.5 [NON-PARALLEL] Migration Explained (HOWTO)). It outlines the steps to do what you want. You won't need the first part just the second since you are already in a version >= 7.5 -----Original Message----- From: Brunzema, Martin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 7:35 AM To: David Lane; maxdb@lists.mysql.com Subject: RE: Restore database to another server > -----Original Message----- > From: David Lane [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 16, 2005 12:04 PM > To: maxdb@lists.mysql.com > Subject: Restore database to another server > > I need to restore a database to another server - same version of MaxDB > (7.6), same O/S (Solaris). The original server is lost. Does anyone > have information on how to do this? From the documentation it looks > like I can use a backup of the original database, but I'm not clear > exactly what parameters I need to use, and what commands. Or can I use > the DBMGUI? Hi Dave, for the dbmcli-commands have a look at http://sapdb.2scale.net/moin.cgi/Backup_2fRecovery If there are any errors in the wiki, please correct them. Kind regards, Martin -- 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]
