Oracle 10g/11g RAC, DataGuard实战之Oracle 10gR2 DataGuard

最新推荐文章于 2021-04-03 15:33:06 发布

congpang7069

最新推荐文章于 2021-04-03 15:33:06 发布

阅读量76

点赞数

请加入QQ群参加Oracle 10g/11g RAC DataGuard, Goldengate交流和免费提供99%正确率的

Oracle RAC, DataGuard, Goldengate, Streams部分实战文档和实战视频。

Oracle RAC, DataGuard, GoldenGate, Streams

Hands-on Practice QQ Groups:

212975915 / 212976048 / 213082853

Oracle 10g/11g RAC, DataGuard实战环境

Oracle Database 10gR2 High Availability with Data Guard on Linux

1. Install Oracle Database 10gR2 on Linux for primary Database

1.1 Install Linux (CentOS 5.3) - ()

1.2 Install Required Linux Packages for Oracle - (Video)

1.3 Operating System Configuration - (Video)

1.4 Network Configuration - (Video)

1.5 Create "oracle" User and Directories - (Video)

1.6 Download the Oracle Database 10g Release 2 Software - (Video)

1.7 Pre-Installation Tasks - (Video)

1.8 Install Oracle Database 10gR2 Software Using OUI - (Video)

1.9 Install the Oracle Database 10gR2 Companion CD Software - (Video)

1.10 Apply the 10.2.0.3 Database Patchset - (Video)

1.11 Create Oracle TNS Listener - (Video)

1.12 Create the Oracle Database Using DBCA - (Video)

1.13 Post-Installation Tasks - (Video)

1.13.1 Re-compile Invalid Objects - (Video)

1.13.2 Enabling Archive Logs - (Video)

1.13.3 Enabling Flashback Database - (Video)

1.13.4 Creating / Altering Tablespaces - (Optional) - ()

1.14 Setting up Automatic Database Starting and Stopping - ()

1.15 EM Database Console and Database Environment - ()

2. Install Oracle Database 10gR2 on Linux for Physical Standby

2.1 Install Linux (CentOS 5.3) - ()

2.2 Install Required Linux Packages for Oracle - (Video)

2.3 Operating System Configuration - (Video)

2.4 Network Configuration - (Video)

2.5 Create "oracle" User and Directories - (Video)

2.6 Download the Oracle Database 10g Release 2 Software - (Video)

2.7 Pre-Installation Tasks - (Video)

2.8 Install Oracle Database 10gR2 Software Using OUI - (Video)

2.9 Install the Oracle Database 10gR2 Companion CD Software - (Video)

2.10 Apply the 10.2.0.3 Database Patchset - (Video)

2.11 Create Oracle TNS Listener - (Video)

2.12 Create the Oracle Database Using DBCA - (Video)

2.13 Post-Installation Tasks - (Video)

2.13.1 Re-compile Invalid Objects - (Video)

2.13.2 Enabling Archive Logs - (Video)

2.13.3 Enabling Flashback Database - (Video)

2.13.4 Creating / Altering Tablespaces - (Optional) - ()

2.14 Setting up Automatic Database Starting and Stopping - ()

2.15 EM Database Console and Database Environment - ()

3. Install Oracle Database 10gR2 for Physical/Logical Standby

3.1 Install Linux (CentOS 5.3) - ()

3.2 Install Required Linux Packages for Oracle - (Video)

3.3 Operating System Configuration - (Video)

3.4 Network Configuration - (Video)

3.5 Create "oracle" User and Directories - (Video)

3.6 Download the Oracle Database 10g Release 2 Software - (Video)

3.7 Pre-Installation Tasks - (Video)

3.8 Install Oracle Database 10gR2 Software Using OUI - (Video)

3.9 Install the Oracle Database 10gR2 Companion CD Software - (Video)

3.10 Apply the 10.2.0.3 Database Patchset - (Video)

3.11 Create Oracle TNS Listener - (Video)

3.12 Create the Oracle Database Using DBCA - (Video)

