Oracle Enterprise Server supports a wide range of backup solutions. This section will focus on and illustrate those methods. Oracle backup solutions are mainly categorized into two types:
Logical backup
Physical backup
A Logical backup is initiated by either running the traditional export (exp
) or data pump (expdp
) utilities from the $ORACLE_HOME/bin
location. The restoral of these backups is initiated by either running the traditional import (imp
) or data pump (impdb
) utilities. These utilities are typically used to move database structures and data between Oracle databases, between different Oracle versions, and between databases running across operating systems. The following are the usage and benefits of Logical backup:
A Logical backup is the process for unloading the data into a binary file (dump file) from the database using a set of SQL statements.
Using Logical backup, you can perform object-level, schema-level, tablespace-level, or entire database...