Once the Oracle database runs in accordance with the design goals, the database can be truly operational. The database operation marks the beginning of the basic completion of the development task and the Oracle maintenance work, but does not imply the end of the design process. Because the application environment is changing constantly, the physical storage will change constantly during database operation, and the maintenance work of evaluating, adjusting and revising database design is a long-term task, and it is the continuation and improvement of the design work.
During the Oracle database runtime, regular maintenance of the database is done primarily by the DBA, which includes:
1, the database dumps and restores. Database and log files are regularly backed up to ensure that, in the event of a failure, database backups and log file backups can be used.
Restore the database to a consistent state as soon as possible, and minimize the damage to the database.
2, the security of the database, integrity control. DBAs must be responsible for database security and integrity control, and grant different permissions to operations based on the actual needs of the user. In addition, due to changes in the application environment, the integrity of the database
Sexual constraints also change, and DBAs need to be constantly revised to meet user requirements.
3, the database performance monitoring, analysis and improvement. Many DBMS products now provide tools to monitor system performance parameters. DBAs can take advantage of these tools to easily get the value of a series of performance parameters during system operation, and DBAs should carefully analyze the data to further improve database performance by adjusting certain parameters.
4, the database of the re-organization and re-hook made. After the database has been running for a period of time, due to the increasing, deleting and changing of the records, the physical storage of the database becomes bad, which reduces the utilization of the database storage space and the efficiency of data access, and makes the performance of the database decrease. At this point the DBA is going to reorganize or partially organize the database. The reconfiguration of the database will not change the logical and physical structure of the original design, but rearrange the storage location according to the original design requirements, recycle the garbage, reduce the pointer chain, improve the system performance, the DBMS generally provides a utility to use for the organization database, and helps the DBA to reorganize the database.
Read more articles about Oracle:
Oracle's user-favorite five-factor data storage disaster Solution Overview