3.13 Post-Installation Tasks - (Video)

3.13.1 Re-compile Invalid Objects - (Video)

3.13.2 Enabling Archive Logs - (Video)

3.13.3 Enabling Flashback Database - (Video)

3.13.4 Creating / Altering Tablespaces - (Optional) - ()

3.14 Setting up Automatic Database Starting and Stopping - ()

3.15 EM Database Console and Database Environment - ()

4. Configure Primary and two Physical Standby Databases

4.1 Configure the Primary Database - (Video)

src="http://www.youtube.com/embed/5GMFqJGqUBU?hl=en&fs=1" frameborder="0" allowfullscreen>

Step 1: Enable Archivelog Mode and Flashback Database - (Video)

Step 2: Create a Password file - (Video)

Step 3 Enable Force Logging - (Video)

Step 4: Create Standby Redo Logs - (Video)

Step 5: Configure Oracle Net Components on Primary Database - (Video)

Step 6: Configure the Primary Database Initialization Parameters - (Video)

Step 7: Create a Backup of the Primary Database - (Video)

Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video)

4.2 Configure the First Physical Standby Database(xiamen) - (Video)

Step1: Enable Archivelog Mode and Flashback Database - (Video)

Step2: Create a Password file - (Video)

Step3 Enable Force Logging - (Video)

Step4: Create Standby Redo Logs - (Video)

Step5: Create Directories on the Standby Host - (Video)

Step6: Transfer the files to the standby host - (Video)

Step7: Create a spfile for the Standby Instance - (Video)

Step8: Configure Oracle Net Components on Primary Database - (Video)

Step9: Start the standby database nomount - (Video)

Step10: Create the Physical Standby Database - (Video)

Step11: Start mount the Physical Standby Database - (Video)

Step12: Start Redo Apply on the Standby Database - (Video)

Step13: Enable Flashback Database - (Video)

Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video)

4.3 Configure the Second Physical Standby Database - (Video)

Step1: Enable Archivelog Mode and Flashback Database - (Video)

Step2: Create a Password file - (Video)

Step3 Enable Force Logging - (Video)

Step4: Create Standby Redo Logs - (Video)

Step5: Create Directories on the Standby Host - (Video)

Step6: Transfer the files to the standby host - (Video)

Step7: Create a spfile for the Standby Instance - (Video)

Step8: Configure Oracle Net Components on Primary Database - (Video)

Step9: Start the standby database nomount - (Video)

Step10: Create the Physical Standby Database - (Video)

Step11: Start mount the Physical Standby Database - (Video)

Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video)

Step13: Start Redo Apply on the Standby Database - (Video)

Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video)

4.4 Verifying the Physical Standby Database - (Video)

4.5 Startup and Verify Physical Standby Database - ()

5. Upgrading and Downgrading the Protection Mode

5.1 Data Guard Protection Mode - ()

5.2 Upgrading the Protection Mode - (Video)

Step 1: Add Standby Redo Logfile for the Standby Database if necessary - (Video)

Step 2: Add Standby Redo Logfile for the primary database - (Video)

Step 3: Configure LOG_ARCHIVE_DEST_n on Primary Database - (Video)

Step 4: Configure LOG_ARCHIVE_DEST_n on Standby Database and Restart - (Video)

Step 5: Start Redo Apply on the Standby Database - (Video)

Step 6: Change the Protection Mode on the Primary Database - (Video)

Step 7: Start Remote Archiving and Verify the New Protection Mode - (Video)

5.3 Downgrading the Protection Mode - (Video)

Step 1: Configure LOG_LOG_ARCHIVE_DEST_n on the Primary Database - (Video)

Step 2: Configure LOG_ARCHIVE_DEST_n on the Standby Database - (Video)

Stop 3: Verify Standby Redo Logs on the Standby Databases - (Video)

Step 4: Verify Standby Redo Logs on the Primary Database - (Video)

Step 5: Start Redo Apply on the Standby Database - (Video)

Step 6: Change the Protection Mode on the Primary Database - (Video)

