DataGuard学习要点:

1.  掌握安装和配置DataGuard主库和备库

Installing and Configuring Oracle 11gR2 DataGuard on Linux

-> 4. Configuring the Primary and Physical Standby Databases

4.1 Configuring the Primary Database (配置DataGuard主库)

4.2 Configuring the Physical Standby Database(xiamen) (配置DataGuard备库)

4.3 Verifying the Data Guard Configuration

4.4 Creating tables and load with initial data (学习创建表空间,用户,创建表,索引等)

4.5 Startup and Stop the DataGuard

 

2. 学会DataGuard保护模式(Protection Mode)

Installing and Configuring Oracle 11gR2 DataGuard on Linux ->

->    5. Upgrading and Downgrading the Protection Mode

 

3. DataGuard角色转换(Role Transition - Swithover and Failover)

Installing and Configuring Oracle 11gR2 DataGuard on Linux ->

->    6. Performing Role Transition - Swithover and Failover

->     8. Performing Switchover and Failover with DG Broker

 

4. 配置Oracle Data Guard Broker (Configuring Oracle Data Guard Broker)

Installing and Configuring Oracle 11gR2 DataGuard on Linux ->

 ->     7. Configuring Oracle Data Guard Broker

 

5. 检查DataGuard的状态 (几乎每天都用)

8. Monitoring DataGuard Status and Performing DR Test

8.1 Check the health of the Data Guard configuration

8.2 Monitoring DataGuard Status with Scripts (SQL)

 

 

6. DataGuard Switchover (DR Test)(灾备演练)

Installing and Configuring Oracle 11gR2 DataGuard on Linux

 ->   8.7 Performing DR Test (DG Switchover and Switchback)

 

7. 重建DataGuard备库和DataGuard Broker

 Installing and Configuring Oracle 11gR2 DataGuard on Linux

 -> 13. Rebuilding the DataGuard Standby Database and DG broker

13.2 Rebuilding the Standby Database Manually Example1

13.3 Rebuilding the Standby Database Manually Example2

13.5 Re-create Oracle Dataguard Broker in Action


请使用浏览器的分享功能分享到微信等