Oracle® Database 2 Day DBA 11g Release 1 (11.1) Part Number B28301-03 |
|
|
View PDF |
This section provides an overview of the tasks involved in managing an Oracle database instance. Each task is described in detail in a different chapter in this guide.
To manage your Oracle database:
Start the database instance. At the end of the installation, your instance is already started and your database is open. In the future, there will be times, perhaps for doing database maintenance or because of a power or media failure, that you shut down your database instance and later restart it.
Optionally, configure the network environment to enable clients to connect to your database.
Review your database storage structure: tablespaces and datafiles, redo log files, and control files. Create or modify storage structures as needed.
Review memory allocation and adjust as needed.
See "Managing Memory".
Review, unlock, and reset passwords for predefined database users as needed. Create new users, and assign privileges and roles to them.
Create any necessary schema objects, including tables, views, and indexes. Populate the tables with data.
Create or review the backup strategy for the database and back up the database.
Enable archiving of redo logs, if not already done.
Monitor database performance, diagnose performance problems, and tune the database as necessary.
Investigate, gather diagnostic data for, and report to Oracle Support Services any critical database errors.
See Chapter 11, "Investigating, Reporting, and Resolving Problems".
Keep Oracle Database software up-to-date with the latest patch releases.