播布客视频-DataGuard介绍笔记

 Oracle 11g DatGuard 介绍
 
 前言
 Data Guard Concepts and Administroator
 B28294-01
 
一、what is DG
        High availability
        Data protection
        Disaster recovery
        Load balance

二、了解DG的主库、备库   
        1.Primary database
            production database that is accessed by most of your applications
        2.Standby database
            transactionally consistent copy of the primary database
            applying redo data to standby database
         主库最多可以带9个备库
   
三、备库的类型
         1. 物理备库REDO APPLY
             bolck-for-block块对块的copy
             provides a physically identical copy of the primary database though REDO APPLY
            usage:data protection, reporting
            11g 新特性
            receive apply redo 和 read only access 可以同时存在，而在10g只可以保持一种状态
         2. 逻辑备库SQL APPLY
             provides same logical info though SQL APPLY,which transforms the data in the redo recevied from the primary database into SQL statement and then executing the SQL statements on the standby database.
             usage:data protection, reporting , database upgrades
         3. Snapshot Standby Database(11g new feature)
              receive redo data , not apply.
      
四、DATAGUARD SERVICES
        1. Redo Transport Services(RTS)
            负责把主库上的redo data 传输到备库上
            Control the automated transfer of redo data from the production database to one or more archival destinations.
            a. transmit redo data 
            b. manage the process of resolving any gaps in the archived redo log files due to a network failure
            c. automatically detect and retrieve missing or corrupted archived redo log files
        2. Apply Services
            Apply redo data on the standby database to maintain transactional syn with primary database.
            difference between physical and logical standby database:
            is manner in which apply aervices apply the archived redo data
            物理备库： REDO APPLY 基于块的copy(STANDBY: READONLY)
            逻辑备库： SQL APPLY (STANDBY:READ/WRITE)
        3. Role Transitions  
            the change of role of database using switchover or a failover operation
            a. swithover: ensured no data loss. in planned .
            b. failover: primary database is unavaliable. not in planned.
      
五、管理DATAGUARD的三种工具
        1. 命令行工具SQL*PLUS
        2. 命令行工具DGMGRL
        3. GUI工具OEM
   
六、 DG的保护模式
          1. Maximum availablity
              highest level of data protection.Don't commit until all redo data
              writted to the online redo log and at least one standby database.
              When cannot write its redo data to standby db, it will switches to maximun performance mode until it again able to write redo data to standby database
              This protection mode ensures zero data loss.
          2. Maximum performance(DEFAULT PROTECTION MODE)
              allow transaction to commit when all redo data has been written to the online redo log.
       Redo data is written to standby db by asynchronously .
          3. Maximum protection
              ensures no data loss
              writted to the online redo log and at least one standby databas before transaction commits.
              When cannot write , primary db will shut down.
      
七、DG的好处
        1. Disaster recovery, data protection , high availability
        2. Complete data protection, ensure zero data loss
        3. Efficient use of system resources, such as backups ,reporting , queries.
        4. Flexibility in data protection to balance availability and performance
        5. Automatic gap detection and resolution,without manual intervention by the dba.
        6. Centralized and simple management by DataGuard broker
        7. Integration with Oracle Database(DG is a feature of db Enterprise Edition and does not require separate installation.)
        8. automatic role transitions (fast-start failover)

参考链接：http://www.boo booke.com/bbs/viewthread.php?tid=7630&extra=page%3D1&page=2

DG1.jpg

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9252210/viewspace-627175/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9252210/viewspace-627175/