Oracle数据恢复:错误叠加导致灾难不可恢复解决办法
文章详细记录了自己在给一个客户做数据恢复的过程了，原因是错误叠加导致灾难不可恢复算是高难度的了。
文章详细记录了自己在给一个客户做数据恢复的过程了，原因是错误叠加导致灾难不可恢复算是高难度的了。客户第一次找我的时候，我告诉他，把硬盘拿给我们，我们可以将其中的数据恢复出来。
第二天客户说，硬盘被格式化重做了系统。
客户第二次找我时，我说，把剩余的三个文件给我，我可以帮你挽救其中残存的有用数据。
第二天客户说，已经拿备份，把那三个文件刷新覆盖了。
这个故事给我们的警戒是：备份，备份，备份，再多一份也不算多；故障处理，再加一万个小心也不算多。
最初的一个简单故障，在层层错误之后，彻底不可挽回，这是多年来我见到最富有戏剧性的恢复案例。
看一看这个故障的信息，首先是一个写错误，Windows中比较典型和常见的存储访问错误：
| 代码如下 | 复制代码 |
| Sat Sep 23 18:44:51 2011 KCF: write/open error block=0x35673a online=1 Sat Sep 23 18:44:51 2011 KCF: write/open error block=0x25eba4 online=1 file=124 D:DTAPRODTA02.DBF error=27070 txt: 'OSD-04016: 异步 I/O 请求排队时出错。 O/S-Error: (OS 2) 系统找不到指定的文件。' ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01114: IO error writing block to file 124 (block # 24856) ORA-01110: data file 124: 'D:DTAPRODTA02.DBF' ORA-27070: skgfdisp: async read/write failed OSD-04016: 异步 I/O 请求排队时出错。 O/S-Error: (OS 2) 系统找不到指定的文件。 |
|
再然后，恢复使用了一个4月份的备份，又覆盖了挽救回来的文件：
| 代码如下 | 复制代码 |
| Sun Sep 24 20:58:32 2011 The input backup piece G:BCKDB_T20110421_S111_P1 is in compressed format. |
|
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1378
52
What to do if the Windows 7 system registry file is lost or damaged
Jul 08, 2023 pm 05:29 PM
Windows 7 users encounter the phenomenon that the system registry file is missing or damaged when starting up. How to solve this situation? You first force restart the computer, then press the F8 key, select safe mode in the opened page, then find the command prompt in the menu bar to open, enter the SFC/SCANNOW command and press Enter, then the system will automatically start the computer Repair missing or corrupted installation files. What to do if the Windows 7 system registry file is lost or damaged 1. After the first power-on self-test, immediately hold down the F8 key, use the arrow keys to select safe mode, and hit Enter. 2. Then click the Start button, select Command Prompt, and run as an administrator. 3. Finally, enter SFC/ in the pop-up prompt.
Solution to PHP parameter missing problem
Mar 11, 2024 am 09:27 AM
Solution to the problem of PHP parameter loss In the process of developing PHP programs, we often encounter the problem of parameter loss. This may be caused by incomplete parameters passed by the front end or incorrect way of receiving parameters by the back end. In this article, we will provide some solutions to the problem of missing parameters in PHP, along with specific code examples. 1. Front-end parameter passing problem Use the GET method to pass parameters. When using the GET method to pass parameters, the parameters will be appended to the requested URL in the form of URL parameters. When receiving parameters in the backend
How to recover diskgenius data-diskgenius data recovery tutorial
Mar 06, 2024 am 09:34 AM
Many friends don’t know how to recover diskgenius data, so the editor will share the relevant tutorials on diskgenius data recovery. Let’s take a look. I believe it will be helpful to everyone. First, in the hard disk partition diagram above the main interface of DiskGenius, you can directly select the target partition and right-click. Then, in the shortcut menu that pops up, find and click the "Deleted or formatted file recovery" menu item, as shown in the figure. In the second step, the recovery options window pops up and make sure to check the three options of "Recover Deleted Files", "Complete Recovery" and "Extra Scan for Known File Types". Step 3: Click the "Select File Type" button on the right and specify the files you need to recover in the pop-up window
ThinkPHP6 data backup and recovery: ensuring data security
Aug 13, 2023 am 08:28 AM
ThinkPHP6 data backup and recovery: ensuring data security With the rapid development of the Internet, data has become an extremely important asset. Therefore, the security of data is of great concern. In web application development, data backup and recovery are an important part of ensuring data security. In this article, we will introduce how to use the ThinkPHP6 framework for data backup and recovery to ensure data security. 1. Data backup Data backup refers to copying or storing the data in the database in some way. This way even if the data
How to use middleware for data recovery in Laravel
Nov 02, 2023 pm 02:12 PM
Laravel is a popular PHP web application framework that provides many fast and easy ways to build efficient, secure and scalable web applications. When developing Laravel applications, we often need to consider the issue of data recovery, that is, how to recover data and ensure the normal operation of the application in the event of data loss or damage. In this article, we will introduce how to use Laravel middleware to implement data recovery functions and provide specific code examples. 1. What is Lara?
How to deal with hard drive sector corruption issues
Feb 19, 2024 am 11:03 AM
How to solve a broken hard disk sector? A broken hard disk sector is a common hardware failure, which may cause data loss and affect computer performance. It is very important to understand and solve the problem of bad hard drive sectors. This article will introduce the concept of hard disk sectors, discuss common causes of bad hard disk sectors and solutions. 1. What are hard disk sectors? Before introducing how to solve the problem of bad hard disk sectors, let’s first understand what hard disk sectors are. A hard disk sector is the smallest readable and writable unit on a hard drive. It is a small section of space on a hard drive. It is
How to quickly recover from failures and errors encountered by MySQL database?
Sep 10, 2023 pm 03:45 PM
How to quickly recover from failures and errors encountered by MySQL database? MySQL is a widely used open source relational database management system that many applications and websites rely on to store and manage data. However, database failures and errors are inevitable, which may result in data loss or application failure to function properly. When encountering a MySQL database failure or error, it is very important to recover the database quickly and effectively. This article will introduce some methods to quickly restore MySQL database. Determine the type of fault and error before starting
Solution to Linux system file damage and loss
Jun 30, 2023 am 09:29 AM
Title: How to deal with file damage and loss in Linux systems Introduction: In the process of using Linux systems, file damage and loss are a problem that cannot be ignored. Due to various reasons, we may face file loss, file corruption or inability to access files. Fortunately, however, Linux systems provide some practical tools and techniques to help us effectively deal with file corruption and loss problems. This article will introduce some common solutions and techniques. 1. Backup Data Backup is the most important thing to deal with file corruption and
