What is a logical backup?

 Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.
  • Interview Candidate
  • 3
  • 11286

Showing Answers 1 - 3 of 3 Answers

CMANNE

  • Jan 4th, 2006
 

The simple example for logical backup is export and import. The logical backup involves in taking the snapshot of the database at that particular instance in terms of series of SQL statements which is not a byte-by-byte copy of the database. This is obvious when we check the dump file created during export using a hex editor. Unfortunately it is possible to resore the database upto the point at which the export has been done and it wont be possible to do the recovery using export dumpfile.

  Was this answer useful?  Yes

Sriharsha N

  • Mar 25th, 2011
 

Logical backup means backing up the database objects like tables, views , indexes...etc using the EXPORT utility given 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 dump file, and this file can be read using another utility called IMPORT. The logical backup can be made also through remote process.

  Was this answer useful?  Yes

gurubhai33

  • Mar 26th, 2011
 

Backups that are done using exp/imp or Data pump as called logical backups. It take the backup of logical structure of database instead of physical.

  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