• Physcial or Logical exist for Oracle.

    1.Physical Standby Database

    Standby database is called “physical” if the physical structure of stand by exactly matches with stand by structure. Archived redo log transferred from primary database will be directly applied to the stand by database.

    2.Logical Standby Database

    Stand by database is called “logical”, the physical structure of both

    databases do not match and from the archived redo log we create SQL statements then these statements will be applied to stand by database.

    http://www.orafaq.com/node/957