Oracle DBA Work Note: Operations, data migration, and performance tuning PDF download

One: Download route

Second: The book Drawing

Three: the book catalogue

The 1th chapter of database operation and maintenance
1th. Database Installation Configuration
1.1 Preparation for pre-installation 1
1.2 Installing database Software 5
1.2.1 Method 1:oui Installation 6
1.2.2 Method 2: Silent installation 8
1.2.3 Method 3: Clone installation 11
1.2.4 Diagnostic Case: Unable to log on after cloning installation 13
1.3 Creating/Deleting a Database 16
1.3.1 Method 1:DBCA Graphics Build Library 16
1.3.2 Method 2: Build the library manually 18
1.3.3 Method 3:DBCA Silent Build Library 22
1.3.4 Method 4:OMF Build Library 22
1.3.5 Diagnostic Case: The CREATE DATABASE statement differs in 10g, 11g 23
1.3.6 additional work after creating a database 26
1.3.7 steps to delete a database 29
1.4 About SYSDBA, Sysoper, DBA differences and Contacts 29
The 2nd chapter of common Tools and problems analysis
2.1 Sql*plus Usage and FAQs 34
2.1.1 Sql*plus Use Rule 34
Common causes for 2.1.2 Sql*plus not start 41
Special problem: Garbled sql*plus problems caused by the inability to start 43
Special issue: Use Strace to diagnose strange sql*plus sign-in issues 44
2.2 Parsing Exp/imp and FAQs 47
2.2.1 Exp/imp usage Scenarios and examples 47
2.2.2 Exp/imp Use FAQ 50
Diagnostic Case: Production system exp cannot be used for emergency diagnosis and repair 55
Diagnostic case: Import and export of external tables issue 57
Diagnosis case: IMP-00013 problem and Solution 58
Diagnostic case: Using Strace to analyze the strange problem with buffer set in EXP 60
Experience Sharing: You may not understand the dump file 63
2.3 Parsing DataPump and FAQs 66
2.3.1 DataPump Usage Scenarios and examples 66
2.3.3 a few words to analyze how DataPump works 68
Diagnostic case: IMPDP problems caused by abnormal interrupts 70
Diagnostic Case: Data loss due to improper use of the IMPDP option 73
3rd Chapter Service Connection Configuration
3.1 Introduction to listening configuration and client Configuration 76
3.2 Network Service Configuration 78
3.2.1 Network configuration rules and practices 78
Diagnostic case: The problem and cause of failure of session tracking 82
3.2.2 Monitoring configuration file format--The power of a space 84
Configuration of the TAF in the 3.2.3 RAC 88
Configuration of scan in 3.2.4 RAC 90
3.2.5 simulating a RAC connection with a single-case mode 93
3.3 Reasons why the listener cannot start 94
Diagnostic case: Use Strace to analyze TNS-12543 case 96
4th. Database start/stop and outage issues
4.1 Database Start-Stop problem analysis 99
4.2 Database failed to start case 100
Diagnostic case: Incorrect database parameter setup causes a problem that cannot be started 100
Diagnostic case: Problems and solutions for servers that cannot restart the database after adding memory 102
Diagnostic case: Issues that fail to start after database shutdown 103
Diagnostic case: ORA-29702 Problems and analysis of RAC nodes that fail to start 105
Diagnostic case: Consecutive RAC node issues 108
4.3 database could not log on problem analysis 110
4.4 Database cannot log in case 111
Diagnostic Case: Database Unable to log on due to insufficient archive space 111
Diagnostic case: Session leak caused database failed to log on issue 115
Diagnostic Case: Database failed to log on due to undo missing 118
4.5 Database outage problems and cause analysis 119
4.6 Database outage problem Case 119
Diagnostic Case: Database outage problems and analysis caused by an SQL statement 119
Diagnostic Case: Storage-led database outage problems and analysis 121
Diagnosis Case: Problem and analysis of database sudden outage caused by I/O problem 124
Diagnostic Case: Database causes a sudden outage problem and resolution 126
5th chapter Disaster Tolerance and backup recovery
5.1 Backup recovery applications and practices 132
Four full recovery scenarios in 5.1.1 Archive mode 132
Three incomplete recovery scenarios in 5.1.2 Rman 137
Lab 1: Using handles to implement no backup recovery for a particular scenario 141
Lab 2: Destructive testing of the dual table 145
5.2 Flash back application and practice 149
5.2.1 about Delete, drop, truncate similarities and differences and no backup recovery scenario 149
5.2.2 backing up data using a flashback query 152
5.2.3 using flashback query to intelligently extract the specified data 154
Practical case: Using Flashback database to achieve flexible data rollback 155
Practical case: Using Flashback database flexibly to achieve flexible data switching 156
5.3 Data Guard Construction and application 160
5.3.1 Common Data Guard Vulnerability 161
5.3.2 11g Data Guard Build Practice 163
5.3.3 on the design of Oracle Standby Library 169
5.3.4 Practical First Snapshot standby features 171
Practice case: Several data file issues in the database guard repository 175
Practice Case: Data File Migration in the database guard 179
Diagnostic Case: Oracle BUG 182 caused by drop datafile
Diagnostic Case: Manual repair of an Oracle bug 185
Diagnostic Case: 11g library does not open ADG cause analysis 188
6th chapter monitoring Management and fault handling
6.1 Zabbix, Orabbix introduction 191
6.2 Zabbix Agent Deployment 191
Deployment of 6.3 Orabbix 194
6.4 On the pros and cons of Zabbix and Grid control 197
6.5 Orabbix Custom Monitoring simple configuration of Oracle 198
Practice case: Orabbix to send graphical reports in conjunction with Python 200
Practice case: Configuring data Guard monitoring in Zabbix 205
6.6 Two legs more secure--hardware monitoring is necessary 207
Thinking on the construction of 6.7 operation and maintenance platform--meta data management 209
6.8 Monitoring blind spots and diagnostic cases 210
Monitoring blind spots: A potential monitoring problem caused by dual 210
Diagnostic Case: Standby CPU Usage Exception Optimization 213
Diagnostic Case: Two alarm information combined with analysis of DG Problem 216
Diagnostic case: Monitoring anti-monitoring error--an analysis of a Orabbix alarm 222
Diagnostic case: Customizing monitoring items Quick Location Problem 224
Diagnostic case: Analysis of CPU alarm information 226

Oracle DBA Work Note: Operations, data migration, and performance tuning PDF download