MaxDB WikiBackup
Recovery
How to recreate a database out of a data- and log backup using the dbmcli
Create a database using the db_create command
Define a medium for your databackup with medium_put
Restore your configuration by the command recover_config <your_medium>
Check the parameters (i.e. rundirectory, log- and datavolumes)
Initialize the database and restore the data using db_activate RECOVER <your_medium>
If you happily also have some logbackups, then you should recover them now using the
commands recover_start and recover_continue
If you recovered logbackups the restart the database by recover_ignore. Otherwise
use simply db_online
How to recreate a database out of a data- and log backup using dbmgui (Windows only)
use the Create-wizard and select 'Restore parameters from a backup medium' in the 'Parameter Initialization' dialog.
define a medium that points to your backup in the 'Parameters from a Medium' dialog
check the parameters; adjust the rundirectorym to match your new environment if necessary
in the 'Volumes' dialog: make sure that the paths to your data and log volumes match your environment in case they are absolute paths
in the 'Backup medium' dialog, keep the definition of your medium, this is where your data will be recovered from
choose the default of 'Create instance for recovery' in the 'Creation mode' dialog
continue with the installation and then with the recovery
Migration
Migration using backups
If your target machine and OS is of the same type as the machine you created the backup on, then there is no problem.
If your target machine or OS differ from the machine you created the backup on, the following conditions must be met:
The byte swap must be identical on both machines. Note that byte swap depends on processor type and sometimes on the operating system.
If you change the operating system during the migration, the MaxDB version used must be new enough to allow the migration. If the backup can be restored on the new machine then the MaxDB version was new enough.