"Oracle 12c数据库管理员指南英文版详解及实践指南"

需积分: 0 165 浏览量更新于2024-03-21 收藏 19.06MB PDF 举报

Oracle Database Database Administrator’s Guide, 12c Release 2 (12.2) is a comprehensive guide that provides essential information for Oracle database administrators. This guide, authored by Rajesh Bhatiya and Padmaja Potineni, covers a wide range of topics to help database administrators effectively manage Oracle databases. The guide starts with an introduction to Oracle Database 12c, highlighting the new features and enhancements in this release. It then delves into essential tasks such as installing and configuring an Oracle database, managing database security, and backing up and recovering data. The authors provide detailed instructions on managing database objects such as tables, indexes, and views. They also cover advanced topics such as performance tuning, troubleshooting common issues, and implementing high availability solutions. The guide emphasizes best practices and recommendations to ensure optimal performance and data security. It also includes examples and code snippets to help administrators understand and implement the concepts discussed. Furthermore, the guide is regularly updated to reflect the latest changes and features in Oracle Database, ensuring that administrators have access to up-to-date information. In conclusion, Oracle Database Database Administrator’s Guide, 12c Release 2 (12.2) is a valuable resource for Oracle database administrators looking to enhance their knowledge and skills in managing Oracle databases. It provides practical guidance and insights that can help administrators effectively maintain and optimize their database environments. Whether you are a seasoned DBA or a beginner, this guide is essential for mastering the intricacies of Oracle database administration. For more IT certification courses, please visit the website of美河学习在线 (www.eimhe.com), where you can find a wide range of resources and training materials to support your professional growth in the IT field.

9.1.3.2 Alert Log 9-7

9.1.3.3 Trace Files, Dumps, and Core Files 9-8

9.1.3.4 DDL Log 9-9

9.1.3.5 Debug Log 9-9

9.1.3.6 Other ADR Contents 9-10

9.1.3.7 Enterprise Manager Support Workbench 9-10

9.1.3.8 ADRCI Command-Line Utility 9-10

9.1.4 Structure, Contents, and Location of the Automatic Diagnostic

Repository 9-11

9.2 Investigating, Reporting, and Resolving a Problem 9-15

9.2.1 Roadmap—Investigating, Reporting, and Resolving a Problem 9-16

9.2.2 Task 1: View Critical Error Alerts in Cloud Control 9-18

9.2.3 Task 2: View Problem Details 9-19

9.2.4 Task 3: (Optional) Gather Additional Diagnostic Information 9-20

9.2.5 Task 4: (Optional) Create a Service Request 9-20

9.2.6 Task 5: Package and Upload Diagnostic Data to Oracle Support 9-20

9.2.7 Task 6: Track the Service Request and Implement Any Repairs 9-22

9.3 Viewing Problems with the Support Workbench 9-23

9.4 Adding Problems Manually to the Automatic Diagnostic Repository 9-25

9.5 Viewing the Alert Log 9-26

9.6 Finding Trace Files 9-27

9.7 Running Health Checks with Health Monitor 9-27

9.7.1 About Health Monitor 9-28

9.7.1.1 About Health Monitor Checks 9-28

9.7.1.2 Types of Health Checks 9-29

9.7.2 Running Health Checks Manually 9-30

9.7.2.1 Running Health Checks Using the DBMS_HM PL/SQL Package 9-30

9.7.2.2 Running Health Checks Using Cloud Control 9-31

9.7.3 Viewing Checker Reports 9-31

9.7.3.1 About Viewing Checker Reports 9-31

9.7.3.2 Viewing Reports Using Cloud Control 9-32

9.7.3.3 Viewing Reports Using DBMS_HM 9-32

9.7.3.4 Viewing Reports Using the ADRCI Utility 9-33

9.7.4 Health Monitor Views 9-34

9.7.5 Health Check Parameters Reference 9-35

9.8 Repairing SQL Failures with the SQL Repair Advisor 9-36

9.8.1 About the SQL Repair Advisor 9-36

