DBA通常的任务:
As an Oracle DBA, you can expect to be involved in the following tasks:
-
Installing Oracle software
-
Creating Oracle databases
-
Performing upgrades of the database and software to new release levels
-
Starting up and shutting down the database
-
Managing the database's storage structures
-
Managing users and security
-
Managing schema objects, such as tables, indexes, and views
-
Making database backups and performing recovery when necessary
-
Proactively monitoring the database's health and taking preventive or corrective action as required
-
Monitoring and tuning performance
In a small to midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs, each with their own specialty, such as database security or database tuning.
管理数据库的工具:
The intent of this book is to allow you to quickly and efficiently create an Oracle database, and to provide guidance in basic database administration.
The following are some of the products, tools, and utilities you can use in achieving your goals as a database administrator:
-
Oracle Universal Installer (OUI)
The Oracle Universal Installer installs your Oracle software and options. It can automatically launch the Database Configuration Assistant to install a database.
-
Database Configuration Assistant (DBCA)
The Database Configuration Assistant creates a database from templates that are supplied by Oracle, or you can create your own. It enables you to copy a preconfigured seed database, thus saving the time and effort of generating and customizing a database from scratch.
-
Database Upgrade Assistant
This Database Upgrade Assistant guides you through the upgrade of your existing database to a new Oracle release.
-
Oracle Net Manager
Net Manager is an alternate tool for configuring and managing Oracle Database networks.
-
Oracle Enterprise Manager
The primary tool for managing your database is Oracle Enterprise Manager, a web-based interface. After you have installed the Oracle software, created or upgraded a database, and configured the network, you can use Oracle Enterprise Manager for managing your database. In addition, Oracle Enterprise Manager also provides an interface for performance advisors and for Oracle utilities such as SQL*Loader and Recovery Manager.
From 2天DBA-1.Introduction