If the Linux system crashes, the data inside will be lost. Serious damage to the database, learn how to repair the database, you can minimize this loss. This article will introduce the repair database skills after the Linux system crash.
problem description and analysis:
suddenly found that the machine can not log in, the feeling is remote interruption, and immediately received a phone call, test the database can not be used. After entering the equipment room, I found that the system could not be started. I get an error: no such file or directory. . . How should this be good? If I am a DBA, I have to solve the problem of the system, or to strengthen the study. The online solution prompts me to boot into the system's rescue mode (CD-ROM or USB flash drive), then scan the VG information, manually activate the VG volume, and mount the required files of the database through the network after the LV is mounted. Or a mobile device for backup. After that, everyone will get it. The data was saved and the mood was calmer.
Processing method:
1. Boot to the rescue mode of the system using CD-ROM or USB flash drive (here refers to the operating system installation disk)
2. Vgscan -- scan vg information
3. vgdisplay -- view vg information
4. vgchange -ay vg volume group name -- activate vg
5. lvdisplay -- View lv information
6. Mount path lv name new mount point--mount lv
7. Back up the relevant database content on the mounted disk through the network and mobile device backup .
8. Repair the operating system or reinstall
9. Return the backed up database file COPY back to the normal system
10 . Install oracle software and restore the database
Summary: The above problem is best not to encounter, of course, this fault once again reminded us DBA, the importance of backup. Remember to remember and remember.
The above is the skill of repairing database skills after the Linux system crashes. Of course, if you want to repair the database, the first thing to do is to back up, so remember to back up the database at any time during normal use.
Many Linux users dont know that the shell can not only edit the script, but also ca
Once a computer system is attacked by malware, there is a risk of leaking private data. In addition
When doing Linux system operation, sometimes encounter a dead loop of user state process, that is, t
In Linux operation, sometimes changing the user password will appear it is based on a dictionary wor
How to clear the private data in the file under Linux
Ubuntu system to install PPA on the terminal Step
Ubuntu installs the fort compiler skills
How to test the read and write speed of Linux disk
Linux recovery method was mistakenly deleted root user
What is optimized for Linux kernel 4.2?
Summary of methods for restricting user su-permissions in Linux system
What should I do if the device id of the Linux virtual machine does not match the drive letter?
Linux disk failure causes the system to run slowly solution
How to increase or decrease the file system space in Solaris
Win8 touch keyboard does not prompt Lenovo vocabulary solution
Win7 system sleep when the network breaks how to do
Windows 7 shortcut icon missing problem solving tutorial
How to restore the registry in Win8 system
Win8 File History no longer worried about data loss
Windows 7 SP1 latest RC candidate release leaked
Where is the Win10 windows update?
After 5 years, Microsoft responded to the complex: no 64-bit Visual Studio