Step 7: Start Remote Archiving and Verify the New Protection Mode - (Video)

6. Role Transition - Physical Standby Database

6.1 Perform a Switchover with shanghainode and xiamennode - (Video)

Step 1: Verify the Switchover status on the Primary - shanghainode - (Video)

Step 2: Convert the primary database into a physical standby database - (Video)

Step 3: Shut down and restart the former primary as a new standby - (Video)

Step 4: Query the SWITCHOVER_STATUS on the standby database - (Video)

Step 5: Convert the former standby to a primary database - (Video)

Step 6: Shutdown and restart the new primary database - (Video)

Step 7: Start Redo Apply on the new physical standby - shanghainode - (Video)

Step 8: Start Redo Apply on the physical standby - longyannode - (Video)

Step 9: Verify the new primary and standby database - (Video)

6.2 Perform a Switchback with xiamennode and shanghainode - (Video)

Step 1: Verify the Switchover status on the Primary - xiamennode - (Video)

Step 2: Convert the primary database into a physical standby database - (Video)

Step 3: Shut down and restart the former primary as a new standby - (Video)

Step 4: Query the SWITCHOVER_STATUS on the standby database - (Video)

Step 5: Convert the former standby to a primary database - (Video)

Step 6: Shutdown and restart the new primary database - (Video)

Step 7: Start Redo Apply on the new physical standby - xiamennode - (Video)

Step 8: Start Redo Apply on the physical standby - longyannode - (Video)

Step9: Verify the new primary and standby database - (Video)

6.3 Perform a Switchover with shanghainode and longyannode - (Video)

Step 1: Verify the Switchover status on the Primary - shanghainode - (Video)

Step 2: Convert the primary database into a physical standby database - (Video)

Step 3: Shut down and restart the former primary as a new standby - (Video)

Step 4: Query the SWITCHOVER_STATUS on the standby database - (Video)

Step 5: Convert the standby to a primary database - (Video)

Step 6: Shutdown and restart the new primary database - (Video)

Step 7: Start Redo Apply on the new physical standby - shanghainode - (Video)

Step 8: Start Redo Apply on the physical standby - xiamennode - (Video)

Step 9: Verify the new primary and standby database - (Video)

6.4 Perform a Switchback with longyannode and shanghainode - (Video)

Step 1: Verify the Switchover status on the Primary - shanghainode - (Video)

Step 2: Convert the primary database into a physical standby database - (Video)

Step 3: Shut down and restart the former primary as a new standby - (Video)

Step 4: Query the SWITCHOVER_STATUS on the standby database - (Video)

Step 5: Convert the former standby to a primary database - (Video)

Step 6: Shutdown and restart the new primary database - (Video)

Step 7: Start Redo Apply on the new physical standby - longyannode - (Video)

Step 8: Start Redo Apply on the physical standby - xiamennode - (Video)

Step 9: Verify the new primary and standby database - (Video)

6.5 Perform a Failover to the Physical Standby - xiamennode - (Video)

Step1: Identify and resolve any archive log gaps - (Video)

Step2: Copy and register any other missing archived redo logs - (Video)

Step3: Perform terminal recovery on the target standby - (Video)

Step4: convert the physical standby into a primary database - (Video)

Step5: Restart the new primary database in read/write mode - (Video)

Step6: Verify the new Primary Database - (Video)

Step7: Perform a full backup of the new primary database - (Video)

Step8: Flashing Back the Physical Standby Database - longyannode - (Video)

Step9: Using Flashback Database After a Failover - (Video)

6.6 Flashing Back a Failed Primary into a Physical Standby - (Video)

Step1: Determine the SCN at which the old standby database became the primary database - (Video)

Step 2: Flash back the failed primary database - (Video)

Step 3: Convert the Failed Database to a Physical Standby Database - (Video)

Step 4: Shut down and restart the old primary database - (Video)

Step 5: Restart transporting redo to the new physical standby - (Video)

Step 6: Start Redo Apply - (Video)

