Software AG Products 10.11 | Administering CentraSite | Configuring CentraSite | Maintaining the CentraSite Internal Database | Restoring the Database from a Backup
 
Restoring the Database from a Backup
Pre-requisites:
To restore the database backup through the CentraSite Command Line Interface, you must have the CentraSite Administrator role.
You can change the contents of CentraSite's internal database back to a previous state by restoring a backup. When you restore a backup, you completely replace the current contents of the database by the contents that existed when the backup was made.
CentraSite provides a set of command tools for this purpose.
Repository changes that are made between one backup and the subsequent backup are stored in session logs. When you restore from a backup, you can optionally select to include or omit the data from the session logs.
As soon as the restore step successfully finishes, the repository is automatically started in standby mode. Then the recover step is started, in which all changes that were made since the last backup are reapplied from the session logs. Finally, the repository is shut down again. The restore function can only be used when the repository is inactive (stopped).
Note:
During the installation of CentraSite, a backup of the initial repository state is automatically created, with a timestamp equal to the date and time when you install the product. If you for any reason wish to restore the repository to its initial state, that is, the state immediately after product installation, you can use this backup.
*To restore the database from a backup
1. First, back up the current database, in case you decide to return to this database state at a later time.
2. Stop the CentraSite Registry or Repository.
3. To show a list of all available backups and their backup keys (the unique identifiers for the backups), run the command listbackups.
The syntax is of the format inoadmin listbackups <server>
4. Identify the backup file you wish to use for the restore operation.
5. To restore from the selected backup, run the command restore.
The syntax is of the format inoadmin restore <server> <BackupKey> <RecoverOption>
6. Select the recover option that you want to use. If you do not specify a recover option, this has the same effect as using the option recover all.
The following recover options are available:
Option
Action
recover all
The database is restored to the state stored in the backup, and all session logs created since the backup are included.
This is the default option.
recover no
The database is restored to the state stored in the backup. No session log data is processed.
recover <UntilDateTime>
All session logs created after the specified time and date are excluded from the recovery. The format of this field is:
DD-MMM-YYYY:HH:MM:SS
The month is given as a 3-letter abbreviation, using the first 3 characters of the month's name.
Example: 23-OCT-2012:16:52:30
recover
This has the same effect as recover all.
The following example restores the database from a backup whose backup key is 001334732430. All database changes that occurred after the backup was made, up to and including 11:30am on October 25, 2012, is also retrieved from the session logs.
inoadmin restore CentraSite 001334732430 recover 25-OCT-2012:11:30:00
Disabled Backups
If you select to restore a backup without full recovery by using the recovery option no, and there are one or more backups that are more recent than the backup being restored, these more recent backups are set to disabled.
If you select to restore a backup without full recovery by using the option recover <UntilDateTime>, and there are one or more backups that are more recent than the time specified by this option, these more recent backups are set to disabled.
A disabled backup cannot be accessed any more from any of the CentraSite user interfaces, and in particular cannot be accessed for restore or recover operations. It is not displayed in the list of available backups.
Disabled backups remain on the backup location on your disk as long as there are older, non-disabled backups. If you delete all non-disabled backups that are older than a given disabled backup, CentraSite automatically deletes the disabled backup.
If you should wish to reactivate a disabled backup, archive it using standard operating system functionality and contact your software supplier.
Moving a database / Disaster Recovery
Under normal circumstances, a database backup that is created on one machine can only be restored to the same machine. However, a database backup that originated on one machine can be configured, so that it can be restored onto another machine. For more information, see Moving a Database to Another Location.