Physical and Logical Backup

What kind of backup you take Physical / Logical? Which one is better and Why?

Questions by Pragati.rch

Showing Answers 1 - 6 of 6 Answers

bishma

  • Aug 30th, 2008
 

Logical backup means backing up the individual database objects such as tables, views , indexes.. using the utility called EXPORT, provided by Oracle. The objects exported in this way can be imported into either same database or into any other database. The backed-up copy of information is stored in a dumpfile, and this file can be read using another utility called IMPORT. There is no other way you can use this file.
Physical backups rely on the Operating System to make a copy of the physical files like data files, log files, control files that comprise the database

We don't prefered logical backup.
it is very slow and recoverys not possible

mselva84

  • Feb 22nd, 2010
 

Logical Backups: In this backup Oracle Export utility stores data in Binary file at OS level.

Physical Backups: In this backup physically Datafiles are copied from one location to another( Disk, Tape etc.)

  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