rawishsiddiqui

 Profile Answers by rawishsiddiqui 

• Jul 19th, 2008

 

In Oracle Logical Backup is "which is taken using either Traditional Export/Import or Latest Data Pump". Where as Physical backup is known "when you take Physical O/s Database related Files as Backup".

Jai

• Jan 11th, 2013

 

Logical backup means backup of tablespace in the form of binary but physical backup means backup of databfile, controlfile, logfile, spfile

abhishek_jee

 Profile Answers by abhishek_jee 

• Nov 17th, 2014

 

Logical backup implies taking "logical"copies of the database, i.e., the tables, indexes, synonyms, triggers, tablespaces, etc.
Physical backup implies taking a "physical" or "actual"backup of the database, in the form of all the files involved in making up the database, such as datafiles (.dbf). controlfiles (.ctl), redo log files (.rdo), archived redo log files, spfile and init.ora file.

Physical backups come in two forms: cold (or offline, in NOARCHIVELOG mode) and hot (or online, in ARCHIVELOG mode).