• Mirroring or AlwaysOn would be the equivalent of Data Guard in SQL Server, although it has some fundamental differences (e.g. it's at the level of an individual database, rather than a whole instance).

    Not sure what you mean by "seperation of duties" in relation to Data Guard. That term relates to security and organisational practices? Do you mean "Shared Nothing Architecture", or am I misunderstanding?