Forum Discussion

hdablin's avatar
hdablin
Level 3
10 years ago

Backup / Restore Oracle schema with BE 2014 (expdp / impdp)

One of my customers uses Oracle as a database for his Accounting System. He uses RMAN scripts to backup and restore data. For Export:

expdp system/xxxxxx DIRECTORY=DUMPFILES SCHEMAS=cen DUMPFILE=$dmpfile LOGFILE=$logfile

For Import:

impdp system/******* DIRECTORY=DUMPFILES REMAP_SCHEMA=cen:realise DUMPFILE=cen_201103040700.dmp LOGFILE=cen_201103040700.log


Can we do all that things (schema/objects export, import and remap) natively with Backup Exec? If yes, where can I find the info and guides? I don't have an Oracle experience, so please sorry for such a dumb question.

  • Using the BE interface, you can setup to backup & restore information such as Oracle DBs, tablespaces, control/data files. However, afaik, one cannot backup & restore schema using BE.

    Secondly, if you run expdp and impdp commands to dump the Database, then same can be achieved by a backup via BE.

5 Replies

  • Nopes, not natively via Backup Exec as these are built-in Oracle commands.

    And the Oracle backup via Backup Exec can be done in two ways. One is DBA initiated via the RMAN console which involves running scripts from the RMAN console and the other is running directly from the BE console itself.

  • Thank you for the reply! But can we achieve the same results (as running these command) via native BE interface?

  • Using the BE interface, you can setup to backup & restore information such as Oracle DBs, tablespaces, control/data files. However, afaik, one cannot backup & restore schema using BE.

    Secondly, if you run expdp and impdp commands to dump the Database, then same can be achieved by a backup via BE.

  • Thank you! I'll try to do it next week. Will post the results here.