Hi David, from release 7.4 on the Idenifier is created at the time the first databackup has been made successfully (i.e. when the state backuphistorylost is resetted).
If you recover your data from database A on datbase B then you have to clear the logvolume somehow. Otherwise you wouldn't get the database recovered/restarted. The clear log interrupts the backup-history. This forces you to create a databackup after sucessfull recovery and therefor to get a new databaseidentifier. The reason for this behaviour is to ensure that logbackups can only be recovered on that database that produced this logbackup. If no new databaseidentifier would be generated, then you could try to restore newly made logbackups from your recovered instance on the original database. To read the database-identifier of data- and logvolume use the dbmcli-command db_restartinfo. The database-identifier of backups (both data and log) can be read by using medium_label or mediumlabeloffline (the latter one doesn't need the databasekernel) Kind regards, Martin -----Original Message----- From: David Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 11:57 AM To: Brunzema, Martin; maxdb@lists.mysql.com Subject: RE: Does a MaxDB instance have a unique identifier? Martin, Thanks for the reply. A few more questions: - At what point in the first backup is the DBIdentifier created? The reason I ask is that I would like to query the DBIdentifier during a backup (possibly from backint). - If I create a second instance (B) for recovery, and recover instance A into it, does instance B have its own DBIdentifier, or does it get the same DBIdentifier as instance A? I guess that when I do the first backup of B it will get its own DBIdentifier? - Can I get hold of the DBIdentifier for an instance? David -----Original Message----- From: Brunzema, Martin [mailto:[EMAIL PROTECTED] Sent: 21 September 2005 10:47 To: maxdb@lists.mysql.com Cc: David Lane Subject: RE: Does a MaxDB instance have a unique identifier? Hi David, the answer is yes. The DBIdentifier is set when the backuphistory starts (i.e. the first databackup is made) The datavolume, logvolume, databackups and logbackups are labeled with this identifier. During restart and recovery consistency is checked using this identifier. Kind regards, Martin -----Original Message----- From: David Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 11:07 AM To: maxdb@lists.mysql.com Subject: Does a MaxDB instance have a unique identifier? Does a MaxDB instance have a unique identifier, like every Oracle database has a 'dbid'? Thanks David Lane _____________________________________________________________________ BridgeHead Software is pleased to confirm this e-mail has been scanned for viruses by MessageLabs. _____________________________________________________________________ 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]
