1、<oracle_home>\RDBMS\ADMIN下的oracle自带用于管理数据库的sql脚本,比如,catalog.sql等,在oracle官方文档中的哪里可以查看他们的相关解释?
2、Database Administrator's Guide这本书讲述了数据库管理的各个方面
Oracle® Database Administrator's Guide 11g Release 2 (11.2) E25494-05 |
|
| PDF · Mobi · ePub |
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
What's New in Oracle Database Administrator's Guide?
- Oracle Database 11g Release 2 (11.2.0.3) New Features in the Administrator's Guide
- Oracle Database 11g Release 2 (11.2.0.2) New Features in the Administrator's Guide
- Oracle Database 11g Release 2 (11.2.0.1) New Features in the Administrator's Guide
Part I Basic Database Administration
1 Getting Started with Database Administration
- Types of Oracle Database Users
- Tasks of a Database Administrator
- Task 1: Evaluate the Database Server Hardware
- Task 2: Install the Oracle Database Software
- Task 3: Plan the Database
- Task 4: Create and Open the Database
- Task 5: Back Up the Database
- Task 6: Enroll System Users
- Task 7: Implement the Database Design
- Task 8: Back Up the Fully Functional Database
- Task 9: Tune Database Performance
- Task 10: Download and Install Patches
- Task 11: Roll Out to Additional Hosts
- Submitting Commands and SQL to the Database
- Identifying Your Oracle Database Software Release
- About Database Administrator Security and Privileges
- Database Administrator Authentication
- Creating and Maintaining a Password File
- Data Utilities
2 Creating and Configuring an Oracle Database
- About Creating an Oracle Database
- Creating a Database with DBCA
- Creating a Database with the CREATE DATABASE Statement
- Step 1: Specify an Instance Identifier (SID)
- Step 2: Ensure That the Required Environment Variables Are Set
- Step 3: Choose a Database Administrator Authentication Method
- Step 4: Create the Initialization Parameter File
- Step 5: (Windows Only) Create an Instance
- Step 6: Connect to the Instance
- Step 7: Create a Server Parameter File
- Step 8: Start the Instance
- Step 9: Issue the CREATE DATABASE Statement
- Step 10: Create Additional Tablespaces
- Step 11: Run Scripts to Build Data Dictionary Views
- Step 12: (Optional) Run Scripts to Install Additional Options
- Step 13: Back Up the Database.
- Step 14: (Optional) Enable Automatic Instance Startup
- Specifying CREATE DATABASE Statement Clauses
- Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM
- Creating a Locally Managed SYSTEM Tablespace
- About the SYSAUX Tablespace
- Using Automatic Undo Management: Creating an Undo Tablespace
- Creating a Default Permanent Tablespace
- Creating a Default Temporary Tablespace
- Specifying Oracle Managed Files at Database Creation
- Supporting Bigfile Tablespaces During Database Creation
- Specifying the Database Time Zone and Time Zone File
- Specifying FORCE LOGGING Mode
- Specifying Initialization Parameters
- About Initialization Parameters and Initialization Parameter Files
- Determining the Global Database Name
- Specifying a Fast Recovery Area
- Specifying Control Files
- Specifying Database Block Sizes
- Specifying the Maximum Number of Processes
- Specifying the DDL Lock Timeout
- Specifying the Method of Undo Space Management
- About The COMPATIBLE Initialization Parameter
- Setting the License Parameter
- Managing Initialization Parameters Using a Server Parameter File
- What Is a Server Parameter File?
- Migrating to a Server Parameter File
- Creating a Server Parameter File
- The SPFILE Initialization Parameter
- Changing Initialization Parameter Values
- Clearing Initialization Parameter Values
- Exporting the Server Parameter File
- Backing Up the Server Parameter File
- Recovering a Lost or Damaged Server Parameter File
- Viewing Parameter Settings
- Managing Application Workloads with Database Services
- Considerations After Creating a Database
- Cloning a Database with CloneDB
- Dropping a Database
- Database Data Dictionary Views
3 Starting Up and Shutting Down
- Starting Up a Database
- About Database Startup Options
- Specifying Initialization Parameters at Startup
- About Automatic Startup of Database Services
- Preparing to Start Up an Instance
- Starting Up an Instance
- Starting an Instance, and Mounting and Opening a Database
- Starting an Instance Without Mounting a Database
- Starting an Instance and Mounting a Database
- Restricting Access to an Instance at Startup
- Forcing an Instance to Start
- Starting an Instance, Mounting a Database, and Starting Complete Media Recovery
- Automatic Database Startup at Operating System Start
- Starting Remote Instances
- Altering Database Availability
- Shutting Down a Database
- Quiescing a Database
- Suspending and Resuming a Database
4 Configuring Automatic Restart of an Oracle Database
- About Oracle Restart
- Configuring Oracle Restart
- Preparing to Run SRVCTL
- Obtaining Help for SRVCTL
- Adding Components to the Oracle Restart Configuration
- Removing Components from the Oracle Restart Configuration
- Disabling and Enabling Oracle Restart Management for a Component
- Viewing Component Status
- Viewing the Oracle Restart Configuration for a Component
- Modifying the Oracle Restart Configuration for a Component
- Managing Environment Variables in the Oracle Restart Configuration
- Creating and Deleting Database Services with SRVCTL
- Enabling FAN Events in an Oracle Restart Environment
- Automating the Failover of Connections Between Primary and Standby Databases
- Enabling Clients for Fast Connection Failover
- Starting and Stopping Components Managed by Oracle Restart
- Stopping and Restarting Oracle Restart for Maintenance Operations
- SRVCTL Command Reference for Oracle Restart
- CRSCTL Command Reference
5 Managing Processes
- About Dedicated and Shared Server Processes
- About Database Resident Connection Pooling
- Configuring Oracle Database for Shared Server
- Configuring Database Resident Connection Pooling
- About Oracle Database Background Processes
- Managing Processes for Parallel SQL Execution
- Managing Processes for External Procedures
- Terminating Sessions
- Process and Session Data Dictionary Views
6 Managing Memory
- About Memory Management
- Memory Architecture Overview
- Using Automatic Memory Management
- Configuring Memory Manually
- Using Automatic Shared Memory Management
- Using Manual Shared Memory Management
- Enabling Manual Shared Memory Management
- Setting the Buffer Cache Initialization Parameters
- Specifying the Shared Pool Size
- Specifying the Large Pool Size
- Specifying the Java Pool Size
- Specifying the Streams Pool Size
- Specifying the Result Cache Maximum Size
- Specifying Miscellaneous SGA Initialization Parameters
- Using Automatic PGA Memory Management
- Using Manual PGA Memory Management
- Configuring Database Smart Flash Cache
- Memory Management Reference
7 Managing Users and Securing the Database 用户以及安全
- The Importance of Establishing a Security Policy for Your Database
- Managing Users and Resources
- Managing User Privileges and Roles
- Auditing Database Activity
- Predefined User Accounts
8 Monitoring Database Operations 监控错误和性能
- Monitoring Errors and Alerts
- Monitoring Performance
9 Managing Diagnostic Data
- About the Oracle Database Fault Diagnosability Infrastructure
- Investigating, Reporting, and Resolving a Problem
- Roadmap—Investigating, Reporting, and Resolving a Problem
- Task 1: View Critical Error Alerts in Enterprise Manager
- Task 2: View Problem Details
- Task 3: (Optional) Gather Additional Diagnostic Information
- Task 4: (Optional) Create a Service Request
- Task 5: Package and Upload Diagnostic Data to Oracle Support
- Task 6: Track the Service Request and Implement Any Repairs
- Task 7: Close Incidents
- Viewing Problems with the Enterprise Manager Support Workbench
- Creating a User-Reported Problem
- Viewing the Alert Log
- Finding Trace Files
- Running Health Checks with Health Monitor
- Repairing SQL Failures with the SQL Repair Advisor
- Repairing Data Corruptions with the Data Recovery Advisor
- Creating, Editing, and Uploading Custom Incident Packages
10 Managing Oracle Enterprise Manager Database Control
- Database Control Overview
- Configuring Database Control During and After Installation
- Administering Database Control
- Managing Database Control in an Oracle RAC Environment
- Deleting and Creating Database Control Objects
- Deleting Database Control Objects
- Option 1: Deleting Database Control Configuration Files Using EMCA Scripts
- Option 2: Deleting Database Control Configuration Files and Repository Objects Using An EMCA Script
- Option 3: Deleting A Database Control Repository Using EMCA Scripts
- Option 4: Deleting Database Control Configuration Files Manually
- Option 5: Deleting the Database Control Repository Using RepManager
- Creating Database Control Objects
- Re-Creating Or Reconfiguring Database Control
- Deleting Database Control Objects
- EMCA Troubleshooting Tips
Part II Oracle Database Structure and Storage
11 Managing Control Files 内部结构格式 估计没介绍吧 控制文件
- What Is a Control File?
- Guidelines for Control Files
- Creating Control Files
- Troubleshooting After Creating Control Files
- Backing Up Control Files
- Recovering a Control File Using a Current Copy
- Dropping Control Files
- Control Files Data Dictionary Views
12 Managing the Redo Log
- What Is the Redo Log?
- Planning the Redo Log
- Creating Redo Log Groups and Members
- Relocating and Renaming Redo Log Members
- Dropping Redo Log Groups and Members
- Forcing Log Switches
- Verifying Blocks in Redo Log Files
- Clearing a Redo Log File
- Redo Log Data Dictionary Views
13 Managing Archived Redo Logs
- What Is the Archived Redo Log?
- Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
- Controlling Archiving
- Specifying Archive Destinations
- About Log Transmission Modes
- Managing Archive Destination Failure
- Controlling Trace Output Generated by the Archivelog Process
- Viewing Information About the Archived Redo Log
14 Managing Tablespaces
- Guidelines for Managing Tablespaces
- Creating Tablespaces
- Specifying Nonstandard Block Sizes for Tablespaces
- Controlling the Writing of Redo Records
- Altering Tablespace Availability
- Using Read-Only Tablespaces
- Altering and Maintaining Tablespaces
- Renaming Tablespaces
- Dropping Tablespaces
- Managing the SYSAUX Tablespace
- Diagnosing and Repairing Locally Managed Tablespace Problems
- Scenario 1: Fixing Bitmap When Allocated Blocks are Marked Free (No Overlap)
- Scenario 2: Dropping a Corrupted Segment
- Scenario 3: Fixing Bitmap Where Overlap is Reported
- Scenario 4: Correcting Media Corruption of Bitmap Blocks
- Scenario 5: Migrating from a Dictionary-Managed to a Locally Managed Tablespace
- Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
- Transporting Tablespaces Between Databases
- Introduction to Transportable Tablespaces
- About Transporting Tablespaces Across Platforms
- Limitations on Transportable Tablespace Use
- Compatibility Considerations for Transportable Tablespaces
- Transporting Tablespaces Between Databases: A Procedure and Example
- Using Transportable Tablespaces: Scenarios
- Moving Databases Across Platforms Using Transportable Tablespaces
- Tablespace Data Dictionary Views
15 Managing Data Files and Temp Files
- Guidelines for Managing Data Files
- Creating Data Files and Adding Data Files to a Tablespace
- Changing Data File Size
- Altering Data File Availability
- Renaming and Relocating Data Files
- Dropping Data Files
- Verifying Data Blocks in Data Files
- Copying Files Using the Database Server
- Mapping Files to Physical Devices
- Data Files Data Dictionary Views
16 Managing Undo
- What Is Undo?
- Introduction to Automatic Undo Management
- Setting the Minimum Undo Retention Period
- Sizing a Fixed-Size Undo Tablespace
- Managing Undo Tablespaces
- Migrating to Automatic Undo Management
- Undo Space Data Dictionary Views
17 Using Oracle Managed Files
- What Are Oracle Managed Files?
- Enabling the Creation and Use of Oracle Managed Files
- Creating Oracle Managed Files
- How Oracle Managed Files Are Named
- Creating Oracle Managed Files at Database Creation
- Specifying Control Files at Database Creation
- Specifying Redo Log Files at Database Creation
- Specifying the SYSTEM and SYSAUX Tablespace Data Files at Database Creation
- Specifying the Undo Tablespace Data File at Database Creation
- Specifying the Default Temporary Tablespace Temp File at Database Creation
- CREATE DATABASE Statement Using Oracle Managed Files: Examples
- Creating Data Files for Tablespaces Using Oracle Managed Files
- Creating Temp Files for Temporary Tablespaces Using Oracle Managed Files
- Creating Control Files Using Oracle Managed Files
- Creating Redo Log Files Using Oracle Managed Files
- Creating Archived Logs Using Oracle Managed Files
- Operation of Oracle Managed Files
- Scenarios for Using Oracle Managed Files
Part III Schema Objects
18 Managing Schema Objects
- Creating Multiple Tables and Views in a Single Operation
- Analyzing Tables, Indexes, and Clusters
- Truncating Tables and Clusters
- Enabling and Disabling Triggers
- Managing Integrity Constraints
- Renaming Schema Objects
- Managing Object Dependencies
- Managing Object Name Resolution
- Switching to a Different Schema
- Managing Editions
- Displaying Information About Schema Objects
19 Managing Space for Schema Objects
- Managing Tablespace Alerts
- Managing Resumable Space Allocation
- Reclaiming Wasted Space
- Dropping Unused Object Storage
- Understanding Space Usage of Data Types
- Displaying Information About Space Usage for Schema Objects
- Capacity Planning for Database Objects
20 Managing Tables
- About Tables
- Guidelines for Managing Tables
- Design Tables Before Creating Them
- Specify the Type of Table to Create
- Specify the Location of Each Table
- Consider Parallelizing Table Creation
- Consider Using NOLOGGING When Creating Tables
- Consider Using Table Compression
- Examples Related to Table Compression
- Compression and Partitioned Tables
- Determining If a Table Is Compressed
- Determining Which Rows Are Compressed
- Changing the Compression Level
- Adding and Dropping Columns in Compressed Tables
- Exporting and Importing Hybrid Columnar Compression Tables
- Restoring a Hybrid Columnar Compression Table
- Notes and Other Restrictions for Compressed Tables
- Packing Compressed Tables
- Consider Encrypting Columns That Contain Sensitive Data
- Understand Deferred Segment Creation
- Materializing Segments
- Estimate Table Size and Plan Accordingly
- Restrictions to Consider When Creating Tables
- Creating Tables
- Loading Tables
- Automatically Collecting Statistics on Tables
- Altering Tables
- Reasons for Using the ALTER TABLE Statement
- Altering Physical Attributes of a Table
- Moving a Table to a New Segment or Tablespace
- Manually Allocating Storage for a Table
- Modifying an Existing Column Definition
- Adding Table Columns
- Renaming Table Columns
- Dropping Table Columns
- Placing a Table in Read-Only Mode
- Redefining Tables Online
- Features of Online Table Redefinition
- Performing Online Redefinition with DBMS_REDEFINITION
- Results of the Redefinition Process
- Performing Intermediate Synchronization
- Aborting Online Table Redefinition and Cleaning Up After Errors
- Restrictions for Online Redefinition of Tables
- Online Redefinition of a Single Partition
- Online Table Redefinition Examples
- Privileges Required for the DBMS_REDEFINITION Package
- Researching and Reversing Erroneous Table Changes
- Recovering Tables Using Oracle Flashback Table
- Dropping Tables
- Using Flashback Drop and Managing the Recycle Bin
- Managing Index-Organized Tables
- Managing External Tables
- Tables Data Dictionary Views
21 Managing Indexes
- About Indexes
- Guidelines for Managing Indexes
- Create Indexes After Inserting Table Data
- Index the Correct Tables and Columns
- Order Index Columns for Performance
- Limit the Number of Indexes for Each Table
- Drop Indexes That Are No Longer Required
- Indexes and Deferred Segment Creation
- Estimate Index Size and Set Storage Parameters
- Specify the Tablespace for Each Index
- Consider Parallelizing Index Creation
- Consider Creating Indexes with NOLOGGING
- Understand When to Use Unusable or Invisible Indexes
- Consider Costs and Benefits of Coalescing or Rebuilding Indexes
- Consider Cost Before Disabling or Dropping Constraints
- Creating Indexes
- Altering Indexes
- Monitoring Space Use of Indexes
- Dropping Indexes
- Indexes Data Dictionary Views
22 Managing Clusters
- About Clusters
- Guidelines for Managing Clusters
- Creating Clusters
- Altering Clusters
- Dropping Clusters
- Clusters Data Dictionary Views
23 Managing Hash Clusters
- About Hash Clusters
- When to Use Hash Clusters
- Creating Hash Clusters
- Altering Hash Clusters
- Dropping Hash Clusters
- Hash Clusters Data Dictionary Views
24 Managing Views, Sequences, and Synonyms
- Managing Views
- Managing Sequences
- Managing Synonyms
- Views, Synonyms, and Sequences Data Dictionary Views
25 Repairing Corrupted Data
- Options for Repairing Data Block Corruption
- About the DBMS_REPAIR Package
- Using the DBMS_REPAIR Package
- DBMS_REPAIR Examples
Part IV Database Resource Management and Task Scheduling
26 Managing Automated Database Maintenance Tasks
- About Automated Maintenance Tasks
- About Maintenance Windows
- Configuring Automated Maintenance Tasks
- Configuring Maintenance Windows
- Configuring Resource Allocations for Automated Maintenance Tasks
- Automated Maintenance Tasks Reference
27 Managing Resources with Oracle Database Resource Manager
- About Oracle Database Resource Manager
- Assigning Sessions to Resource Consumer Groups
- The Types of Resources Managed by the Resource Manager
- Creating a Simple Resource Plan
- Creating a Complex Resource Plan
- Enabling Oracle Database Resource Manager and Switching Plans
- Putting It All Together: Oracle Database Resource Manager Examples
- Managing Multiple Database Instances on a Single Server
- Maintaining Consumer Groups, Plans, and Directives
- Viewing Database Resource Manager Configuration and Status
- Monitoring Oracle Database Resource Manager
- Interacting with Operating-System Resource Control
- Oracle Database Resource Manager Reference
28 Oracle Scheduler Concepts owb组件里设计中心模块上的计划可以部署到oracle scheduler组件
- Overview of Oracle Scheduler
- About Jobs and Supporting Scheduler Objects
- More About Jobs
- Scheduler Architecture
- Scheduler Support for Oracle Data Guard
- Oracle Scheduler and Editions
29 Scheduling Jobs with Oracle Scheduler
- About Scheduler Objects and Their Naming
- Creating, Running, and Managing Jobs
- Creating and Managing Programs to Define Jobs
- Creating and Managing Schedules to Define Jobs
- Using Events to Start Jobs
- Creating and Managing Job Chains
- Chain Tasks and Their Procedures
- Creating Chains
- Defining Chain Steps
- Adding Rules to a Chain
- Enabling Chains
- Creating Jobs for Chains
- Dropping Chains
- Running Chains
- Dropping Chain Rules
- Disabling Chains
- Dropping Chain Steps
- Stopping Chains
- Stopping Individual Chain Steps
- Pausing Chains
- Skipping Chain Steps
- Running Part of a Chain
- Monitoring Running Chains
- Handling Stalled Chains
- Prioritizing Jobs
- Managing Job Priorities with Job Classes
- Setting Relative Job Priorities Within a Job Class
- Managing Job Scheduling and Job Priorities with Windows
- Managing Job Scheduling and Job Priorities with Window Groups
- Allocating Resources Among Jobs Using Resource Manager
- Example of Resource Allocation for Jobs
- Monitoring Jobs
30 Administering Oracle Scheduler
- Configuring Oracle Scheduler
- Monitoring and Managing the Scheduler
- Import/Export and the Scheduler
- Troubleshooting the Scheduler
- Examples of Using the Scheduler
- Scheduler Reference
Part V Distributed Database Management
31 Distributed Database Concepts 分布式数据库 :各个数据库间通过database link 组成一个分布式数据库?
- Distributed Database Architecture
- Database Links
- Distributed Database Administration
- Transaction Processing in a Distributed System
- Distributed Database Application Development
- Character Set Support for Distributed Environments
32 Managing a Distributed Database
- Managing Global Names in a Distributed System
- Creating Database Links
- Using Shared Database Links
- Managing Database Links
- Viewing Information About Database Links
- Creating Location Transparency
- Managing Statement Transparency
- Managing a Distributed Database: Examples
33 Developing Applications for a Distributed Database System
- Managing the Distribution of Application Data
- Controlling Connections Established by Database Links
- Maintaining Referential Integrity in a Distributed System
- Tuning Distributed Queries
- Handling Errors in Remote Procedures
34 Distributed Transactions Concepts
- What Are Distributed Transactions?
- Session Trees for Distributed Transactions
- Two-Phase Commit Mechanism
- In-Doubt Transactions
- Distributed Transaction Processing: Case Study
- Stage 1: Client Application Issues DML Statements
- Stage 2: Oracle Database Determines Commit Point Site
- Stage 3: Global Coordinator Sends Prepare Response
- Stage 4: Commit Point Site Commits
- Stage 5: Commit Point Site Informs Global Coordinator of Commit
- Stage 6: Global and Local Coordinators Tell All Nodes to Commit
- Stage 7: Global Coordinator and Commit Point Site Complete the Commit
35 Managing Distributed Transactions
- Specifying the Commit Point Strength of a Node
- Naming Transactions
- Viewing Information About Distributed Transactions
- Deciding How to Handle In-Doubt Transactions
- Manually Overriding In-Doubt Transactions
- Purging Pending Rows from the Data Dictionary
- Manually Committing an In-Doubt Transaction: Example
- Data Access Failures Due to Locks
- Simulating Distributed Transaction Failure
- Managing Read Consistency