Restore

To view instructions for GUI and CLI Operating Systems, please select from below:

Windows and Linux (GUI)

  1. Click the Restore icon on the main interface of AhsayOBM.

    success

  2. Select the backup set and destination.

    success

    You can select the temporary directory for storing temporary files by clicking Browse.

    success

  3. This step will determine if the database will be restored automatically or manually.

    For automatic restore, select the database that you would like to restore. You can also choose to restore a backed-up database from a specific backup job using the “Select what to restore” drop-down menu.

    success

    Or to manually restore the database, tick the Restore raw file option, then select the “Tibero Database Server”. Click Next to proceed.

    success

  4. Select where to restore the database, either to the Original location or an Alternate database port for automatic restore or select the path where you would like the raw file(s) to be restored for manual restore.

    success

    • Restore to Original location

      success

    • Restore to Alternate database port

      success

      If Alternate database port is selected, the following settings on “Restore to Alternate Database Port” window are not configurable except for the “Port”:

      • Tibero Home - where the Tibero Home path is located. This is already set to the location of the Tibero Home by default.
      • Login ID - the login ID of the Tibero server. The default login ID is “SYS”.
      • Password - the password for the system user account in the new database.
      • Host - this value is set to 127.0.0.1.
      • Port - the port number of the alternate Tibero database instance.
      • SID - the SID for the alternate Tibero database instance.

      success

      If you want to proceed with Alternate database port, you need to change the “Port” during the restore process and ensure that the same “Port” is also changed in the backup set after the restore process.

    • Restore raw file

      Click the Browse button to select the location on the local machine where you want to restore the Tibero database to.

      success

    If you would like to enable the Verify checksum of in-file delta files during restore setting, click the Show advanced option link.

    success

  5. Once configured, click Restore to proceed.

  6. The following screen will appear requiring you to answer the question manually.

    success

    If the following screen appears during the restore process, select the default action “3. [Q]uit without shutting down” and stop the database service. Alternatively, select action “2. Shutdown [I]mmediately” to continue the restore process.

    success

  7. The restore job has completed successfully.

    success

  8. After the restore job is completed, you can verify if the Tibero database instance has been restored using the following SQL query to verify if the instance is online.

    success

Only for Restore Raw File

  1. After the restore job is completed, you can verify if the Tibero database have been restored. Go to the designated path on the local machine where you restored the Tibero database files.

    Example: Using Windows File Explorer

    success

  2. Recovering RAW Tibero database

    To recover RAW database, please refer to Tibero database server Backup and Recovery guide for more details.

Linux (CLI)

  1. To Restore files that have been backed up, you must first configure the Restore.sh file. For more information, please refer to the Linux CLI Backup & Restore section.

  2. Once the file has been configured, run Restore.sh to begin the Restore process.

    
OBM bin
------
[root@xxx bin]# sh Restore.sh
-
Using APP_HOME: : /usr/local/obm
Using BACKUP_SET : Tibero_BSET
Using RESTORE_FROM : Tibero Database Server
Using RESTORE_TO : /root/restore
Using POINT_IN_TIME : Current
Using RESTORE_PERMISSION : N
Using TEMP_DIR : /root/Temp
Filter Pattern not set, filter would not apply to restore
[2024-08-21 16:02:44] Start [AhsayOBM v9.11]
...
[2024-08-21 16:02:51] Total Downloaded Size = 143.16 MB
[2024-08-21 16:02:51] Total Restored Size = 779.17 MB
[2024-08-21 16:02:51] Total Restored File = 18
[2024-08-21 16:02:51] Restore Completed Successfully
[2024-08-21 16:02:51] end,RESTORE_STOP_SUCCESS,0,0,0,,0,0
[root@xxx bin]#

    Restore for Tibero-based Backup Sets is limited to only several options on Linux (CLI). For more information, please refer to the Limitations section.

AhsayOBM