请加入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
RAC and Data Guard on Linux
PART I - Install Oracle Grid Control 10.2.0.5.0
1. Install Oracle repository Database
1.1 Install the Linux OS (CentOS 5.3) - ()
1.2 Install Required Linux Packages for Oracle - (Video)
1.3 Netwok Configuration - (Video)
1.4 Operating System Configuration - (Video)
1.5 Create "oracle" User and Directories - (Video)
1.6 Download the Oracle Database 11g Release 1 Software - (Video)
1.7 Install the Oracle Database 11gR1 Software - (Video)
1.8 Install the Oracle Database 11g Examples Software - (Video)
1.9 Apply the Database Patchset - (Video)
1.10 Create Oracle TNS Listener Process - (Video)
1.11 Create a Oracle Database - (Video)
1.12 Post-Installation Tasks - (Video)
1.12.1 Re-compile Invalid Objects - (Video)
1.12.2 Enabling Archive Logs - (Optional) - (Video)
1.12.3 Enabling Flashback Database - (Video)
1.13 Setting up Automatic Database Starting and Stopping - ()
1.14 Oracle Enterprise Manager 11g - ()
2. Install Oracle Enterprise Manager Grid Control 10.2.0.5.0
2.1 Overview of Grid Control - (Video)
2.2 Pre-Installation Requirements - (Video)
2.3 Prepare the Existing Oracle 11g Database for Grid Control Install - (Video)
2.4 Install Enterprise Manager Base Version 10.2.0.1.1 - (Video)
2.5 Patch the Enterprise Manager Installation to 10.2.0.5 - (Video)
2.6 Configure Grid Control Installation using ConfigureGC.pl - (Video)
3. Post-Installation of Grid Control
3.1 Verify Grid Control - OMS, Application Server and Agent - (Video)
3.1.1 OPMN Processes - (Video)
3.1.2 Grid Control Console - ()
3.1.3 Remote Login Grid Control Console - (Video)
3.1.4 Verify 10.2.0.5 Component Version for OMS - (Video)
3.1.5 Verify 10.2.0.5 Component Version for Management Agent - (Video)
3.1.6 Configure Database Instance - (Video)
3.2 Secure OMS and Management Agent - (Video)
3.2.1 Secure OMS - ()
3.2.2 Secure the Management Agent - (Video)
3.3 Starting / Stopping the Grid Control Environment - (Video)
3.3.1 Starting the Management Repository Database - (Video)
3.3.2 Starting the Oracle Management Service (OMS) - (Video)
3.3.3 Starting the Management Agent - (Video)
3.3.4 Stopping the Management Agent - (Video)
3.3.5 Stopping the Oracle Management Service (OMS) - ()
3.3.6 Stopping the Management Repository Database - (Video)
PART II Oracle 10gR2 HA with RAC and Data Guard
1. Building an Oracle RAC 10gR2 for RAC Primary
1.1 Install Linux OS(CentOS 5.3) - ()
1.2 Install Required Linux Packages for Oracle RAC- (Video)
1.3 Network Configuration - (Video)
1.4 Create "oracle" User and Directories - (Video)
1.5 Configure the Linux Servers for Oracle - (Video)
1.6 Configure the "hangcheck-timer" Kernel Module - (Video)
1.7 Configure RAC Nodes for Remote Access using SSH - (Video)
1.8 IP SAN Configuration - Openfiler - ()
1.9 Install Openfiler - SAN - ()
1.10 Configure iSCSI Volumes using openfiler - (Video)
1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video)
1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video)
1.13 Install and Configure ASM (ASMLib2.0) - (Video)
1.14 Download Oracle RAC 10g Software - (Video)
1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video)
1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video)
1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video)
1.18 Install and configure Automatic Storage Management (ASM) - (Video)
1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video)
1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video)
1.21 Install Oracle Database 10g Companion CD Software - (Video)
1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video)
1.23 Create TNS Listener Process - (Video)
1.24 Create ASM Instance - (Video)
1.25 Install the EM agent on each cluster node - (Video)
1.25.1 Pre-Installation Requirements - (Video)
1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video)
1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video)
1.25.4 Verify Agent Status - (Video)
1.25.5 Secure the Management Agent if necessary - (Video)
1.26 Create a Cluster Database - (Video)
1.27 Post-Installation Tasks - (Optional) - (Video)
1.27.1 Re-compile Invalid Objects - (Video)
1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video)
1.27.3 Create Shared Oracle Password Files - (Video)
1.28 Verify TNS Networking Files - (Video)
1.29 Create / Alter Tablespaces - ()
1.30 Verify the RAC Cluster & Database Configuration - (Video)
1.31 Configuring the Initialization Parameters - (Video)
1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video)
1.32.1 Stopping the Oracle RAC 10g Environment - (Video)
1.32.2 Start Monitor the alert.log - ()
1.32.3 Start the Oracle RAC 10g - ()
2. Building an Oracle RAC 10gR2 for RAC Standby
2.1 Install Linux OS(CentOS 5.3) - ()
2.2 Install Required Linux Packages for Oracle RAC - (Video)
2.3 Network Configuration - (Video)
2.4 Create "oracle" User and Directories - (Video)
2.5 Configure the Linux Servers for Oracle - (Video)
2.6 Configure the "hangcheck-timer" Kernel Module - (Video)
2.7 Configure RAC Nodes for Remote Access using SSH - (Video)
2.8 Configure iSCSI Volumes using openfiler - (Video)
2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video)
2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video)
2.11 Install and Configure ASM (ASMLib2.0) - (Video)
2.12 Download Oracle RAC 10g Software - (Video)
2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video)
2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video)
2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video)
2.16 Install and configure Automatic Storage Management (ASM) - (Video)
2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video)
2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video)
2.19 Install Oracle Database 10g Companion CD Software - (Video)
2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video)
2.21 Create TNS Listener Process - (Video)
2.22 Create ASM Instance - (Video)
2.23 Install the EM agent on each cluster node - (Video)
2.23.1 Pre-Installation Requirements - (Video)
2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video)
2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video)
2.23.4 Verify Agent Status - ()
2.23.5 Secure the Management Agent if necessary - ()
2.24 Create a Cluster Database - (Video)
2.25 Post-Installation Tasks - (Optional) - (Video)
2.25.1 Re-compile Invalid Objects - (Video)
2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video)
2.25.3 Create Shared Oracle Password Files - (Video)
2.26 Verify TNS Networking Files - (Video)
2.27 Create / Alter Tablespaces - ()
2.28 Verify the RAC Cluster & Database Configuration - (Video)
2.29 Configuring the Initialization Parameters - (Video)
2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
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 Install the Enterprise Manager agent - (Video)
3.12.1 Pre-Installation Requirements - (Video)
3.12.2 Download Oracle Management Agent (10.2.0.5) - (Video)
3.12.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video)
3.12.4 Verify Agent Status - (Video)
3.13 Create an Oracle Database - (Video)
3.14 Post-Installation Tasks - (Video)
3.14.1 Re-compile Invalid Objects - (Video)
3.14.2 Enabling Archive Logs - (Video)
3.14.3 Enabling Flashback Database - (Video)
4. Configure the RAC Primary/Standby and non-RAC Standby
4.1 Configure the RAC Primary Database - (Video)
Step1: Enable Archive Mode with the FLASHBACK option enabled - (Video)
Step2: Create Shared Oracle Password Files - (Video)
Step3: Enable Force Logging - (Video)
Step4: Create Standby Redo Logs - (Video)
Step5: Configure Oracle Net Components on the RAC Primary Database - (Video)
Step6: Configure Initialization Parameters on the RAC Primary Database - (Video)
Step7: Create a Backup of the Primary Database - (Video)
Step8: Update /etc/hosts file on all nodes and Verify Network - (Video)
4.2 Configure the RAC Standby Database - (Video)
Step1: Enable Archive Mode with the Flashback option enabled - (Video)
Step2: Enable Force Logging - (Video)
Step3: Create Shared Oracle Password Files - (Video)
Step4: Create Directories on the Standby Host - (Video)
Step5: Transfer the files to the Standby Host - (Video)
Step6: Create a spfile for the RAC Standby Instance - (Video)
Step7: Configure Oracle Net Components on the RAC Standby Database - (Video)
Step8: Startup Standby Database nomount - (Video)
Step9: Create the RAC Physical Standby Database - (Video)
Step10: Start mount the RAC Physical Standby Database - (Video)
Step11: Add RAC Standby Database and Instances to the OCR - (Video)
Step12: Start Redo Apply on the RAC Physical Standby Database - (Video)
Step13: Verify the RAC Primary and RAC Standby - (Video)
Step14: Add Standby Redo Logs for the RAC Physical Standby Database - (Video)
Step15: Enabling Flashback Database on the RAC Physical Standby - (Video)
4.3 Configure the non-RAC Physical Standby Database - (Video)
Step1: Enable Archivelog Mode - (Video)
Step2: Enable Force Logging - (Video)
Step3: Create the Standby Password File - (Video)
Step4: Create Directories on the Standby Host - (Video)
Step5: Transfer the files to the standby host - (Video)
Step6: Create a spfile for the Standby Instance - (Video)
Step7: Configure Oracle Net Components on the non-RAC Standby - (Video)
Step8: Startup Standby Database nomount - (Video)
Step9: Create the non-RAC Physical Standby Database - (Video)
Step10: Start the standby database. - (Video)
Step11: Start Redo Apply on the Standby Database - (Video)
Step12: Verify the RAC Primary and non-RAC Standby - (Video)
Step13: Add Standby Redo Logs for the Standby Database - (Video)
Step14: Enabling Flashback Database on the non-RAC Physical Standby - (Video)
5. Managing the Primary and Physical Standby Database
5.1 Start monitor the alert.log file - ()
5.2 Start / Stop the Primary and Physical Standby Database - ()
6. Upgrading and Downgrading the Protection Mode
6.1 Data Guard Protection Modes - ()
6.2 Upgrading the Protection Mode - (Video)
Step1: Add Standby Redo Logfile for the Standby Database - (Video)
Step2: Add Standby Redo Logfile for the RAC Primary Database - (Video)
Step3: Configure LOG_ARCHIVE_DEST_n on the RAC Primary - (Video)
Step4: Configure LOG_ARCHIVE_DEST_n on the Standby Database - (Video)
Step5: Start Redo Apply on the Standby Database - (Video)
Step6: Change the Protection Mode on the RAC Primary - (Video)
Step7: Start Remote Archiving and Verify Protection Mode - (Video)
6.3 Downgrading the Protection Mode - (Video)
Step1: Configure LOG_ARCHIVE_DEST_n on the RAC Primary - (Video)
Step2: Configure LOG_ARCHIVE_DEST_n on the Standby Database - (Video)
Stop3: Drop any Standby Redo Logs from the Standby Database (Optional) - (Video)
Step4: Start Redo Apply on the Standby Database - (Video)
Step5: Change the Protection Mode on the RAC Primary - (Video)
Step6: Drop any Standby Redo Logs from the RAC Primary(Optional) - (Video)
Step7: Start Remote Archiving and Verify Protection Mode - (Video)
7. Role Transition - Switchover and Failover
7.1 Performing Switchover with racnode1 and maanode1 - (Video)
Step 1: Shutdown any additional instances on the RAC Primary/Standby - (Video)
Step 2: Verify the switchover status on the RAC Primary - (Video)
Step 3: Convert the RAC Primary database into a RAC Physical Standby - (Video)
Step 4: Shut down and restart the former RAC Primary as a new standby - (Video)
Step 5: Verify the switchover status on the old RAC standby - (Video)
Step 6: Convert the RAC standby to a RAC primary database - (Video)
Step 7: Shut down and restart the new RAC Primary database - (Video)
Step 8: Start other instance on the new RAC Standby - (Video)
Step 9: Start Redo Apply on the new RAC Physical Standby - (Video)
Step 10: Start Redo Apply on the non-RAC Physical Standby - (Video)
Step 11: Verifying the RAC Standby and Single-instance Primary - (Video)
7.2 Performing Switchover with maanode1 and racnode1 - (Video)
Step 1: Shutdown any additional instances on the RAC Primary/Standby - (Video)
Step 2: Verify the switchover status on the RAC Primary - maanode1 - (Video)
Step 3: Convert the RAC Primary database into a RAC Physical Standby - (Video)
Step 4: Shut down and restart the former RAC Primary as a new standby - (Video)
Step 5: Verify the switchover status on the old RAC standby -racnode1 - (Video)
Step 6: Convert the RAC standby to a RAC primary database - (Video)
Step 7: Shut down and restart the new RAC Primary database - (Video)
Step 8: Start other instance on the new RAC Standby - (Video)
Step 9: Start Redo Apply on the new RAC Physical Standby - (Video)
Step 10: Start Redo Apply on the non-RAC Physical Standby - (Video)
Step 11: Verifying the RAC Standby and Single-instance Primary - (Video)
7.3 Performing Switchover with racnode1 and xmsinglenode - (Video)
Step 1: Shutdown any additional instances on the RAC Primary - (Video)
Step 2: Verify the switchover status on the RAC Primary - (Video)
Step 3: Convert the primary database into a physical standby - (Video)
Step 4: Shut down and restart the old primary as a new standby. - (Video)
Step 5: Verify the switchover status on the old standby - xmsingle - (Video)
Step 6: Convert the standby to a primary database - (Video)
Step 7: Shut down and restart the new primary database - (Video)
Step 8: Start other instance on the new RAC standby - (Video)
Step 9: Start Redo Apply on the new RAC standby - (Video)
Step 10: Start Redo Apply on the RAC standby - (Video)
Step 11: Verifying the RAC Standby and non-RAC Primary - (Video)
7.4 Performing Switchover with xmsinglenode and racnode1 - (Video)
Step 1: Shutdown any additional instances on the RAC Standby - (Video)
Step 2. Verify the switchover status on the non-RAC Primary - (Video)
Step 3. Convert the non-RAC primary database into a physical standby - (Video)
Step 4. Shut down and restart the old primary as a new standby - (Video)
Step 5. Verify the switchover status on the old RAC standby - (Video)
Step 6. Convert the standby to a primary database - (Video)
Step 7. Shut down and restart the new RAC primary database - (Video)
Step 8. Start other instance on the new RAC Primary - (Video)
Step 9. Start Redo Apply on the new non-RAC Standby Database - (Video)
Step 10. Start Redo Apply on the RAC Physical Standby Database - (Video)
Step 11. Verifying the RAC Primary and non-RAC Standby Database - (Video)
7.5 Performing Failover to RAC Physical Standby Database - (Video)
Step 1: Resolve any gaps that may exist on the standby database - (Video)
Step 2. Flashing back the failed RAC primary database - (Video)
Step 3. Convert the failed RAC Primary to a RAC physical standby - (Video)
Step 4: Shut down and restart the new RAC standby database - (Video)
Step 5: Convert the RAC standby into a new primary database - (Video)
Step 6: Restart the new RAC Primary database - (Video)
Step 7. Start Redo Apply on the non-RAC Standby Database - (Video)
Step 8: Verifying the New RAC Primary and non-RAC Standby Database - (Video)
7.6 Using Flashback Database After a Failover - (Video)
Step1. Determine the SCN at which the old standby database became the primary - (Video)
Step2. Flashing back the failed RAC primary database - (Video)
Step3. Convert the failed RAC Primary to a RAC physical standby - (Video)
Step4: Shut down and restart the new RAC standby database - (Video)
Step5. Restart transporting redo to the new RAC physical standby - (Video)
Step6. Start Redo Apply on the New RAC Standby - (Video)
Step7. Verify the new RAC standby database - (Video)
Step8. Performing Switchover with maanode1 and racnode1 - (Video)
8. Oracle 10gR2 Data Guard Broker
8.1 Overview of Oracle Data Guard Broker - ()
8.2 Configuring Data guard Broker - (Video)
Step1: Stop the MRP on standby database if necessary - (Video)
Step2: Modify the listener.ora files - (Video)
Step3: Modify the DataGuard Broker related init parameters - (Video)
Step4: Create Configuration - (Video)
Step5: Enable Configuration - (Video)
Step6: Verify Configuration - (Video)
8.3 Changing the State of a Database - (Video)
8.4 Start / Stop RAC and Data Guard with Broker - ()
8.5 Managing Data Protection Modes - ()
8.6 Upgrading the Protection Mode - (Video)
Step1: Set up standby redo log files if necessary - (Video)
Step2: Set the LogXptMode configurable database property, if necessary - (Video)
Step3: Set the protection mode - (Video)
Step4: Update the LogXptMode property for Primary Database - (Video)
8.7 Downgrading the Protection Mode - (Video)
Step1: Query if Standby Redo Logs exit on the Standby - (Video)
Step2: Set the LogXptMode configurable database property, if necessary - (Video)
Step3: Set the protection mode - (Video)
Step4: Update the LogXptMode property for Primary Database - (Video)
8.8 Removing the Broker - (Video)
Step1: Remove Broker configuration using DGMGRL - (Video)
Step2. Set the DG_BROKER_START to FALSE using SQL*PLUS - (Video)
Step3. Delete the two Broker configuration files from disk - (Video)
9. Role Transition - Switchover and Failover using Broker
9.1 Introduction to Role Transition - ()
9.2 Flashback Technologies and Data Guard - ()
9.3 Preparatory Checks before a Switchover - (Video)
9.4 Performing a Switchover with racdb and maadb 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.5 Performing a Switchover with maadb and racdb 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.6 Performing a Switchover with racdb and xmsingle 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.7 Performing a Switchover with xmsingle and racdb 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.8 Performing a Manual Failover Operation - (Video)
Step 1: Connect to the target standby database - (Video)
Step 2: Issue the failover command - (Video)
Step 3: Show the configuration - (Video)
Step 4: Show StatusReport property of the new primary database - (Video)
Step 5: Show the database - (Video)
9.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)
9.10 Performing a Switchover with maadb and racdb 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)
10. Fast-Start Failover - Automatic Failover
10.1 Fast-Start Failover Architecture - ()
10.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: Enable Flashback Database if necessary - (Video)
Step 7: Start the observer - (Video)
Step 8: Enable fast start failover - (Video)
Step 9: Verify the fast-start failover configuration - (Video)
10.3 Initiating a fast-start failover - (Video)
Step1: Stutting down all instances of RAC Primary with abort option - (Video)
Step2: Verify configuration and database after the fast-start failover - (Video)
Step3: Manually Restart the former primary database - (Video)
Step4: Restart the former RAC primary databse again - (Video)
Step5: Verify the configuration - (Video)
Step6: Reinstate the former primary database - (Video)
Step7: Solve the Error: ORA-16766: Redo Apply unexpectedly offline - (Video)
10.4 Disabling Fast-Start Failover - ()
10.4.1 Conditions Requiring the FORCE Option - ()
10.4.2 Disabling Fast-Start Failover Using Enterprise Manager - ()
10.4.3 Disabling Fast-Start Failover Using DGMGRL - (Video)
10.5 Performing a Switchover with maadb and racdb 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)
11. Managing Physical Standby and Logical Standby Database
11.1 Downgrading to Maximum Performance if necessary - (Video)
Step1: Query if Standby Redo Logs exit on the Standby - (Video)
Step2: Set the LogXptMode configurable database property, if necessary - (Video)
Step3: Set the protection mode - (Video)
Step4: Update the LogXptMode property for Primary Database - (Video)
11.2 Removing the Data Guard Broker - (Video)
Step1: Remove Broker configuration using DGMGRL - (Video)
Step2. Set the DG_BROKER_START to FALSE using SQL*PLUS - (Video)
Step3. Delete the two Broker configuration files from disk - (Video)
11.3 Creating a non-RAC Logical Standby Database - (Video)
Step1: Create a Physical Standby Database - (Video)
Step2: Stop Redo Apply on the Physical Standby Database - (Video)
Step3: Build a Dictionary in the Redo Data - (Video)
Step4: Verify Supplemental Logging is Enable on the Primary and Standby - (Video)
Step5: Convert to a Logical Standby Database - (Video)
Step6: Adjust Initialization Parameters for the Logical Standby Database - (Video)
Step7: Adjust Initialization Parameters for the RAC Primary Database - (Video)
Step8: Adjust Initialization Parameters for the RAC Standby Database - (Video)
Step9: Mount the New Logical Standby Database - (Video)
Step10: Open the New Logical Standby Database - (Video)
Step11: Start SQL Apply on the Logical Standby Database - (Video)
Step12: Start Redo Apply on the Physical Standby Database - (Video)
Step13: Verify the Logical Standby and Physical Standby Database - (Video)
11.4 Start / Shop the Primary and Physical / Logical Standby - (Video)
12. Role Transition - Switchover and Failover not using Broker
12.1 Performing Switchover with racnode1 and maanode1 - (Video)
Step 1: Shutdown any additional instances on the RAC Primary/Standby - (Video)
Step 2: Verify the switchover status on the RAC Primary - (Video)
Step 3: Convert the RAC Primary database into a RAC Physical Standby - (Video)
Step 4: Shut down and restart the former RAC Primary as a new standby - (Video)
Step 5: Verify the switchover status on the old RAC standby - (Video)
Step 6: Convert the RAC standby to a RAC primary database - (Video)
Step 7: Shut down and restart the new RAC Primary database - (Video)
Step 8: Start other instance on the new RAC Standby - (Video)
Step 9: Start Redo Apply on the new RAC Physical Standby - (Video)
Step 10: Verifying the Primary and Physical/Logical Standby Databases - (Video)
Step 11: Verify SQL Apply - (Video)
12.2 Performing Switchover with maanode1 and racnode1 - (Video)
Step 1: Shutdown any additional instances on the RAC Primary/Standby - (Video)
Step 2: Verify the switchover status on the RAC Primary - maanode1 - (Video)
Step 3: Convert the RAC Primary database into a RAC Physical Standby - (Video)
Step 4: Shut down and restart the former RAC Primary as a new standby - (Video)
Step 5: Verify the switchover status on the old RAC standby -racnode1 - (Video)
Step 6: Convert the RAC standby to a RAC primary database - (Video)
Step 7: Shut down and restart the new RAC Primary database - (Video)
Step 8: Start other instance on the new RAC Standby - (Video)
Step 9: Start Redo Apply on the new RAC Physical Standby - (Video)
Step 10: Verifying the Primary and Physical/Logical Standby Databases - (Video)
13. Managing Physical/Logical Standby Using Broker
13.1 Configuring Data guard Broker - (Video)
Step 1: Stop the Redo Apply and SQL Apply on standby 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)
13.2 Start / Stop RAC and Data Guard with Broker - ()
13.3 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)
13.4 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)
13.5 Performing a Switchover with racdb and maadb 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)
13.6 Performing a Switchover with maadb and racdb 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)
13.7 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: Enable Flashback Database if necessary - (Video)
Step 7: Start the observer - (Video)
Step 8: Enable fast start failover - (Video)
Step 9: Verify the fast-start failover configuration - (Video)
13.8 Initiating a fast-start failover - (Video)
Step 1: Stutting down all instances of RAC Primary 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 RAC primary database again - ONLY one instance - (Video)
Step 5: Verify the configuration - (Video)
Step 6: Reinstate the former primary database - (Video)
Step 7: Solve the Error: ORA-16766: Redo Apply unexpectedly offline - (Video)
13.9 Performing a Switchover with maadb and racdb 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)
13.10 Disabling Fast-Start Failover - (Video)
13.11 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)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26664718/viewspace-716168/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26664718/viewspace-716168/