Introduction to Oracle learning methods

 

 

I 've been playing Oracle for almost two years. I 've been sorting out Oracle-related technical articles. I used to learn J2EE and went to training institutions for a year, at that time, I thought it was just about development, but it turns out that I still have a better relationship with Oracle.

 

 

 

I remember when I was looking for a job in 2008, a company recruited Java engineers. Soon after I arrived at the company, the project was gone. Because the company still had database services, I turned to a database. I didn't know much about oracle at the time. I only knew it was a large database. It may have been a long time for developers. At the beginning, they were quite reluctant. They always felt that DBA had no development prospects. Later, I found that DBA is actually better. Because development cannot be carried out for a lifetime, it must be transformed after the age of 30. However, DBAs have a better working time.

 

 

 

At first, I followed Roy to play MSSQL 2005. after about three months, I installed it, checked the backup status, and occasionally moved the database to execute SQL statements for other colleagues. Later I started playing oracle. At that time, the database in the United States was maintained, so there were two challenges at that time: first, technology and second, English. Second, after I passed CET4 in the last semester, english is basically lost. So the time was very difficult, but now, I still want to thank the boss John. John stayed in the United States for nearly 20 years as a DBA. If I hadn't met him, I wouldn't have been able to embark on the DBA path. If it weren't for his stress, I couldn't make progress so fast. Later, I left the company for some reason. This is also my first job, but it was this job that made me a DBA and made me an entry into Oracle. This is a long process. It should take seven months. How long does it take to get started? I can't remember it now. I just learned it later, and I knew it in my mind. I had an overall framework for Oracle, so it would naturally be much faster to learn. So oracle is hard to get started. If you are not diligent, you will not be able to enter the door for a year.

 

 

 

I personally think that if a DBA has never been down in the database during its growth, it is not perfect. The growth process of a DBA is always tortuous and smooth sailing, it is not necessarily a good thing. When you encounter problems, you may be confused. This is a secret of DBAs. As DBAs, you must always remember to be brave and be calm. In the event of a sudden incident, such as a database crash, everyone in the company will focus on you. At that time, the pressure was very high. Only those who experienced this kind of experience could calmly solve the problem. Therefore, there is a saying that DBA is under great pressure and short-lived.

 

 

 

In combination with my summary of Oracle over the past two years, I have an experience that is quite useful: more experiments. I read a lot of books, did a lot of experiments, and spent a lot of time accumulating my knowledge today. Some netizens may think that I am a master. In fact, what kind of experts are there? I met those problems before them and solved them. The other thing is that you have been a master. Oracle is a huge system. There are many pieces of knowledge in it. I do not know some knowledge. When they asked me, I studied it, understood it, and told others. So while helping others, our technology has also increased.

 

Next, let's give a brief description of the Oracle system. When you are learning this step, you will not be on a detour. This is my personal experience.

 

 

1. Understand the composition of Oracle and what files are made up of Oracle. What is the role of each file.

For example:

Password File, control file, redo log, data file, Alert Log, SGA composition, PGA composition.

Only by understanding these definitions and their roles can we form a framework for Oracle in the brain. This is very important. If Oracle has not used this framework for several years, it is just a cup of cake, because there is no entry point yet. This framework is one of Oracle's entry criteria.

 

 

2. Master common Oracle technologies

There are so many common Oracle technologies that I have listed:

 

1) install and uninstall Windows, Linux, and UNIX platforms.

2) Cold backup and cold backup restoration

3) logical backup and Restoration

4) RMAN backup and Restoration

5) data migration: Logical backup or RMAN is available.

6) Add a tablespace

7) high-availability data guard installation and maintenance

8) High Availability RAC installation and maintenance

9) database performance diagnosis and Optimization

 

 

As a database administrator, master the above knowledge to be able to stand alone in the company. Of course, we still need to accumulate experience and perform more experiments. Some knowledge points may not be easy to understand, but through experiments, it requires a lot of understanding. My blog also has a lot of information, is I learn and finishing (http://blog.csdn.net/tianlesoftware ). if I have time, I will also record some videos on the Internet. After all, I will learn a lot through watching videos.

 

 

 

Finally, we must improve our problem-solving capabilities. I had a problem with Google. It took me five days to install the first RAC. how painful it was at that time. One of the errors is that I use one day to Google. Now I have created a QQ Group. We hope that you can avoid detours. But sometimes I feel that the dependency is too strong. Why don't I google it myself? If I solve it myself, I understand it, and I will always remember it. I told you, this meeting is over, but I don't have to understand it. I don't have to remember it. DBAs either do not make mistakes or make a big mistake. Therefore, the basic skills must be solid, and a good habit should be developed. The database should be backed up every day, and backup should also be required when it is doing a big job on the database. In addition, if you encounter problems, you must be calm and be able to solve the problems independently, so that you can grow fast. As the Oracle master eygle said: With the continuous advancement of technology and the times, the growth time left for DBAs is getting shorter and shorter. It will not take more than two years for a DBA to grow from entry to senior.