Step 7: Restart Redo Apply on the new physical standby database if necessary - (Video)

Step 8: Verify the new primary and standby database - (Video)

6.7 Perform a Switchback with xiamennode and shanghainode - (Video)

Step1: Verify the Switchover status on the Primary - xiamennode - (Video)

Step2: Convert the primary database into a physical standby database - (Video)

Step3: Shut down and restart the former primary as a new standby - (Video)

Step4: Query the SWITCHOVER_STATUS on the standby database - (Video)

Step5: Convert the former standby to a primary database - (Video)

Step6: Shutdown and restart the new primary database - (Video)

Step7: Start Redo Apply on the new physical standby - xiamennode - (Video)

Step8: Start Redo Apply on the physical standby - longyannode - (Video)

Step9: Verify the new primary and standby database - (Video)

7. Oracle Data Guard Broker

7.1 Oracle Data Guard Broker Concepts - ()

7.2 Configuring Data Guard Broker - (Video)

Step 1: Stop the MRP on standby database if necessary - (Video)

Step 2: Modify the listener.ora files - (Video)

Step 3: Modify the DataGuard Broker related init parameters - (Video)

Step 4: Create Configuration - (Video)

Step 5: Enable Configuration - (Video)

Step 6: Verify Configuration - (Video)

7.3 Changing the State of a Database - (Video)

7.4 Start / Stop Data Guard with Broker - ()

7.5 Managing Data Protection Modes - ()

7.6 Upgrading the Protection Mode - (Video)

Step 1: Set up standby redo log files if necessary - (Video)

Step 2: Set the LogXptMode configurable database property, if necessary - (Video)

Step 3: Set the protection mode - (Video)

Step 4: Update the LogXptMode property for Primary Database - (Video)

7.7 Downgrading the Protection Mode - (Video)

Step 1: Query if Standby Redo Logs exit on the Standby - (Video)

Step 2: Set the LogXptMode configurable database property, if necessary - (Video)

Step 3: Set the protection mode - (Video)

Step 4: Update the LogXptMode property for Primary Database - (Video)

7.8 Removing the Broker - (Video)

Step 1: Remove Broker configuration using DGMGRL - (Video)

Step 2. Set the DG_BROKER_START to FALSE using SQL*PLUS - (Video)

Step 3. Delete the two Broker configuration files from disk - (Video)

8. Role Transition - Switchover and Failover Using Broker

8.1 Introduction to Role Transition - ()

8.2 Flashback Technologies and Data Guard - ()

8.3 Preparatory Checks before a Switchover - (Video)

8.4 Perform a Switchover with shanghai and xiamen Using Broker - (Video)

Step 1: Check the primary database - (Video)

Step 2: Check the standby database that is the target of the switchover - (Video)

Step 3: Issue the switchover command - (Video)

Step 4: Show the configuration - (Video)

8.5 Perform a Switchover with xiamen and shanghai Using Broker - (Video)

Step1: Check the primary database - (Video)

Step2: Check the standby database that is the target of the switchover - (Video)

Step3: Issue the switchover command - (Video)

Step4: Show the configuration - (Video)

8.6 Perform a Switchover with shanghai and longyan Using Broker - (Video)

Step1: Check the primary database - (Video)

Step2: Check the standby database that is the target of the switchover - (Video)

Step3: Issue the switchover command - (Video)

Step4: Show the configuration - (Video)

8.7 Perform a Switchover with shanghai and longyan Using Broker - (Video)

Step1: Check the primary database - (Video)

Step2: Check the standby database that is the target of the switchover - (Video)

Step3: Issue the switchover command - (Video)

Step4: Show the configuration - (Video)

8.8 Perform a Manual Failover Using Broker - (Video)

Step1: Connect to the target standby database - (Video)

Step2: Issue the failover command - (Video)

Step3: Show the configuration - (Video)

Step4: Show StatusReport property of the new primary database - (Video)

Step5: Show the database - (Video)

8.9 Reinstating a Failed Primary Database - (Video)

