Explain the maintenance of the Oracle Database Administrator (1)

Oracle Database AdministratorI have already introduced daily, weekly, and monthly jobs for you, this section describes the monthly responsibilities and daily management of Oracle Database administrators, the weekly responsibilities of Oracle Database administrators, and the daily responsibilities of Oracle Database administrators, this article explains how to maintain the Oracle database administrator ".

1. Daily maintenance process

A. check whether all instances have started

Determine whether the database is available and write each instance into the log and run the daily report or run the test file. Of course there are some operations that we want to automatically run.

Optional execution: Use the 'probe' event in the ORACLE manager to view

B. Search for the new warning log file.

1. connect to each Operating System

2. Use 'telnet 'or a comparable Program

3. for each management instance, the $ ORACLE_BASE // bdump operation is often executed, and the SID of the control database can be returned.

4. Run the 'tail' command in UNIX to view alert _. log, or use other methods to check the recent warning logs in the file.

5. If some ORA_ERRORS appeared again before, record it to the database recovery log and carefully study them. The database recovery log is in <FILE>

C. view the running status of DBSNMP

Check the 'dbsnmp 'processes of each managed machine and record them in the log.

In UNIX, in the command line, type ps-ef | grep dbsnmp, and two DBSNMP processes are running. If no, restart DBSNMP.

D. Check whether the database backup is successful

E. Check whether the Backup Tape document is successful.

F. Check whether sufficient resources are available for reasonable performance.

1. check whether there is any available space in the tablespace.

For each instance, check whether there is any available space in the tablespace to meet the expected needs of the day. When the existing data in the database is stable, the average daily data growth can also be calculated. The minimum remaining space must at least meet the daily data growth requirement.

A) Run 'free. SQL 'to check the remaining space.

B) Run 'space. SQL 'to check the percentage of available SPACE in the SPACE.

2. Check rollback segments

The status of a rollback segment is generally online. Except for some dedicated segments prepared for complex work, it is generally offline.

A. Each database has a list of rollback segments.

B. You can use V $ ROLLSTAT to query the current status of online or offline rollback segments.

C. You can use DBA_ROLLBACK_SEGS to query the storage parameters and names of all rollback segments. But it is not as accurate as V $ ROLLSTAT.

3. Identify excessive growth

Check the storage parameters of the segments in the database that exceed the resource or the growth rate is too high.

A. Collect information about the daily data size, which can be used

'Analyze5pct. SQL '. Skip this step if you collect information every night.

B. Check the current range. 'nr. EXTENTS. SQL 'is available '.

C. query the size of the current table.

D. query the current index size.

E. query the growth trend.

4. Determine the Space Range

If the NEXT_EXTENT of the range space object is larger than the maximum range provided by the tablespace, the operation of the database will be affected. If we find this target, we can use 'alter tablespace coalesce 'to investigate its location or add another data file.

A) Run 'spacebound. SQL '. If they are all normal, no rows will be returned.

5. Review the process of CPU, memory, network, and hardware resource arguments

A) Check the CPU utilization and go to x: \ web \ phase2 \ default.htm => system

Metrics => On the CPU utilization page, the maximum CPU usage is 400. When the CPU usage remains above 350 for a period of time, we need to check and study the problems.

G. Copy the archived logs to the standby database.

If there is a backup database, copy the appropriate archived logs to the desired location of the backup database, and save the most recent data in the backup database.

H. Check the DBA user manual frequently.

If possible, read it extensively, including the DBA manual, industry magazine, news group, or email list.