DBA work summary

Since the DBA's work has been summarized for more than a year, I have respected leaders and colleagues, obeyed the arrangement and observed discipline, insisted on Studying professional knowledge, and worked diligently. Summary of the past, in the knowledge structure, can complete the work of the EBS-DBA; in the daily work XX, can complete the work tasks of the EBS-DBA, adapt to the DBA job requirements of the responsibility, palm

Since the DBA's work has been summarized for more than a year, I have respected leaders and colleagues, obeyed the arrangement and observed discipline, insisted on Studying professional knowledge, and worked diligently. Summary of the past, in the knowledge structure, can complete the work of the EBS-DBA; in the daily work XX, can complete the work tasks of the EBS-DBA, adapt to the DBA job requirements of the responsibility, palm

DBA work summary

For more than a year, I have respected and respected the leaders to unite my colleagues, obey the rules and observe the discipline, learn professional knowledge, and work diligently. Summary of the past, in the knowledge structure, can complete the EBS-DBA of the work; in the daily work XX, can complete the EBS-DBA of the work tasks, adapt to the DBA job requirements of the responsibility, has mastered many technical requirements of EBS-DBA. My main work over the past year covers daily maintenance, Patch Update, Installation Planning, documentation, and the next step.

First, routine maintenance

It mainly includes the following content: ERP backup and backup testing, system inspection, peripheral support, and internal O & M work.

1. Oracle BES system backup and backup Test

1) cloning and replication of major Apps is in great demand because there are production environments, test environments, and development environments in various provinces. Database Backup

2) daily inspection

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

Check the running status, log files, backup status, and system resource usage of the Oracle database every day to discover and solve the problem. We monitor the space expansion and data growth of database objects every week, perform health checks on databases, and check the status of database objects. Perform analyze on tables and indexes every month, check table space fragments, and find opportunities for database performance adjustment. Perform a comprehensive check on the Oracle database status. Check that all instances are logged on to all databases or instances. Check the usage of the file system (available space ). If the remaining space of the file system is less than 20%, delete unnecessary files to release space. Check the errors in log files and trace file records alert and trace file XX. Discover any new ORA _ errors, record and solve them

Check the validity of the database backup on the current day, The RMAN backup method, and the backup logs of the third-party backup tools to determine whether the backup is successful. For the EXPORT backup method, check the exp log file to determine whether the backup is successful, for other backup methods, check the corresponding log files, check the data files whose status is not "online", and restore them.

Monitor database performance, utlbstat. SQL/utlestat. SQL to generate system reports, or use statspace to collect statistics. Check the database performance, record the CPU usage, IO, and Buffer life XX rate of the database, and use vmstat, iostat, glance, and top. Handle daily problems, check the list of space fragments, analyze database fragments based on weekly checks this month, and find corresponding solutions

Compare the daily monitoring reports on the database performance, determine whether it is necessary to adjust the database performance and database performance. If necessary, adjust the performance and propose the next space management plan. Based on the weekly monitoring, propose methods for improving space management

3) peripheral support

It supports the audit business of PwC, Yuehua audit system, and XX General Audit. It also supports the storage solution, system maintenance, and information network work of digital shenzhou.com.

4) Internal O & M

Build the VSS server of chuangyi company and manage code and documents; collect and maintain the FTP server management documents of chuangyi company. Support Group companies and all subsidiaries to solve various problems arising during the XX login process.

Ii. system installation and upgrade Patches

System installation and deployment, system patch upgrade, and other work are important tasks of DBA. The following lists the important work of XX in a year.

1. system installation, deployment, online support, and system O & M of XX coal sales company

Responsible for system integration of the eSCM project of XX coal sales company. chuangyi technical team is responsible for host mounting, operating system software installation, high-availability cluster configuration, and database and cluster software installation, from the current period to the National Day, two technicians of chuangyi will be responsible for system integration independently, coordinate with relevant engineering personnel of the Information Department of the group, XX coal sales company, Bao Xin Company, and shenzhoudigital system integration company to complete contract acceptance and other related work. It mainly includes hardware system integration, software application deployment, sales company business data switching and launch. Mainly responsible for system integration and sales software logic control. It involves a wide range of information construction-related knowledge and involves many departments with high complexity. The successful completion of the system integration business will greatly improve the technology and experience of relevant teams.

2. system installation, deployment, online support, and system O & M of XX coal Finance Company

After tracking the system integration of XX coal Finance Company (Funding) project, the technology team of chuangyi company is responsible for host mounting, operating system software installation, and high-availability cluster configuration, install the database and cluster software. System integration in financial companies involves a wide range of knowledge related to information construction, involving multiple departments with high complexity. The successful completion of the system integration business reflects the gradual maturity of chuangyi's technical team in the technical field. At the same time, it improves the trust of the technical staff of chuangyi company in the Information Department. This system integration is the first time that chuangyi undertakes the external assistance task of the system integration business.

3. XX coal SOA project system upgrade

The system management consultant of chuangyi Technology Group independently supported the upgrade of the SOA project system in November 25. For the first time, the technical team independently undertakes the system upgrade work before the launch of major projects, and the system upgrade work has been completed successfully. It provides strong support for the smooth development of the group's SOA project. The system management consultant of chuangyi Technology Group will have accumulated valuable experience in launching, promoting and maintaining SOA projects.

3. fault recovery and performance Adjustment

Over the past year, we have done a lot of work in data recovery, database performance tuning, and ERP environment fault recovery.

1. Data Recovery

In July May, 196 copies of database data on the self-owned platform were supported for restoration. The Restoration took two weeks and the lost data was found from the data XX in the first three months of the accident. There are many participants, including all the consultants of the technology group of chuangyi company, some management business leaders of the Information Management Department, clients, end customers, and other parties. This data recovery is our first experience in restoring useful information from tape and other backup devices XX. Chuangyi has accumulated rich data recovery experience and is familiar with oracle database backup and recovery principles and mechanisms.

2. Performance Tuning

By capturing ADDM information, awr information, ASH and other information, analyzing UNIX system bottlenecks, providing optimization suggestions, using tools such as SQL Tuning and optimizer, analyze and adjust the various runtime parameters of the database and the efficiency of various codes running in the database XX. To improve the efficiency of ERP operation. It provides a valuable and reliable reference database for oracle after-sales personnel and ERP system computing capacity expansion

3. fault recovery

Tracking and assisting in handling major incidents of ERP system downtime a few days ago. From the discovery, tracking, handling of ERP system crashes, and finally the ibm oracle factory technical staff to participate in the restoration process of the costume drama, I learned from XX a wealth of valuable experience in failure. It also provides reliable first-hand experience for the establishment of the erp o & M emergency mechanism of chuangyi company in the future.

4. Document Writing and Arrangement

Compiled the oracle database O & M manual and the UNIX-linux operating system O & M manual. Sort EBS daily inspection manual

I have compiled the Linux installation manual and the oracle RAC environment installation and deployment manual. Collected and sorted all documents of the launch of the ESCM project of the Sales Company.

The Linux shared storage installation and deployment manual, oracle RAC environment testing manual, and other documents are studied and sorted out in detail.

5. Next Step

The O & M Technology of oracle ASM, oracle rac o & M and fault diagnosis technology will be further studied as the preparation for subsequent database O & M after the erp system is resized, oracle RMAN backup and recovery technology to further study the EBS system structure and other details.

Oracle ebs dba must be familiar with the host operating system UNIX-IBM AIX6.1 release, based on the current personnel and equipment status, in the next step, we will arrange XXX and I to train the system for use, inspection, and simple troubleshooting.