Step 1: Restart the Old Primary Database - (Video)

Step 2: Reinstate the old primary database - (Video)

Step 3: Show the Configuration and Databases - (Video)

8.10 Perform a Switchover with xiamen and shanghai Using Broker - (Video)

Step 1: Check the primary database - (Video)

Step 2: Check the standby database that is the target of the switchover - (Video)

Step 3: Issue the switchover command - (Video)

Step 4: Show the configuration - (Video)

9. Fast-Start Failover - Automatic Failover

9.1 Fast-Start Failover Architecture - ()

9.2 Enabling Fast-Start Failover and Starting the Observer - (Video)

Step 1: Ensure standby redo logs are configured on the primary and target standby - (Video)

Step 2: Ensure the LogXptMode Property is set to SYNC - (Video)

Step 3: Set the FastStartFailoverTarget configuration property - (Video)

Step 4: Determine the protection mode you want - (Video)

Step 5: Set the FastStartFailoverThreshold configuration property - (Video)

Step 6: Set other database properties (optional) - (Video)

Step 7: Enable Flashback Database if necessary - (Video)

Step 8: Start the observer - (Video)

Step 9: Enable fast start failover - (Video)

Step 10: Verify the fast-start failover configuration - (Video)

9.3 Initiating a Fast-Start Failover - (Video)

Step 1: Stutting down Primary Database with abort option - (Video)

Step 2: Verify configuration and database after the fast-start failover - (Video)

Step 3: Manually Restart the former primary database - (Video)

Step 4: Restart the former primary database again - (Video)

Step 5: Reinstate the former primary database - (Video)

9.4 Perform a Switchover with xiamen and shanghai Using Broker - (Video)

Step1: Check the primary database - (Video)

Step2: Check the standby database that is the target of the switchover - (Video)

Step3: Issue the switchover command - (Video)

Step4: Show the configuration - (Video)

9.5 Disabling Fast-Start Failover - (Video)

10. Managing Physical Standby and Logical Standby Database

10.1 Downgrading Maximum Performance if necessary - (Video)

Step 1: Query if Standby Redo Logs exit on the Standby - (Video)

Step 2: Set the LogXptMode configurable database property, if necessary - (Video)

Step 3: Set the protection mode - (Video)

Step 4: Update the LogXptMode property for Primary Database - (Video)

10.2 Removing the Broker - (Video)

Step 1: Remove Broker configuration using DGMGRL - (Video)

Step 2. Set the DG_BROKER_START to FALSE using SQL*PLUS - (Video)

Step 3. Delete the two Broker configuration files from disk - (Video)

10.3 Create a Logical Standby Database - (Video)

Step 1: Create a Physical Standby Database - (Video)

Step 2: Stop Redo Apply on the Physical Standby Database - (Video)

Step 3: Build a Dictionary in the Redo Data - (Video)

Step 4: Verify Supplemental Logging is Enable on the Primary and Standby - (Video)

Step 5: Convert Physical Standby Database to a Logical Standby Database - (Video)

Step 6: Create a New Password File for Logical Standby - (Video)

Step 7: Adjust Initialization Parameters for the Logical Standby - longyan - (Video)

Step 8: Adjust Initialization Parameters for the Primary - shanghai - (Video)

Step 9: Adjust Initialization Parameters for the Physical Standby - xiamen - (Video)

Step 10: Mount the Logical Standby Database and Physical Standby - (Video)

Step 11: Open the Logical Standby Database - longyan - (Video)

Step 12: Start SQL Apply on the Logical Standby Database - longyan - (Video)

Step 13: Start Redo Apply on the Physical Standby Database - xiamen - (Video)

Step 14: Start Remote Archiving - (Video)

10.4 Verifying the Logical Standby and Physical Standby - (Video)

10.5 Start and Stop the Physical Standby & Logical Standby - ()

11. Role Transition - Physical and Logical Standby Database

11.1 Perform a Switchover with shanghainode and xiamennode - (Video)