Best Practices and Recommendations

Please consider the following recommendations:

  1. To enable a full Tibero database instance recovery, all databases including SYSTEM, TBS1, UNDO USR and related application databases except for “TEMP” must be selected in the backup source when creating the backup set. Otherwise, without a backup of these databases, a full Tibero database instance recovery will NOT be possible.
  2. Full database backup or incremental / differential database backups should be scheduled when system activity is low to achieve the best possible performance and to minimize the impact on the database server performance (for example: scheduled to run on weekends).
  3. For Archived Log backups, the backup frequency should be dependent on the number of transactions or activity on the database. Databases with more transaction should run archived log backup more frequently (for example: instead of a daily backup, it should be run multiple times a day).
  4. To provide maximum data protection and flexible restore options, it is recommended to configure:
    • At least one offsite or cloud destination
    • At least one local destination for fast recovery

  5. Perform test restores periodically to ensure that your backup is set up and data are backed up properly.

    Performing recovery tests can also help identify potential issues or gaps in your recovery plan. It is important that you do not try to make the test easier, as the objective of a successful test is not to demonstrate that everything is flawless. There might be flaws identified in the plan throughout the test and it is important to identify those flaws.

  6. The Restore Raw File option is for advanced Tibero database administrators and should only be used if you have in-depth knowledge and understanding of Tibero database engine, Tibero database schema, knowledge of the database server and network infrastructure. Therefore, it is not recommended to use this restore option as there is need to utilize additional Tibero techniques and scripts to facilitate a manual database restore.
  7. To ensure an optimal backup/restore performance, it is highly recommended to set the temporary directory folder to a local disk location with sufficient free disk space. It must be on another location other than Drive C: (e.g. Drive E:) for Windows and /root/temp for Linux.
AhsayOBM