Oracle 10g/11g RAC, DataGuard实战环境
请加入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 Database 11gR1 High Availability with
RAC and Data Guard on Linux
1. Building an Oracle RAC 11gR1 for RAC Primary Database
1.1 Install Linux OS(CentOS 5.3)
1.2 Install Required Linux Packages for Oracle RAC
1.3 Network Configuration
1.4 Create "oracle" User and Directories
1.5 Configure the Linux Servers for Oracle
1.6 Configure the "hangcheck-timer" Kernel Module
1.7 Configure RAC Nodes for Remote Access using SSH
1.8 IP SAN Configuration - Openfiler
1.9 Install Openfiler
1.10 Configure iSCSI Volumes using openfiler
1.11 Configure iSCSI Volumes on Oracle RAC Nodes
1.12 Install and configure Oracle Cluster File System(OCFS2)
1.13 Install and Configure ASM (ASMLib2.0)
1.14 Download Oracle RAC 11g Software
1.15 Pre-Installation Tasks for Oracle Clusterware 11g
1.16 Install Oracle Clusterware 11gR1 Software
1.17 Install and configure Automatic Storage Management (ASM)
1.18 Install Oracle Database 11gR1 Software
1.19 Install Oracle Database 11gR1 Examples(formerly Companion)
1.20 Create Oracle TNS Listener
1.21 Configure and Start ASM Instances
1.22 Install the Enterprise Manager agent on each cluster node
1.23 Create a Cluster Database
1.24 Post-Installation Tasks - (Optional)
1.24.1 Re-compile Invalid Objects
1.24.2 Enabling Archive Logs and Flashback in a RAC Environment
1.24.3 Create Shared Oracle Password Files
1.24.4 Create RAC Services in Oracle 11gR1
1.24.5 Download and Install Custom Oracle Database Scripts - (Optional)
1.25 Verify TNS Networking Files
1.26 Create / Alter Tablespaces
1.27 Verify the RAC Cluster and Database Configuration
1.28 Verify Cluster Network Configuration
1.29 Verify Cluster Components
1.30 Starting / Stopping the RAC Clusters
1.31 Configure the Initialization Parameters
2. Building an Oracle RAC 11gR1 for RAC Standby Database
2.1 Install Linux OS(CentOS 5.3)
2.2 Install Required Linux Packages for Oracle RAC
2.3 Network Configuration
2.4 Create "oracle" User and Directories
2.5 Configure the Linux Servers for Oracle
2.6 Configure the "hangcheck-timer" Kernel Module
2.7 Configure RAC Nodes for Remote Access using SSH
2.8 Configure iSCSI Volumes using openfiler
2.9 Configure iSCSI Volumes on Oracle RAC Nodes
2.10 Install and configure Oracle Cluster File System(OCFS2)
2.11 Install and Configure ASM (ASMLib2.0)
2.12 Download Oracle RAC 11gR1 Software
2.13 Pre-Installation Tasks for Oracle Clusterware 11gR1
2.14 Install Oracle Clusterware 11g Release 1
2.15 Install and configure Automatic Storage Management (ASM)
2.16 Install Oracle Database Software 11g Release 1
2.17 Install Oracle Database 11g Examples(formerly Companion)
2.18 Create TNS Listener Process
2.19 Create ASM Instance and ASM Disk Group
2.20 Install the Enterprise Manager agent on each cluster node
2.21 Create the Oracle Cluster Database
2.22 Post-Installation Tasks - (Optional)
2.23 Verify TNS Networking Files
2.24 Create / Alter Tablespaces
2.25 Verify the RAC Cluster and Database Configuration
2.26 Starting / Stopping the Cluster
3. Building a non-RAC Database 11gR1 for Standby Database
3.1 Install the Linux OS (CentOS 5.3)
3.2 Install Required Linux Packages for Oracle
3.3 Operating System Configuration
3.4 Network Configuration
3.5 Create "oracle" User and Directories
3.6 Download the Oracle Database 11g Release 1 Software
3.7 Install the Oracle Database 11g Release 1 Software
3.8 Install the Oracle Database 11g Examples
3.9 Create TNS Listener Process
3.10 Install the Enterprise Manager agent
3.11 Create the Oracle Database
3.12 Post-Installation Tasks
3.13 Verify TNS Networking Files
4. Configure RAC Primary and RAC / non-RAC Physical Standby
4.1 Configure the RAC Primary Database
Step 1: Enable Archive Mode with the FLASHBACK option enabled
Step 2: Create Shared Oracle Password Files
Step 3: Enable Force Logging
Step 4: Create Standby Redo Logs
Step 5: Configure Oracle Net Components on the RAC Primary Database
Step 6: Configure Initialization Parameters on the RAC Primary Database
Step 7: Create a Backup of the Primary Database
Step 8: Update /etc/hosts file on all nodes and Verify Network
4.2 Configure the RAC Standby Database
Step 1: Enable Archive Mode with the Flashback option enabled
Step 2: Enable Force Logging
Step 3: Create Shared Oracle Password Files
Step 4: Copy the primary database password file to all physical standby databases
Step 5: Create Directories on the Standby Host
Step 6: Transfer the files to the Standby Host
Step 7: Create a spfile for the RAC Standby Instance
Step 8: Configure Oracle Net Components on the RAC Standby Database
Step 9: Startup Standby Database nomount
Step 10: Create the RAC Physical Standby Database
Step 11: Start mount the RAC Physical Standby Database
Step 12: Add Standby Redo Logs for the RAC Physical Standby Database
Step 13: Add RAC Standby Database and Instances to the OCR
Step 14: Start Redo Apply on the RAC Physical Standby Database
Step 15: Verify the RAC Primary and RAC Standby
Step 16: Enabling and Disabling the Active Dataguard
Step 17: Enabling Flashback Database on the RAC Physical Standby
4.3 Configure the non-RAC Physical Standby Database
Step 1: Enable Archivelog Mode
Step 2: Enable Force Logging
Step 3: Create the Standby Password File
Step 4: Create Directories on the Standby Host
Step 5: Transfer the files to the standby host
Step 6: Create a spfile for the Standby Instance
Step 7: Configure Oracle Net Components on the non-RAC Standby
Step 8: Startup Standby Database nomount
Step 9: Create the Single Physical Standby Database
Step 10: Start the standby database.
Step 11: Add Standby Redo Logs for the Standby Database
Step 12: Start Redo Apply on the Standby Database
Step 13: Verify the RAC Primary and non-RAC Standby
Step 14: Enabling and Disabling the Active Dataguard
Step 15: Enabling Flashback Database on the non-RAC Physical Standby
5. Manging Physical and Snapshot Standby Databases
5.1 Start / Stop RAC Primary and RAC Standy & non-RAC Standby
5.2 Physical Standby—Open Read-Only
5.3 Managing a Snapshot Standby Database
6. Upgrading and Downgrading the Protection Mode
6.1 Data Guard Protection Modes
6.2 Upgrading the Protection Mode
Step 1: Add standby redo logfile for the Standby Database
Step 2: Add standby logfile for the RAC Primary Database
Step 3: Configure LOG_ARCHIVE_DEST_n on the RAC Primary
Step 4: Configure LOG_ARCHIVE_DEST_n on the Standby Database
Step 5: Start Redo Apply on the Standby Database
Step 6: Change the Protection Mode on the RAC Primary
Step 7: Start Remote Archiving and Verify Protection Mode
6.3 Downgrading the Protection Mode
Step 1: Configure LOG_ARCHIVE_DEST_n on the RAC Primary
Step 2: Configure LOG_ARCHIVE_DEST_n on the Standby Database
Step 3: Drop any Standby Redo Logs from the Standby Database(Optional)
Step 4: Start Redo Apply on the Standby Database
Step 5: Change the Protection Mode on the RAC Primary
Step 6: Drop any Standby Redo Logs from the RAC Primary(Optional)
Step 7: Start Remote Archiving and Verify Protection Mode
7. Role Transition - Switchover and Failover
7.1 Performing Switchover with racnode1 and maanode1
Step 1: Shutdown any additional instances on the RAC Primary/Standby
Step 2: Verify the switchover status on the RAC Primary
Step 3: Convert the RAC Primary database into a RAC Physical Standby
Step 4: Shut down and restart the former RAC Primary as a new standby
Step 5: Verify the switchover status on the old RAC standby
Step 6: Convert the RAC standby to a RAC primary database
Step 7: Shut down and restart the new RAC Primary database
Step 8: Start other instance on the new RAC Standby
Step 9: Start Redo Apply on the new RAC Physical Standby
Step 10: Start Redo Apply on the non-RAC Physical Standby
Step 11: Verifying the RAC Standby and Single-instance Primary
7.2 Performing Switchover with maanode1 and racnode1
Step 1: Shutdown any additional instances on the RAC Primary/Standby
Step 2: Verify the switchover status on the RAC Primary - maanode1
Step 3: Convert the RAC Primary database into a RAC Physical Standby
Step 4: Shut down and restart the former RAC Primary as a new standby
Step 5: Verify the switchover status on the old RAC standby -racnode1
Step 6: Convert the RAC standby to a RAC primary database
Step 7: Shut down and restart the new RAC Primary database
Step 8: Start other instance on the new RAC Standby
Step 9: Start Redo Apply on the new RAC Physical Standby
Step 10: Start Redo Apply on the non-RAC Physical Standby
Step 11: Verifying the RAC Standby and Single-instance Primary
7.3 Performing Switchover with racnode1 and xmsinglenode
Step 1: Shutdown any additional instances on the RAC Primary
Step 2: Verify the switchover status on the RAC Primary
Step 3: Convert the primary database into a physical standby
Step 4: Shut down and restart the old primary as a new standby.
Step 5: Verify the switchover status on the old standby - xmsingle
Step 6: Convert the standby to a primary database
Step 7: Shut down and restart the new primary database
Step 8: Start other instance on the new RAC standby
Step 9: Start Redo Apply on the new RAC standby
Step 10: Start Redo Apply on the new RAC standby
Step 11: Verifying the RAC Standby and non-RAC Primary
7.4 Performing Switchover with xmsinglenode and racnode1
Step 1: Shutdown any additional instances on the RAC Standby
Step 2. Verify the switchover status on the non-RAC Primary
Step 3. Convert the non-RAC primary database into a physical standby
Step 4. Shut down and restart the old primary as a new standby
Step 5. Verify the switchover status on the old RAC standby
Step 6. Convert the standby to a primary database
Step 7. Shut down and restart the new RAC primary database
Step 8. Start other instance on the new RAC Primary
Step 9. Start Redo Apply on the new non-RAC Standby Database
Step 10. Start Redo Apply on the RAC Physical Standby Database
Step 11. Verifying the RAC Primary and non-RAC Standby Database
7.5 Performing Failover to RAC Physical Standby Database
Step 1: Resolve any gaps that may exist on the standby database
Step 2: Copy and register any other missing archived redo logs
Step 3: Shutdown any additional instances on the RAC Physical Standby
Step 4: Perform terminal recovery on the RAC Physical Standby
Step 5: Convert the RAC standby into a new primary database
Step 6: Restart the new RAC Primary database
Step 7. Start Redo Apply on the non-RAC Standby Database
Step 8: Verifying the New RAC Primary and non-RAC Standby Database
7.6 Using Flashback Database After a Failover
Step 1: Determine the SCN at which the old standby database became the primary database
Step 2: Flashing back the failed RAC primary database
Step 3: Convert the failed RAC Primary to a RAC physical standby
Step 4: Shut down and restart the new RAC standby database
Step 5: Restart transporting redo to the new RAC physical standby
Step 6: Start Redo Apply on the New RAC Standby
Step 7: Verify the new RAC standby database
8. Rebuilding a Physical Standby by Using RMAN Incremental Backups
8.1 Physical Standby Database Lags Far Behind the Primary Database
8.2 Physical Standby Has Nologging Changes On a Subset of Datafiles
8.3 Physical Standby Database Has Widespread Nologging Changes
9. Implementing Oracle Data Guard Broker
9.1 Overview of Oracle Data Guard Broker
9.2 Configuring Data guard Broker
Step 1: Stop the MRP on standby database if necessary
Step 2: Modify the listener.ora files
Step 3: Modify the DataGuard Broker related init parameters
Step 4: Create Configuration
Step 5: Enable Configuration
Step 6: Verify Configuration
9.3 Changing the State of a Database
9.4 Using Active Data Guard - Real-Time Query
9.5 Converting a Physical Standby to a Snapshot Standby
9.6 Start / Stop RAC and Data Guard with Broker
9.7 Managing Data Protection Modes
9.8 Removing the Broker
Step 1: Remove Broker configuration using DGMGRL
Step 2. Set the DG_BROKER_START to FALSE using SQL*PLUS
Step 3. Delete the two Broker configuration fiels from disk
10. Role Transition - Switchover and Failover using Broker
10.1 Introduction to Role Transition
10.2 Flashback Technologies and Data Guard
10.3 Preparatory Checks before a Switchover
10.4 Performing a Switchover from racdb to maadb using Broker
Step 1: Check the primary database
Step 2: Check the standby database that is the target of the switchover
Step 3: Issue the switchover command
Step 4: Show the configuration
10.5 Performing a Switchover from maadb to racdb using Broker
Step 1: Check the primary database
Step 2: Check the standby database that is the target of the switchover
Step 3: Issue the switchover command
Step 4: Show the configuration
10.6 Performing a Switchover from racdb to xmsingle using Broker
Step 1: Check the primary database
Step 2: Check the standby database that is the target of the switchover
Step 3: Issue the switchover command
Step 4: Show the configuration
10.7 Performing a Switchover from xmsingle to racdb using Broker
Step 1: Check the primary database
Step 2: Check the standby database that is the target of the switchover
Step 3: Issue the switchover command
Step 4: Show the configuration
10.8 Performing a Manual Failover Operation
Step 1: Connect to the target standby database
Step 2: Issue the failover command
Step 3: Show the configuration
Step 4: Show StatusReport property of the new primary database
Step 5: Show the database
10.9 Reinstating a Failed Primary Database
Step 1: Restart the Old Primary Database
Step 2: Reinstate the old primary database
Step 3: Reinstate any other standby database
Step 4: Show the Configuration and Databases
11. Fast-Start Failover - Automatic Failover
11.1 Fast-Start Failover Architecture
11.2 Enabling Fast-Start Failover and Starting the Observer
Step 1: Ensure standby redo logs are configured on the primary and target standby databases
Step 2: Ensure the LogXptMode Property is set to SYNC
Step 3: Set the FastStartFailoverTarget configuration property
Step 4: Determine the protection mode you want
Step 5: Set the FastStartFailoverThreshold configuration property
Step 6: Set other database properties (optional)
Step 7: Enable Flashback Database if necessary
Step 8: Start the observer
Step 9: Enable fast start failover
Step 10: Verify the fast-start failover configuration
11.3 When Fast-Start Failover Is Enabled and the Observer Is Running
Step 1: Monitor the environment to ensure the primary database is available
Step 2: Reconnect within the time specified by FastStartFailoverThreshold
Step 3: Verify the target standby database is ready for failover
Step 4: Initiate a fast-start failover
Step 5: Reinstate the former primary database as a new standby database
11.4 Initiate a fast-start failover
Step 1: Stutting down all instances of RAC Primary with abort option
Step 2: Verify configuration and database after the fast-start failover
Step 3: Manually Restart the former primary database
Step 4: Restart the former RAC primary databse again
Step 5: Verify the configuration
Step 6: Reinstate the former primary database
11.5 Disabling Fast-Start Failover
12. Managing Physical Standby and Logical Standby Database
12.1 Creating a non-RAC Logical Standby Database
Step 1: Create a Physical Standby Database
Step 2: Stop Redo Apply on the Physical Standby Database
Step 3: Build a Dictionary in the Redo Data
Step 4: Verify Supplemental Logging is Enable on the Primary and Standby
Step 5: Convert to a Logical Standby Database
Step 6: Adjust Initialization Parameters for the Logical Standby Database
Step 7: Adjust Initialization Parameters for the RAC Primary Database
Step 8: Adjust Initialization Parameters for the RAC Standby Database
Step 9: Mount the New Logical Standby Database
Step 10: Open the New Logical Standby Database
Step 11: Start SQL Apply on the Logical Standby Database
Step 12: Start Redo Apply on the Physical Standby Database
Step 13: Verify the Logical Standby and Physical Standby Database
12.2 Managing and Monitoring SQL Apply using performance views
12.3 SQL Apply Architecture
12.4 Monitoring a Logical Standby Database
12.5 Modifying a Logical Standby Database
12.6 Start / Shop the Primary and Physical / Logical Standby
13. Role Transition - Switchover and Failover not using Broker
13.1 Performing Switchover with racnode1 and maanode1
Step 1: Shutdown any additional instances on the RAC Primary/Standby
Step 2: Verify the switchover status on the RAC Primary
Step 3: Convert the RAC Primary database into a RAC Physical Standby
Step 4: Shut down and restart the former RAC Primary as a new standby
Step 5: Verify the switchover status on the old RAC standby
Step 6: Convert the RAC standby to a RAC primary database
Step 7: Shut down and restart the new RAC Primary database
Step 8: Start other instance on the new RAC Standby
Step 9: Start Redo Apply on the new RAC Physical Standby
Step 10: Verifying the Primary and Physical/Logical Standby Databases
Step 11: Verify SQL Apply
13.2 Performing Switchover with maanode1 and racnode1
Step 1: Shutdown any additional instances on the RAC Primary/Standby
Step 2: Verify the switchover status on the RAC Primary - maanode1
Step 3: Convert the RAC Primary database into a RAC Physical Standby
Step 4: Shut down and restart the former RAC Primary as a new standby
Step 5: Verify the switchover status on the old RAC standby -racnode1
Step 6: Convert the RAC standby to a RAC primary database
Step 7: Shut down and restart the new RAC Primary database
Step 8: Start other instance on the new RAC Standby
Step 9: Start Redo Apply on the new RAC Physical Standby
Step 10: Verifying the Primary and Physical/Logical Standby Databases
14. Managing Primary & Physical/Logical Standby Using Broker
14.1 Configuring Data guard Broker
Step 1: Stop the Redo Apply and SQL Apply on standby if necessary
Step 2: Modify the listener.ora files
Step 3: Modify the DataGuard Broker related init parameters
Step 4: Create Configuration
Step 5: Enable Configuration
Step 6: Verify Configuration
14.2 Start / Stop RAC and Data Guard with Broker
14.3 Upgrading the Protection Mode
Step 1: Set up standby redo log files if necessary
Step 2: Set the LogXptMode configurable database property, if necessary
Step 3: Set the protection mode
14.4 Downgrading the Protection Mode
Step 1: Query if Stadnby Redo Logs exit on the Standby
Step 2: Set the LogXptMode configurable database property, if necessary
Step 3: Set the protection mode
Step 4: Update the LogXptMode property for Primary Database
14.5 Performing a Switchover from racdb to maadb using Broker
Step 1: Check the primary database
Step 2: Check the standby database that is the target of the switchover
Step 3: Issue the switchover command
Step 4: Show the configuration
14.6 Performing a Switchover from maadb to racdb using Broker
Step 1: Check the primary database
Step 2: Check the standby database that is the target of the switchover]
Step 3: Issue the switchover command
Step 4: Show the configuration
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26664718/viewspace-716257/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26664718/viewspace-716257/