when to use logical backup(Datapump-expdp,impdp) and when to use physical backup(hot&cold backup) in oracle?

Vikas

• Jan 9th, 2018

Generally, datapump is being used to remap schemas or tables as routine activities which is logical backup. For cases like database restore, creating replicated databases physical backup is mostly considered.

Nishanth

• Mar 15th, 2016

A database dump using expdp is a 1-time export of one or more database schemas. It backs up DDL (table structures, views, synonyms, stored procedures, packages, etc), plus data. An RMAN backup is a...

Answer Question  Select Best Answer