2 Day DBA 学习总结

How to perform day-to-day database administrative tasks.

The goal of this guide is to help you understand the concepts behind Oracle Database.

and help you learn how to perform all common administrative tasks needed to keep the database operational.

These tasks including :

Oracle Database is composed of the following elements:

The Oracle software that you install on your host computer.
The database, which is a collection of physical files on one or more disks,(contain user data,metadata,and control structures)
The Oracle instance, which is composed of the following:(The background processes & The shared memory areas)
Server processes that perform work on behalf of connected users and applications, and the memory and temporary storage used by these processes.
Oracle Net,which is a software layer that enables client applications and Oracle Database to communicate over a network.and the Oracle Net Listener,which is a process that listens for connection requests from the network.

As an Oracle database administrator(DBA), you can expect to be involved in various tasks:

Install Oracle software
Creating Oracle databases
Performing upgrades of the database and software to new release levels
Starting and shutting down the database instance
Managing users and security
Managing database objects,such as tables ,indexes, and views
Backuping up the database and performing recovery operations where necessary
Monitoring the state of the database and taking preventive or corrective action as required
Monitoring and tuning database performance
Diagnosing and reporting critical errors to Oracle Support Services

The following are some products,tools,and utilities you can use to achieve your goals as a database administrator:

Oracle Univiersal Installer(OUI)(Install your Oracle software and options, can automatically start Oracle Database Configuration Assistant to install a database)
Oracle Database Configuration Assistant(DBCA)
Database Upgrade Assistant(DBUA)(that guides you through the upgrade of your existing database to a new Oracle Database release)
Net Configuration Assistant(enables you to configure listeners and naming methods)
Oracle Enterprise Manager Database Express(OEM Express)(install the Oracle Database software,created or upgraded a database, and configured the network,manage database,provide an interface for performance advisors.)
SQL Developer(provide another GUI for accessing your Oracle Database.support development in both the SQL and PL/SQL languages)

A database includes several files that store the user data,database metadata, and information required to recover from failures.

秒客网