Post reply

Difference between Physical & Logical instances

  • January 27, 2011 at 6:11 am

    #234028

    Hi,

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

    Thank you all.

    Naveen

  • January 27, 2011 at 6:20 am

    #1279019

    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

  • January 27, 2011 at 6:25 am

    #1279022

    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

  • January 27, 2011 at 6:50 am

    #1279041

    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.

    ---------------------------------------------------------------------

  • January 27, 2011 at 10:24 am

    #1279210

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

    Thank You,

    Best Regards,

    SQLBuddy

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

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