Responsibilities of the Oracle Database Administrator

Welcome to the Oracle community forum and interact with 2 million technical staff. This forum mainly introduces the specific responsibilities of the Oracle database administrator in the working environment. For details, refer to the following: the Oracle Database Administrator should perform regular monitoring on the Oracle database system as follows: (1 ). daily running status of Oracle databases, log files, and backups

Welcome to the Oracle community forum and interact with 2 million technical staff> this forum mainly introduces the specific responsibilities of the Oracle database administrator in the working environment. For details, refer to the following: the Oracle Database Administrator should perform regular monitoring on the Oracle database system as follows: (1 ). daily running status of Oracle databases, log files, and backups

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

This section describes the specific responsibilities of the Oracle database administrator in the working environment. For details, refer to the following:

The Oracle Database Administrator should perform regular monitoring on the Oracle database system as follows:

(1) Check the running status, log files, backups, database space usage, and system resource usage of the Oracle database every day to discover and solve the problem.

(2) Monitor the space expansion and data growth of database objects every week, check the database health, and check the status of database objects.

(3) perform Analyze on tables and indexes every month, check table space fragments, find opportunities for database performance adjustment, adjust database performance, and propose the next space management plan. Perform a comprehensive check on the Oracle database status.

Daily Work

(1) confirm that all instances are in normal status

Log on to all databases or routines to check ORACLE background processes:

$ Ps? Ef | grep ora

(2) Check the use of the file system (available space ). If the remaining space of the file system is less than 20%, delete unnecessary files to release space.

$ Df? K

(3) Check the log file and trace file to record errors in the alert and trace files.

Connect to each system to be managed

Use 'telnet'

Cd to the bdump directory for each database, usually $ ORACLE_BASE // bdump

Run the Unix 'tail' command to view the alert _. log file.

If any new ORA-errors are found, record and resolve them.

(4). Check the validity of the database backup on the current day.

RMAN backup method:

Check the backup logs of a third-party backup tool to check whether the backup is successful.

EXPORT backup mode:

Check the exp log file to check whether the backup is successful

Other backup methods:

Check the corresponding log file

(5) Check the data file whose status is not "online" and restore it.

Select file_name from dba_data_files where status = 'offline'

(6). Check the usage of the table space.

SELECT tablespace_name, max_m, count_blocks free_blk_cnt, sum_free_m, to_char (100 * sum_free_m/sum_m, '99. 99') | '%' AS pct_free

FROM (SELECT tablespace_name, sum (bytes)/1024/1024 AS sum_m FROM dba_data_files group by tablespace_name ),

(SELECT tablespace_name AS fs_ts_name, max (bytes)/1024/1024 AS max_m, count (blocks) AS count_blocks, sum (bytes/1024/1024) AS sum_free_m FROM dba_free_space group by tablespace_name)

WHERE tablespace_name = fs_ts_name

(7). Check the remaining tablespace

SELECT tablespace_name, sum (blocks) as free_blk,

Trunc (sum (bytes)/(1024*1024) as free_m,

Max (bytes)/(1024) as big_chunk_k, count (*) as num_chunks

FROM dba_free_space group by tablespace_name;

(8). Monitor database performance

Run bstat/estat to generate a system report

Or use statspack to collect statistics.

(9) Check the database performance and record the cpu usage, IO, buffer hit rate, and so on of the database.

Use vmstat, iostat, glance, top, and other commands

(10) Handling of daily problems.

Weekly Work

(1) control the space expansion of database objects

Find the database objects that quickly expand the space according to the daily check results of this week, and take corresponding measures

-- Delete historical data

--- Expand table space

Alter tablespace add datafile ''size

--- Adjust the storage parameters of Data Objects

Next extent

Pct_increase

(2) monitoring data volume growth

Find the database objects with fast-growing records based on the daily check results of this week and take appropriate measures

-- Delete historical data

--- Expand table space

Alter tablespace add datafile ''size

(3). System Health Check

Check the following:

Init. ora

Controlfile

Redo log file

Archiving

Sort area size

Tablespace (system, temporary, tablespace fragment)

Datafiles (autoextend, location)

Object (number of extent, next extent, index)

Rollback segment

Logging & tracing (alert. log, max_dump_file_size, sqlnet)

(4) Check invalid database objects

SELECT owner, object_name, object_type FROM dba_objects

WHERE status = 'invalid '.

[1] [2] [3] [4]