Physical and Logical Backups

What is the difference between physical and logical backups?

Questions by shanthiavari

Showing Answers 1 - 3 of 3 Answers


  • Jan 11th, 2013

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

  Was this answer useful?  Yes

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).

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions