Read Database 2 Day DBA Thoughts _ Part One

Objective

Oracle Database 2 Day DBA is a quick start guide to managing Databases to teach you how to perform routine database administration tasks. The purpose of this book is to help you understand the concepts behind the Oracle database. It teaches you how to perform all the common administrative tasks required to keep the database running, including how to perform basic troubleshooting and performance monitoring activities.

Readers

Oracle Database 2 Day DBA applies to anyone who wants to perform basic administrative tasks with the Oracle databases. Only a minimum of basic knowledge or experience of database management is required, as well as the basic knowledge of the computer. In particular, this guide applies to the following groups of Oracle users:

Developers who want to acquire basic database administrator (DBA) skills

Anyone who manages the database server

Database administrator for managing small and midsize enterprise Oracle databases

This book also applies to enterprise database administrators. It suggests best practices and describes an effective way to perform administrative tasks using Oracle Enterprise Manager as the main interface.

1 Introduction

As a database administrator (DBA), you are responsible for the overall operation of the Oracle database. This introductory section is designed to help you locate a number of common DBA tasks that apply to your tools and this guide. This chapter contains the following sections:

About this guide

Oracle Database 2 Day DBA is a quick start guide to managing Databases to teach you how to perform routine database administration tasks. The goal of this guide is to help you understand the concepts behind the Oracle database and to help you understand how to perform all the common management tasks required to keep the database running. These tasks include configuring the database, managing memory and storage, managing users, managing database objects such as tables, performing basic troubleshooting, creating backups for databases, performance monitoring activities, and so on.

This guide is not

Oracle Database 2 Day DBA is task-oriented. The purpose is to describe why and when to perform administrative tasks. Suppose the reader has no prior knowledge of the database, and, where appropriate, it describes the concepts necessary to understand and accomplish the task. This guide is not an exhaustive discussion of all Oracle database concepts. For such information, see Oracle Database Concepts.

Also, for a complete discussion of management tasks, see Database Administrator's Guide.

How to use this guide and related Materials

This guide is part of a comprehensive learning material for managing Oracle databases, including the 2 day DBA Oracle by Example (OBE) series and Oracle University instructor-directed courses available on the Web (Oracle University Instructor-led Class).

At the end of each chapter, you can find links to the OBE courses associated with them. 2 Day DBA The home page of the Oracle by example series is as follows:

Http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/index.html

In addition, Oracle University offers an instructor-supervised course called Oracle Database 11g:2 Day DBA. Contact Oracle University for more information.

About Oracle Databases

The Oracle database is a relational database with object and Extensible Markup Language (XML) capabilities. In a relational database, all data is stored in a two-dimensional table that consists of rows and columns. Oracle database enables you to store data, update and efficiently retrieve data with high performance, reliability, and scalability.

The Oracle database consists of the following elements:

Oracle software that you install on the host

Database, which is a collection of physical files on one or more disks

The database contains user data, metadata, and control structures. Metadata or data about data is a collection of information on disk that allows Oracle software to manage user data. An example of metadata is a data dictionary. Control structures, such as control files and online redo log files, ensure the integrity, availability, and recoverability of user data.

The Oracle instance consists of the following:

A background process is an operating system process or thread that performs access, storage, monitoring, and recovery of user data, metadata, and control files associated with the database.

Shared memory area used by the background process

Server processes that represent connected users and applications that perform work, and the memory and temporary storage used by these processes

The server process parses and executes the SQL statement, retrieving and returning the results to the user or application.

Oracle NET, a software layer that enables client applications and Oracle databases to communicate over the network, and listens to process--oracle Net listeners from network connection requests.

Database  for  Database For more information about background processes

Common Oracle DBA Tasks

As an Oracle DBA, you need to be involved in the following tasks:

Installing Oracle Software
Create an Oracle Database
upgrading databases and software to a new version level
Starting and shutting down a DB instance
Managing the storage structure of a database
Managing Users and Security
Manage database objects, such as tables, indexes, and views
Back up the database and perform recovery operations if necessary
Monitor the status of the database and take preventative or corrective action as needed
Monitoring and Tuning Database performance
Diagnose and report critical errors to Oracle support Services

Database  for  of Database Administrators

Tools for managing the database

The goal of this guide is to enable you to quickly and efficiently create an Oracle database and provide guidance in basic database management.

Here are some products, tools, and utilities that you can use to achieve your database administrator goals:

Oracle Universal Installer

Oracle Universal Installer (OUI) is a utility for installing Oracle software and options. It can automatically start the Oracle Database Configuration Assistant to install databases.

Oracle Database Configuration Assistant

Oracle Database Configuration Assistant (DBCA) is a utility that creates a database from a template provided by Oracle, or you can create your own database.

It allows you to replicate a pre-configured seed database, saving you time and effort to build and customize new databases.

Database Upgrade Assistant

Database Upgrade Assistant is a tool that guides you through upgrading an existing database to a new version of Oracle database.

Net Configuration Assistant

Net configuration Assistant (NETCA) is a utility that allows you to configure listeners and named methods (naming methods), which is a critical component of the Oracle database network.

Oracle Enterprise Manager Database Control

The primary product for managing databases is the Oracle Enterprise Manager database control, a Web-based interface. After you install the Oracle database software, create or upgrade databases, and configure the network, you can use database control to manage the databases.

Database control also provides an interface for Performance Advisor (performance advisors) and Oracle utilities such as SQL * Loader and Recovery Manager (RMAN).

Oracle also provides a separate, authorized Oracle Enterprise Manager Management Pack, management plug-ins, and other products that you can purchase to enhance the capabilities of Oracle Enterprise Manager in a specific environment.

Database Licensing Information

Common in The King's house, Tri Yutong a few times before the smell;

It is jiangnan good scenery, flower season and every June

Read Database 2 Day DBA Thoughts _ Part One