-
Book Overview & Buying
-
Table Of Contents
Oracle 11g R1/R2 Real Application Clusters Essentials
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...
Change the font size
Change margin width
Change background colour