With Xopero ONE, you can protect multiple components of your infrastructure, including workstations and servers.

Backup & recovery

To protect your workstations and servers, you can use one of three main types of backups:

1. File-level — saves individual files and directories.

2. Image-level — protects the entire physical disk.

3. Databases — backs up your databases.

Similarly to backup types, Xopero ONE offers three methods to restore your data:

1. File-level backup — allows you to restore files directly from your storage. It can also be used to restore databases protected with file-level backup.

2. Image-level backup — enables restoring an entire disk, individual files from the backup, or the disk as an image file. You can also use BMR (bare-metal recovery) technology to recover data, allowing restoration between physical devices.

3. Database recovery — includes methods for restoring previously backed-up databases.

1. Test the Xopero ONE system to determine when backups are performed and choose the best backup schedule. For example, you can schedule backups to run after working hours and enable automatic device shutdown after the backup in the plan settings.

2. The backup process typically uses the VSS service and device resources. To reduce resource usage, you don’t need to create multiple backup plans for different storages — instead, you can create a replication plan to copy data to another storage.

Oracle database backup involves generating a database dump using backup scripts and then backing up the resulting dump file.

Linux preparation process

echo 'connect target /; quit' | rman

echo 'SELECT INSTANCE_NAME FROM V$INSTANCE;' | sqlplus / as sysdba

Before starting the Oracle database backup task, make sure that the database mode is set to ARCHIVELOG. To verify that the mode is configured correctly or to change it, open the command line as the user configured in the backup plan and run the sqlplus tool using the following command:

You can then close this tool using the QUIT; command.

To verify that the database mode is correctly set to ARCHIVELOG, run the following command:

When creating a backup plan, in the Data to protect section, select the folder where database dumps will be stored. You can choose either Select from device or Select path or variable — switch between these options by clicking on the text in the list.

1. Create a new temporary folder.

Xopero ONE allows you to easily restore data — an entire backup, selected directories, or individual files — to any location.

Recovery process

Image-level backup creates a full snapshot of your system, including the operating system, applications, and data.

Overview

Drive image-level backup (aka disk image backup) by definition creates a complete, byte-for-byte copy of a hard drive, including the operating system, all installed applications, settings, and other data. In case of failure, drive image-level backup allows for a rapid and full restoration of the system to its previous state, either on the original or a new device.

Creating a backup plan

An Oracle database can be restored to its original location or to a new temporary directory.

How to restore an Oracle database from backup

The first step in restoring an Oracle database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the Oracle database environment.

To restore files backed up using a file-level backup plan follow this guide.

If the database files are restored to a temporary directory, run the following command in the CLI:

/opt/XoperoONEBackupAgent/Xopero.Device.App --oracle-restore database_ID backupuser /home/backupuser/oracle/oracle_database_dump

• /opt/XoperoONEBackupAgent/Xopero.Device.App — path to the Xopero ONE application

• --oracle-restore — parameter used to restore the Oracle database

• database_ID — ID of the database to be restored

• backupuser — user with permission to restore the database

• /home/backupuser/oracle/oracle_database_dump — path to the directory containing the restored database files

If the restore completes successfully, information about the restored database will be displayed on the screen:

If part of the database is currently unavailable (for example, if a user deleted a table), the restoration process described above may fail, as the deletion is a more recent operation in the database.

The solution is to run the modified command:

The last optional parameter, required only when restoring to the source host, should be set to true. This ensures Xopero sets the SCN (System Change Number) to the point immediately after the backup.

Setting this parameter resolves issues with unrestored parts of the database. The restoration method described in the first section of this article will still work, but it may not always produce the expected results.

PostgreSQL database can be restored to its original location or to a new temporary directory.

How to restore PostgreSQL database from backup

The first step in restoring a PostgreSQL database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the PostgreSQL database environment.

To restore files backed up using a file-level backup plan follow this guide. If your database was backed up using an image-level backup, use granular recovery to restore it as described in this article.

Once the database files are restored, the next step is to import them into the PostgreSQL environment.

The first step in restoring a Microsoft SQL database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the Microsoft SQL database environment.

To restore files backed up using a file-level backup plan follow . If your database was backed up using an image-level backup, use granular recovery to restore it as described in .

Once the database files are restored, the next step is to import them into the Microsoft SQL environment.

In Xopero ONE, you can back up a variety of databases, including Oracle, MySQL, PostgreSQL, and Microsoft SQL.

General information

The Microsoft SQL database backup process in Xopero ONE consists of two steps:

1. Creating a database dump using backup scripts.

2. Backing up the database dump.

The first step is performed through Xopero ONE using the backup scripts feature. The second step is a standard file-level or image-level backup executed directly by Xopero ONE.

The MySQL database backup process in Xopero ONE consists of two steps:

1. Creating a database dump using backup scripts.

2. Backing up the database dump.

The first step is performed through Xopero ONE

The Oracle database backup process in Xopero ONE consists of two stages:

1. Creating a database dump using backup scripts.

2. Backing up the created dump file.

The first stage is executed through Xopero ONE using the

To maintain data consistency, Xopero recommends using a dedicated backup type: a file-based backup with a pre-backup script for the PostgreSQL database.

Database backup begins with a script that requests the database server to create a dump in a temporary directory. Once the dump is complete, Xopero ONE backs up the generated dump file.

Xopero ONE uses the pg_dump utility to back up PostgreSQL databases.

In Xopero ONE, there are three recovery options available for image-level backups, allowing you to choose the one that best suits your needs and preferences.

Initiating the recovery process

The iSCSI target option allows you to quickly create and share an iSCSI resource over the TCP/IP protocol. You can connect this resource to any device without restoring backup copies to another location. This method is useful for granular restoration and enables easy file copying through the file explorer.

Bare-metal recovery (BMR) restores your entire system from an image-level backup, including the operating system, applications, and all associated data.

BMR (bare-metal restore, also known as bare-metal recovery) enables rapid system recovery using a system image created with disk-imaging software. The image file restores the entire operating system and its underlying configurations in minutes, completely bypassing the lengthy process of manual OS and application re-installation. Because BMR allows you to quickly return a physical machine or server to its full operational state following a data-loss event or hardware failure, it serves as a cornerstone of an effective disaster recovery strategy.

In Xopero ONE, the BMR process is streamlined into four primary steps:

MySQL database can be restored to its original location or to a new temporary directory.

How to restore MySQL database from backup

The first step in restoring a MySQL database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the MySQL database environment.

To restore files backed up using a file-level backup plan follow this guide. If your database was backed up using an image-level backup, use granular recovery to restore it as described in this article.

Once the database files are restored, the next step is to import them into the MySQL environment. To restore the database to the MySQL server, use a database management tool.