Navicat tool for Oracle database replication or backup and restoration (subject to evaluation)

GXPT is a distributed system that temporarily includes the permission system, basic system, evaluation system, and examination system. Each system has its own oracle database. Our group is responsible for the evaluation system, and the normal evaluation system needs to rely on the permission system and basic system. The specific business is not explained here. The evaluation activities are coming soon. The basic system enters real data into the basic database, and the evaluation system also wants to perform functional and stress tests, of course, it is different to directly operate on the data in the basic real database, so we have prepared a backup server with oracle installed for testing.

Oracle databases cannot be directly backed up and restored as SQL Server does. First, I have created the basic system tablespace and assigned permissions to the created users. In order to achieve oracle database replication or Backup recovery, I provide three Navicat operations:

1. Use Navicat Premium to copy oracle table data

This method is equivalent to Ctrl + C and Ctrl + V Operations. You can directly copy the data from the source oracle database to the target database. This method is faster, but it also feels prone to errors, if the data import error occurs, you can continue importing other table data. Select a table from the source database, press Ctrl + C, select a table from the target database, and press Ctrl + V to select the data table and view to be copied.

 

2. Navicat Export and Import Wizard to back up and restore

This is a real backup and Restoration Operation. When using the Export Wizard to back up data, refer to the data format supported by the import Wizard to prevent data from being easily restored. In this way, each table exports a corresponding file.

2.1 select source database 'table' and select export Wizard to back up data

 

2.2 select the target database 'table' and select the import Wizard to restore the data.

 

3. Run Navicat and dump SQL files to restore and back up oracle databases

In this way, the entire database table can be exported to an SQL file, so that the operation is not easy to lose files or data. In comparison to the three methods, this method is the most reliable.

3.1 select the target database 'table' and select the "Dump SQL file" Wizard to back up data

 

3.2 select the target database 'table' and select "run SQL file" to restore data.

 

So far, the Navicat tool has completed the implementation of the Oracle database copy or backup and restoration functions. Maybe there are still better ways to operate it, I hope more people can share and learn.