9.8.2 Running the SQL Repair Advisor 9-37

9.8.3 Viewing, Disabling, or Removing a SQL Patch 9-38

9.9 Repairing Data Corruptions with the Data Recovery Advisor 9-39

9.10 Creating, Editing, and Uploading Custom Incident Packages 9-40

xvi

更多ＩＴ认证课程请访问　美河学习在线　ｗｗｗ．ｅｉｍｈｅ．ｃｏｍ

13.2.3.2 Creating a Bigfile Tablespace 13-9

13.2.3.3 Identifying a Bigfile Tablespace 13-10

13.2.4 Tablespaces with Default Compression Attributes 13-10

13.2.4.1 About Tablespaces with Default Compression Attributes 13-11

13.2.4.2 Creating Tablespaces with Default Compression Attributes 13-11

13.2.5 Encrypted Tablespaces 13-11

13.2.5.1 About Encrypted Tablespaces 13-12

13.2.5.2 Creating Encrypted Tablespaces 13-14

13.2.5.3 Viewing Information About Encrypted Tablespaces 13-14

13.2.6 Temporary Tablespaces 13-15

13.2.6.1 About Temporary Tablespaces 13-15

13.2.6.2 Creating a Locally Managed Temporary Tablespace 13-17

13.2.6.3 Creating a Bigfile Temporary Tablespace 13-18

13.2.6.4 Viewing Space Usage for Temporary Tablespaces 13-18

13.2.7 Temporary Tablespace Groups 13-18

13.2.7.1 Multiple Temporary Tablespaces: Using Tablespace Groups 13-19

13.2.7.2 Creating a Tablespace Group 13-19

13.2.7.3 Changing Members of a Tablespace Group 13-20

13.2.7.4 Assigning a Tablespace Group as the Default Temporary

Tablespace 13-20

13.3 Consider Storing Tablespaces in the In-Memory Column Store 13-20

13.4 Specifying Nonstandard Block Sizes for Tablespaces 13-21

13.5 Controlling the Writing of Redo Records 13-22

13.6 Altering Tablespace Availability 13-23

13.6.1 Taking Tablespaces Offline 13-23

13.6.2 Bringing Tablespaces Online 13-25

13.7 Using Read-Only Tablespaces 13-25

13.7.1 About Read-Only Tablespaces 13-26

13.7.2 Making a Tablespace Read-Only 13-26

13.7.3 Making a Read-Only Tablespace Writable 13-28

13.7.4 Creating a Read-Only Tablespace on a WORM Device 13-29

13.7.5 Delaying the Opening of Data Files in Read-Only Tablespaces 13-29

13.8 Altering and Maintaining Tablespaces 13-30

13.8.1 Increasing the Size of a Tablespace 13-30

13.8.2 Altering a Locally Managed Tablespace 13-30

13.8.3 Altering a Bigfile Tablespace 13-31

13.8.4 Altering a Locally Managed Temporary Tablespace 13-32

13.8.5 Shrinking a Locally Managed Temporary Tablespace 13-33

13.9 Renaming Tablespaces 13-33

13.10 Dropping Tablespaces 13-34

13.11 Managing the SYSAUX Tablespace 13-35

更多ＩＴ认证课程请访问　美河学习在线　ｗｗｗ．ｅｉｍｈｅ．ｃｏｍ

剩余2157页未读，继续阅读

CodeGolang

粉丝: 156
资源: 1435

"Oracle 12c数据库管理员指南 英文版详解及实践指南"

oracle 数据库管理员指南

Oracle 数据库管理员指南

ORACLE数据库管理员指南

Oracle 12c数据库管理员指南：Linux与UNIX系统配置详解

Oracle 12c数据库实例管理指南

Oracle 12c数据库概念入门指南

Oracle 12c数据库性能优化指南

Oracle12c数据库详细安装指南

Oracle 12C数据库完整安装指南

Oracle 12c 数据库OCI编程指南：官方API详解

最新资源

"Oracle 12c数据库管理员指南英文版详解及实践指南"