An example of Oracle 8i database recovery

The system environment is Microsoft Windows 98, Chinese Oracle 8i stand-alone version, the application is the health insurance system drugstore end, daily turnover of about thousands of yuan. Users reflect that the computer started when the computer does not normally shut down the detection of the D drive, check to 11% stay time is very long, and then prompted D disk error, blocked ScanDisk repair, recommended to re-execute ScanDisk under DOS. The system then returns to the DOS interface. Then you start using the "command line mode" in the Windows 98 boot menu to execute the ScanDisk program and the failure continues. According to the user said a few days ago because of the power outage computer several illegal shutdown, another computer in the D disk detected more than 20 bad road.

I checked the wnybalrt.log and learned that the last time Oracle started properly, and then backed up d:\oracle\oradata\wnyb all files and d:\oracle\admin\webdata\bdump\ Pwdwnyb.ora to the new hard drive E:\oldora. Start your computer with a new hard disk, install an operating system, install Oracle 8i, set up Database Sid=wnyb. The specific recovery steps are as follows:

1, Svrmgr>shutdown immediate.

2, the new system Oracle 8i data Cold backup to the D:\oracle\temp directory.

3. Copy the old system Oracle 8i data (e:\oldora\*.*) back to the D:\ORACLE\ORADATA\WNYB directory, then overwrite the Pwdwnyb.ora file of the new system with the original Pwdwnyb.ora file.

4, Svrmgr>startup

The system is prompted to mount the database, and the database is open. This completes the recovery of your database.

After the summary, fortunately the hard drive bad path is not in the location of Oracle data, otherwise the data is difficult to recover. So here's the point: make sure you have a regular backup of your data.

Article: Multi-backup

This article is from the "Big Meatball" blog, please make sure to keep this source http://12478147.blog.51cto.com/9663367/1606675

An example of Oracle 8i database recovery