Please use the following steps to backup Tibero databases with AhsayOBM on Linux CLI.
Note: Configuring the backup destination storage will be in two parts:
- Set a local folder as destination storage
- Add Ahsay Drive as destination storage
- Connect to a Linux machine using an SSH client like PuTTY.
- Log in to the root account.
- Change directory to the bin folder by entering the following command:
cd /usr/local/obm/bin - Launch AhsayOBM by entering the following:
sh RunConfigurator.sh - Select option 1 and log in using your credentials.
- Select option 5 to generate a new backup set settings template.
- Select option 5 for Tibero Database Server.
- Configure the backup set settings by editing the XML file using a text editor like vi. Either quit AhsayOBM or open a new SSH session then go to the following directory:
cd /root/.obm/config - Edit the XML file by entering the follwing:
vi backupSet.xml - Configure the backup set settings by entering the desired settings in the Value Data field inside the text editor. The configurable settings are the following:
- Backup Set Name
- Temporary directory for storing backup files
- Remove temporary files after backup
- Compression type
- Backup files' permission
- Tibero Database Server Setting
- Tibero Database Home
- Tibero Login ID
- Tibero Password
- Tibero Host
- Tibero Port
- Tibero SID
- Selected Source
- Deselected Source
- Enable scheduled backup
- Daily, Weekly, Monthly, or Custom Settings
- Name of your destination
- Directory to store your backup files (set to a local folder)
- Enable deduplication
- Deduplication scope
- After editing the XML file, press Esc then enter :wq to save the changes and exit the text editor.
- Return to the bin folder and launch AhsayOBM again then login using your credentials.
- Select option 4 to import the backup set settings XML file.
- Enter [ Y ] to enable encryption.
- Select option 1 for Default encryption.
- Open your web browser and enter the URL of your backup server.
- Log in using your credentials and click the [ User ] tile.
- Click the [ Backup Set ] tab then click on the newly created backup set.
- Click the [ Destination ] tab.
- Click on the + icon to add a destination storage.
- Choose Ahsay Drive then click on the + icon on the lower right to add the destination storage.
- Click on the save icon on the lower right to save the changes.
- Go back to PuTTY and log in to AhsayOBM again to verify if Ahsay Drive has been added to the destination storage.
- Quit AhsayOBM then verify if the scheduled backup settings are correct by entering the following command:
cat /root/.obm/log/Scheduler/debug.log - Run a backup job by going to the bin folder and entering the following command:
sh RunBackupSet.sh ' (Backup Set Name) '