-
编辑 删除
[Data Guard]Oracle10g Data Guard学习笔记（三）
9. Performing Switchover and FailoverChoosing the Best Role Transition OperationPlanned role transition-switchoverPrimary database can be repaired in as timely manner -repair primary databasePrimary database can not be repaired in as timely manner-failoverSwitchover-no data loss/no resetting of online redo logsPerforming a Switchover by Using Enterprise Managera. A check is made to ensure that the primary database and standby database are not currentlyin an error status condition and that
-
编辑 删除
[Data Guard]Oracle10g Data Guard学习笔记（二）
1. Using Data Guard Broker and Enterprise ManagerData Guard Broker: ComponentsClient-side:Two interfaces– Oracle Enterprise Manager 10g Grid Control– A command-line interface: DGMGRLServer-side: Data Guard monitor– DMON process– Configuration filesA broker configuration consists ofA configuration objectDatabase objectsInstance objectsData Guard Broker: Requirements• You must use the Enterprise Edition of Oracle Database 10g.• 10g企业版• 单实例或多实例•
-
编辑 删除
[Data Guard]Oracle10g Data Guard学习笔记（一）
1. Oracle Data Guard: OverviewTypes of Standby DatabasesPhysical standby database block-for-block, redo applyLogical standby database Shares the same schema definition, SQL applyTypes of ServicesRedo transport services, Log apply services, Role-management servicesRole TransitionsSwitchoverFailoverData Protection ModesMaximum protection：commit完成前保证redo已被写入主数据库和至少一个备数据库，备机若异常不能传输redo则主库自动下掉Maximum availability：备机正常情况下同最大保护模式，
