Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Oracle documentation says, Oracle Data Pump utilities are designed for enhanced performance especially for large databases. For large volume database a dramatic increase in performance should be experienced in compared to the original Export and Import utilities. Moreover original Export (exp) or Import (imp) utilities are de-supported for general use as of Oracle Database 12c. Therefore, Oracle recommends to use the new Data Pump Export (expdp) and Import (impdp) utilities, except the case where you want to import files that were created using the original Export utility (exp).

There are some fundamental differences between original utilities and Data Pump utilities. Those are,

  • Data Pump uses parallelism to export large database in lesser time.
  • Data Pump technology fully uses all available resources to maximize throughput and minimize elapsed job time.
  • Dump files are read and written directly by the server and, therefore, do not require any data movement to the client.
  • The database administrator (DBA) must create directory objects that define the server locations to which files are written.

In recent version of Ginesys (above 11.147.5), Oracle 12c database (12.1.0.2.0) is the only supported Oracle version . Also the original export utility (ref. Notification: Ginesys no longer supports Oracle 10g). Original Oracle backup utility (exp) is not capable to do a successful complete export of Ginesys database (12c) as exp fails to export some advanced functionality in Oracle 12c. Ginesys already released the revamped backup utility based on take export of all objects mainly where advanced features of 12c are implemented. Oracle has already  officially de-supported the old utilities (exp & imp) and guided to use Oracle Data Pump utilities (expdp & impdp) to export or import database. Ginesys, release 11.147.8 onward, already revamped Database backup utility and it now uses Oracle Data Pump Export utility (expdp) in release 11.147.8. To as backup agent. To accommodate the changes in new Oracle utility Ginesys backup utility has also changed. Now there are some specific requirement requirements to select the backup location. This article will help you to select the backup location for Ginesys Backup utility.

Single server deployment (application and database on the same server):

...

Utility creates a date-folder and writes some export files other than Oracle backup. This has to be a UNC path shared from Database server. Permission must be provided suitably so that Application server can writes file files without any restriction.

Path 2:

...

On backup directory proper permission must be provided so that Application server can writes file without any restriction.
As on date current version of Ginesys (11.148.x series) restore utility still uses original import utility (imp). As a result, any backup created by expdp utility cannot be restored using Ginesys DB Restore utility. Manual restoration required. 



Related Article

How To: Backup and Restore Oracle database manually using Data Pump Export and Import



...