What are the differences between logical and physical standby databases?

I've built out a logical standby database before with the help of a team mate so I never fully understood the concept of the logical vs physical standby. What are the main differences? When building one out what are the different steps? I remeber there was a step to convert from logical to physical but entirely sure.

THANKS!
themeeper1Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
johnsone has stated it quite well.

I just wanted to offer up the doc link.  The online docs typically have everything you need:
http://docs.oracle.com/cd/E11882_01/server.112/e25608/standby.htm#i72627
0
 
johnsoneSenior Oracle DBACommented:
The main difference is that a physical standby is a block for block copy of the primary database.  Changes are applied at the block level.  Logical standby is a copy of the data from the primary.  Changes are applied by running equivalent SQL statements.
0
All Courses

From novice to tech pro — start learning today.