hdablin
10 years agoLevel 3
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.