Oracle Database 10g Oracle Data Guard 2004
Oracle Data Guard... 3... 3... 3 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 5 Oracle Data Guard... 6 Oracle Data Guard... 7... 8 Data Guard... 8 REDO Apply SQL Apply... 8 REDO Apply... 9 SQL Apply... 11 Real Time Apply... 13... 14... 14... 14... 15... 15... 17... 17... 18 REDO... 18 Enterprise Manager Data Guard Broker... 18... 19 Oracle Data Guard RAC... 20... 20 Data Guard... 21... 23... 23 Oracle Database 10g Oracle Data Guard 2 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Data Guard 365 24 Oracle Data Guard 365 24 Oracle Database 10g Oracle Data Guard 1 E-Business 1 / BCP: Business Continuity Plan BCP 1 / 1 Oracle Database 10g Oracle Data Guard 3 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Data Guard Oracle Data Guard Oracle Data Guard DR: Disaster Recovery Oracle Oracle Database 10g Oracle Data Guard Data Guard Oracle Data Guard [1] Oracle Data Guard Oracle Data Guard Oracle Data Guard 1 Data Guard Data Guard Oracle Database 10gEnterprise Edition Data Guard Real Application Clusters RAC Recovery Manager RMAN Oracle High Availability HA Oracle Data Guard 1: OracleData Guard Oracle Database 10g Oracle Data Guard 4 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Data Guard Oracle Data Guard 1 Data Guard REDO REDO REDO Data Guard REDO Data Guard REDO Data Guard REDO Apply Data Guard SQL Apply Oracle SQL Data Guard SQL*Plus Data Guard Data Guard Broker Data Guard Broker Data Guard Oracle Enterprise Manager Broker DGMGRL Broker Oracle Database 10g Oracle Data Guard 5 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Data Guard 2: Oracle Data Guard Oracle Data Guard Oracle Data Guard Data Guard Data Guard REDO REDO CPU I/O Oracle Database 10g Oracle Data Guard 6 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Data Guard 1 REDO Data Guard Data Guard Broker Data Guard Broker Data Guard Oracle Enterprise Manager Broker DGMGRL Oracle Data Guard Oracle Enterprise Edition Oracle Data Guard Oracle Data Guard Oracle 3: Oracle Data Guard Oracle Database 10g Oracle Data Guard 7 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Data Guard LGWR ARCH REDO FAL Oracle Data Guard RFS REDO MRP REDO LSP SQL REDO Data Guard Broker Oracle Data Guard Data Guard Broker Monitor DMON Data Guard Data Guard 1 9 Real Application Clusters RAC Oracle Net Services TCP/IP Local Area Network LAN Metropolitan Area Network MAN Wide Area Networks WAN Data Guard Intel Linux Intel Linux Windows Data Guard Oracle Database Enterprise Edition REDO Apply SQL Apply Data Guard REDO REDO Oracle Database 10g Oracle Data Guard 8 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Data Guard REDO 2 Data Guard 2 REDO Apply: SQL Apply: 2 REDO 2 REDO 2 REDO REDO Apply Oracle REDO REDO Apply REDO Data Guard REDO Apply MRP REDO Oracle Database 10g Oracle Data Guard Real Time Apply REDO RFS MRP REDO REDO MRP REDO ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Data Guard REDO Apply Oracle Database 10g RECOVER MANAGED STANDBY DATABASE PARALLEL Oracle Database 10g MRP PARALLEL CPU Oracle Database 10g Oracle Data Guard 9 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
REDO REDO REDO ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; ALTER DATABASE OPEN; Data Guard DDL DML REDO Oracle Database 10g Oracle Data Guard 10 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Recovery Manager RMAN CPU I/O Recovery Manager REDO Apply SQL REDO Apply SQL Apply SQL Apply REDO SQL SQL SQL SQL / DDL DML [1] SQL Apply SQL Apply Oracle Database 10g Oracle Data Guard 11 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
4: Data Guard SQL Apply SQL Apply ALTER DATABASE START LOGICAL STANDBY APPLY; SQL Apply Reader Real Time Apply REDO REDO LCR LCR LSP LCR Data Guard Data Guard DDL DML Data Guard Oracle Database 10g Oracle Data Guard 12 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
CPU I/O Real Time Apply Oracle Database 10g Data Guard Real Time Apply REDO REDO SRL REDO Apply SQL Apply Data Guard REDO Real Time Apply ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE; Real Time Apply ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE; Real Time Apply Data Guard SQL Apply RPO RTO Oracle Data Guard Oracle Data Guard RPO RTO Oracle Database 10g Oracle Data Guard 13 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Data Guard 3 SQL ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {PROTECTION AVAILABILITY PERFORMANCE}; REDO LGWR SYNC LGWR SYNC 0 LGWR ASYNC ARCH REDO 1 2 REDO 2 REDO Oracle Database 10g Oracle Data Guard 14 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
REDO / REDO REDO Enterprise Manager REDO REDO WAN Data Guard Oracle Data Guard 2 Data Guard Broker Oracle Oracle Database 10g Oracle Data Guard 15 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Enterprise Manager GUI SQL 1 Oracle Database 10g Data Guard 5: Oracle Database 10g Oracle Data Guard 16 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Data Guard Data Guard Data Guard Data Guard 1 Data Guard REDO REDO Oracle Data Guard REDO REDO Oracle Database 10g Oracle Data Guard 17 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Data Guard Oracle Database 10g Real Time Apply 1 Real Time Apply REDO / REDO Oracle Database 10g Data Guard SQL Apply Oracle Database 10g 2 Data Guard 24 REDO REDO REDO Enterprise Manager Data Guard Broker Oracle Data Guard Broker Data Guard Broker Oracle Enterprise Manager Broker Oracle Database 10g Oracle Data Guard 18 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
DGMGRL Enterprise Manager Data Guard 6: Oracle Enterprise Manager Oracle Data Guard Broker 9 Data Guard RAC Data Guard Broker Data Guard Data Guard WAN MAN LAN Data Guard Oracle Database 10g Oracle Data Guard 19 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
LAN LAN Data Guard [5] Oracle Data Guard RAC Oracle Data Guard Oracle Real Application Clusters RAC RAC RAC Data Guard Data Guard RAC RAC RAC Enterprise Manager Broker SQL Oracle Data Guard Real Application Clusters IT HA Oracle Maximum Availability Architecture MAA Oracle Oracle MAA MAA Oracle MAA Oracle Database 10g Oracle Data Guard 20 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
MAA MTTR Data Guard MAA MAA Data Guard [3] [6] RAC Data Guard REDO SQL Apply Data Guard MAA Oracle Database 10g MAA Oracle [2] Data Guard Oracle Data Guard Oracle Data Guard Oracle Data Guard Oracle Data Guard REDO 3 REDO Data Guard Data Guard 7 27 I/O Oracle Database 10g Oracle Data Guard 21 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
7: : Data Guard WAN ESCON ESCON/ IP ATM SONET 1 OLTP / Data Guard IP REDO WAN Oracle Data Guard Oracle Data Guard Oracle Database 10g Oracle Data Guard 22 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
ROI Oracle Data Guard Oracle Data Guard Oracle Data Guard Oracle Data Guard Data Guard Broker Oracle Enterprise Manager DR Oracle Data Guard 1. Oracle Data Guard 2. Oracle 3. MAA Detailed White Paper, http://otn.oracle.com/deploy/availability/htdocs/maa.htm Oracle Database 10g Oracle Data Guard 23 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
4. Oracle9i Media Recovery Best Practices, http://otn.oracle.com/deploy/availability/htdocs/maa.htm 5. Oracle9i Data Guard: Primary Site and Network Configuration Best Practices, http://otn.oracle.com/deploy/availability/htdocs/maa.htm 6. Oracle9i Data Guard: SQL Apply Best Practices, http://otn.oracle.com/deploy/availability/htdocs/maa.htm Oracle Database 10g Oracle Data Guard 24 Oracle Corporation Oracle Data Guard in Oracle Database 10g Disaster Recovery for the Enterprise
Oracle Database 10g Oracle Data Guard 2004 : Ashish Ray Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Oracle Copyright 2004 Oracle Corporation All rights reserved.