Difference between Physical & Logical instances

  • naveenkumar_segu

    Mr or Mrs. 500

    Points: 540


    I have heard two phrases from someone “Physical & Logical instances”. Can anyone please explain me what this is?

    Thank you all.


  • Gail Shaw

    SSC Guru

    Points: 1004424

    No such thing as a physical or logical instance of SQL. Could be something unrelated. Why don’t you ask the person that you heard it from?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Pouliot Philippe


    Points: 1812

    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.


  • george sibbald

    SSC Guru

    Points: 104200

    they might have a meant a ‘virtual’ instance, which is what a sql instance is referred to in a clustered configuration as it could reside on more than one physical node.


  • SQLBuddy123

    One Orange Chip

    Points: 28234

    Or Could be a Instance on a Virtual Machine Vs Instance on a Physical Machine

    Thank You,

    Best Regards,


Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply