Responsibilities of database administrator:
I. General supervision
1. Monitor the warning log of the database. Alert & ltsid & gt。 Record, backup and delete regularly.
2. Monitor linstener.log,/network/network/admin/linstener.ora.
3. Redo log status monitoring, pay attention to the views v$log and v$logfile, which store the information of redo logs.
4. Monitor the daily conversation of the database.
5. Monitor fragmentation and remaining tablespaces, keep abreast of the expansion of tablespaces and the distribution of remaining spaces, and merge manually if there is continuous free space.
6. Monitor the usage of the fallback section. In the production system, rbs_big0 1 is used for major maintenance and database structure change.
7. Monitor whether there are any tables in the extension segment that do not meet the extension.
8. Monitor temporary tablespaces.
9. Modify the monitoring object. Periodically list all changed objects.
10. Trace files, including initialization parameter files, user background files and system background files.
Second, the database backup monitoring and management
Database backup is very important, so it is necessary to change the database backup strategy according to the actual needs and monitor the daily backup of data. Because we use tape library, we need to monitor legato backup software and rman backup database.
Third, standardize the management of database users.
Regularly modify the passwords of important users such as administrators. For each project, a user should be established. DBA should communicate with the corresponding project manager or programmer to determine how to establish the corresponding database underlying model, which will be managed, established and maintained by DBA. Any changes to database objects should be operated by DBA according to requirements.
Fourth, the requirements of SQL statement writing specification
An SQL statement, if poorly written, will have a great impact on the database. Therefore, every programmer or corresponding staff member should strictly follow the article "SQL Writing Specification" when writing corresponding SQL statements. Finally, there must be a DBA check before the official operation.
Verb (abbreviation of verb) Deep needs of database administrators
Whether a database can run healthily and effectively is not enough just by these daily maintenance. We should also devote ourselves to the deeper management and research of the database: the optimization of the database itself and the performance optimization in development; Rationalization of the project; Safety audit work; The underlying modeling research, planning and design of the database; Processing of various data types; Research on internal mechanism; Many problems such as the research and troubleshooting of ora-600 errors are worth discussing.