What is difference between Logical Standby Database and Physical Standby database?

The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical standby is always an exact structural duplicate of the master database. The downside, though, is that logical standby is based on newer technologies (logical standby is new in Oracle 9.2) and tends to be generally regarded as more tempramental than physical standby.
  • Interview Candidate
  • 2
  • 5533

Showing Answers 1 - 2 of 2 Answers

santhosh

  • Jun 26th, 2006
 

Physical Standby - acheived by copying the archivle log files

Logical Standby - makes the dml statements using archivelogs generated and applies to the secondary database

  Was this answer useful?  Yes

Ashu Shukla

  • Oct 29th, 2007
 

A physical or logical standby database is a database replica created from a backup of a primary database.

  • A physical standby database is physically identical to the primary database on a block-for-block basis.  It's maintained in managed recovery mode to remain current and can be set to read only; archive logs are copied and applied.
  • A logical standby database is logically identical to the primary database.  It is updated using SQL statements

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