Difference between physical and logical backup in oracle | In this post, we will discuss the about differences between physical (RMAN) and logical backup(expdp).
Difference between physical and logical backup.
Physical backup is backup of the physical files such as datafiles, control files, and archived redo logs. Ultimately, every physical backup is a copy of files storing database information to some other location, whether on disk or some offline storage such as tape.
Physical backup can be done via rman utility as below.
RMAN> backup database plus archivelog all;
$exp USERID=scott/tiger FULL=y FILE=myfull.dmp
$exp USERID=scott/tiger OWNER=(SCOTT, ALI) FILE=exp_own.dmp
$imp USERID=scott/tiger FULL=y FILE=myfull.dmp
Useful Post :-