Big talk Oracle_rac: clustering, high availability, backup and recovery PDF

: Network Disk Download

Content IntroductionEditThe book is divided into two parts, a total of 14 chapters, the first part is the cluster theory, this part from the basic knowledge of the cluster, through the analysis of the cluster environment and the different single-machine environment, introduced the cluster environment of the various components and their role, as well as some of the cluster environment of the proprietary technology, including Oracleclusterware, Oracledatabase, ASM, cachefusion and so on. The second part is the practice, each chapter is a knowledge point for RAC to explain, including oracleclusterware maintenance, ha and lb, backup, recovery, flashback family, RAC and Dataguard combined use, RAC and stream combined use , finally the ASM is introduced in depth, and the guiding ideology of performance adjustment is given. "Big Oraclerac cluster, high availability, backup and recovery" in accordance with the "Discovery problem → solve the problem → practice and theory," the way to introduce, first of all to analyze the real problem, and then provide the appropriate solution, and finally naturally lead to the theoretical knowledge of Oracle points, This method can effectively reduce the difficulty of reading, and help readers to better grasp the relevant skills. Author Profile Editor Zhang Xiaoming Oracleogp, now using the net name "Stone Dog", the name from the "and Buddha Flowers to go" in the story: The dog will go out of a thing Mao and chase, may be a bone, a piece of meat, a look. Even a stone. Caution Be sure to see what you are chasing. In the late 90, he graduated from a famous medical university and was assigned to a famous hospital for the sacred work of saving lives after graduation. Unfortunately, in the last year of the university internship I came into contact with the old 486, which let me dream department, coupled with the IT craze to a passionate young people of great temptation, I finally after 3 years of practicing medicine sharpened the head into the IT industry. Back then, there are several good friends from the famous medical colleges and I like to join the IT engineer team, do not know these friends now Ann? I was in the IT industry initially to do development, has used C, C + +, Java and other mainstream and non-mainstream language, enthusiastic participation. C + + and Java Web-earth melee, now in retrospect only one word evaluation "naïve", not only their own naïve, the whole industry is not too mature. After the transfer of database development, and then into the database management, and eventually set this as their career direction. Today, I have documented the learning and use of Oracle databases over the years as a summary of my own and shared with all like-minded friends. is currently a SP company database team Leader, responsible for the management of more than 20 provinces and cities in the country's OLTP and the company's TB-level OLAP system development, optimization and protection. Proficient in database management, backup, recovery, pit disaster design and planning, especially high-availability, high-concurrency, high-pressure database environment design and optimization. Catalog editing 1th cluster theory 1th chapter RAC First Experience 1.1 book use environment 1.1.1 Hardware environment 1.1.2 Software Environment 1.1.3 Use environment 1.2 How to build RAC environment on PC 1.2.1 Download software 1.2.2 Installation Process 1.3 Task List 1.4 Planning Phase 1.4.1 Confirm Master Machine name and 3 IP address 1.4.2 Storage Scheme selection 1.5 implementation phase 1.5.1 Host configuration 1.5.2 Install OracleClusterware1.5.3 install OracleDatabase1.5.4 configuration Listener1.5.5 Create ASM1.5.6 CREATE DATABASE 1.6 customers -End Test 1.6.1 Client Configuration 1.6.2 Experience Failover1.6.3 experience LoadBalance1.6.4 Modifying archive mode 2nd what is the special problem of RAC Cluster 2.1 cluster Classification 2.2 cluster Environment 2.2.1 concurrency control 2.2.2 Amnesia (amnesia) 2.2.3 brain fissure (splitbrain) 2.2.4IO Isolation (iofencing) 2.3RAC cluster 2.3.1 Storage layer 2.3.2 Network layer 2.3.3 Set groupware layer 2.3.4 Application Layer 2.4 Summary 3rd Chapter Oracleclusterware3.1clusterware and RAC relationship 3.2OracleClusterware composition 3.2.1 Disk File 3.2 .2Clusterware Background Process 3.2.3 Network components 3.3Clusterware Log System 3.4 Summary 4th RAC Principle 4.1 Database Fundamentals 4.1.1 concurrency access and data consistency 4.1.2 transaction and isolation levels 4.1.3Oracle supported isolation levels 4.2Oracl concurrency control mechanism for single-instance 4.2.1lock4.2.2 data records row-level lock 4.2.3latch4.2.4latch and lock contrast 4.2.5 further understand concurrency control under 4.3RAC 4.3.1DLM resources and locks 4.3.2non-cachefusion resources 4.3 .3CacheFusion Resource 4.3.4GRD (globalresourcedirectory) 4.3.5pcmlock4.3.6cachefusion4.3.7rac Concurrency control Summary 4.4RAC architecture 4.4.1SGA Changes 4.4.2 background process changes 4.4.3 file 4.4.4scn4.4.5cachefusion, GCS, Ges4.5rac and Clusterware interaction 4.5.1Clusterware Layer 4.5.2RAC Layer 4.6 Summary 5th Chapter storage Scheme-- ASM Preliminary 5.1shared-disk and shared-nothing architecture 5.2oracle10grac Storage Scenarios Description 5.3ASM Architecture 5.3.1ASM Instance 5.3.2 File 5.4 Configure ASM5.4.1 Installation location 5.4.2 Create ASM disk 5.4.3 Configure as M instance 5.4.4 creating a disk group 5.4.5 using ASM Disk Group 5.5ASM instances in the database: migrating the database to ASM5.5.1 test instructions 5.5.2 Steps 5.5.3 Final Verification 5.6 Summary 2nd part of the actual combat Chapter 6th RAC Maintenance toolset 6.1OracleClusterware Toolset 6.2 node Layer 6.3 Network Layer 6.4 cluster Layer 6.4.1CRSCTL6.4.2OCR command Series 6.5 application layer 6.5.1CRS_STAT6.5.2Onsctl6.5.3srvctl6.5.4 Recovery 6.6 Summary of 7th HA and LB7.1 what is high availability 7.2failover7.2.1client-sideconnecttimefailover7.2.2taf ( Transparentapplicationfailover) Controlled trials of 7.2.3client-sidefailover and TAF 7.2.4server-sidetaf7.3oracleclusterwareha Framework 7.3.1 Terminology Introduction 7.3.2 configuration commands 7.3.3 Full instance 7.4loadbalance7.4 .1connectionbalancing7.4.2 leverage Service distributed load 7.5 test LoadBalance7.5.1 route Source 7.5.2 test method by listener Log 7.5.3 test Procedure 7.6 Summary 8th Backup 8.1 Overview 8.1.1 Backup 8.1 .2 Recovery 8.1.3RMAN Tool 8.2 Using FlashRecoveryArea8.2.1 configuration Flashrecoveryarea8.2.2flashrecoveryarea Space Monitoring 8.3 Use of Rman8.3.1rman tools 8.3.2RMA N Configure 8.4 Full backups and incremental backups 8.4.1 full backup 8.4.2 Incremental backup 8.4.3 additional Rman command 8.5RAC Backup Instance 8.6 Summary 9th Recovery 9.1 Why the Oracle database can recover 9.2 log 9.2.1 Log threads ( Redothread) 9.2.2RAC of online log 9.3 Recovery type 9.3.1instancerecovery9.3.2mediarecovery9.3.3crashrecovery9.3.4onlineblockrecovery9.4 Media recovery 9.4.1 Full recovery 9.4 .2 Incomplete recovery 9.4.3 Recovery to Single Instance 9.5 summary 10th Other recovery Techniques 10.1 data Block recovery 10.2 How to check data block consistency 10.2.1 using initialization parameters 10.2.2DBV Tool 10.2.3Analyze command 10.2.4RMAN tool 10.2.5dbms _repair Package 10.3 Analog block inconsistency 10.4 data block inconsistent processing method 10.4.1 collect information 10.4.2 design recovery Methods 10.4.3 Recovery operation 10.5 Data Block recovery instance 10.6Flashback family Introduction 10.7flashbackdatabase10.7.1 Flashbackdatabase Schema 10.7.2 Enable flashbackdatabase10.7.3flashbackdatabase10.7.4 command and view 10.8flashbackdrop10.8.1tablespacerecyclebin10.8.2flashbackdrop operation 10.8.3RecyclyBi n Maintenance of 10.9FlashbackQuery and flashbacktable10.9.1oracle9i Flashbackquery10.9.2flashbackversionquery10.9.3flashbacktransactionqu ERY10.9.4FLASHBACKTABLE10.9.5UNDORETNTION10.10 Summary 11th RAC and Dataguard11.1dataguard Introduction 11.1.1DataGuard architecture 11.1.2 Log Send ( Redosend) 11.1.3 log receive (redoreceive) 11.1.4 log app (redoapply) 11.1.5 Data protection mode 11.1.6 automatic crack detection and resolution 11.2RAC and standby configuration examples 11.2.1RACPrimary and singlestandby11.2.2racprimary and RACStandby11.3 summary 12th chapter RAC and Stre How Amreplication12.1stream works 12.2DataGuard and stream vs. 12.3RACStream configuration instance 12.3.1Single (Source) and RAC (Target) 12.3.2RAC replication of RAC 12.3.3STRMMON Tools 12.4 Summary 13th chapter in-depth ASM13.1 non-ASM storage structure 13.2ASM storage structure 13.3ASM file system 13.3.1asmmetadata13.3.2physicalmetadata1 3.3.3virtualmetadata13.3.4diskrecovery13.4 Stripe (asmstriping) 13.4.1ASM file Template (asmfiletemplate) 13.4.2ASM alias ( Asmfilealias) Interaction between 13.5RDBMS and ASM 13.6ASM Instance restores the interaction between 13.7ASM and Osfilesystem 13.7.1dbms_file_ Transfer package 13.7.2RMAN The Convert method 13.7.3ASM and Tts13.8asm Limitations 13.9 Summary 14th Chapter performance and RAC14.1RSeveral features of AC 14.2awr14.2.1 enable AWR14.2.2 modify AWR configuration 14.2.3 generate AWR report 14.3ash14.4sql adjust policy 14.4.1SQL statement execution Process 14.4.2SQL Performance Tuning Basic method 14.4.3PL Summary of/sql and SQL14.5

: Network Disk Download

Big talk Oracle_rac: clustering, high availability, backup and recovery PDF