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 :

• configuring the database
• managing memory and storage
• managing users
• managing database objects such as tables
• performing basic troubleshooting
• creating backups for your database
• performance monitoring 

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.

Common Oracle DBA Task

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

Tools for Adminsiter the Database

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)

Database File Location for Oracle Database

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

• File System
• Automatic Storage Management

About Advanced Installation for Oracle Database

• Product Languages
• Database Configuration Type
• Database Configuration Options
• Recovery Options
• Schema Passwords
• Operating System Groups