|
Step 1 - Common Oracle DBA Tasks
|
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 Oracle database
- Managing the database's storage structures
- Managing users and security
- Managing schema objects, such as tables, indexes, and views
- Making Oracle 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.
Few more are:
- A very basic task is to add users in Oracle.
- One of the most important tasks is to establish and perform an Oracle Backup. Without it, you are leading a dangerous life...
- As a professional Oracle DBA, after having established sound backup procedures, let us hope you never will need to perform an Oracle Recovery. Chances are, however, that you may have to some day...
- If you need to, you can export parts of, or the complete database, to a flat file using Oracle Export. Nice feature, but very old-fashioned...
- After you have performed an Oracle Export, you can use the Oracle Import function to load data into another database. Very useful feature, but as with Oracle Export: A bit old-fashioned. However, it does the job.
- Some database tables may contain millions of rows, and performance may slow down. A good solution for the Oracle DBA may be to split such tables into Oracle Partitions.
- Instead of manually starting different database tasks, the Oracle DBA can automate the whole process by using the Oracle Scheduler.
- In order to perform Oracle backup and recovery, you need to have a redo log up and running. This article looks at aspects when dealing with Oracle log files.
The last article in the Oracle DBA section is about performing real-time changes to tables and other database objects: Redefining Oracle Objects.
|
|
|
