Yesterday, a customer called to call, said their database is broken, can not use, need my help to recover, this is going to leave, incredibly out of this thing, and I do not like to restore the database this kind, especially their database is a win on the library, but the heart is very clear, customers than I worry, customer is God, There's nothing to say, let's get started. Through careful understanding, the general understanding of the customer's situation, their library is in win on the oracle11g, because the anti-virus software to the Oracle software for some files as a virus to delete, and stubborn to copy in the past will be deleted, and later do not know how many files deleted, the database will not come up, I do not know that they have the database to the active shut down, or the database itself down, anyway, the result is not up. After checking, the data file should be OK, just a general judgment, start to restore it.
1. Install the Software
First of all, we have to reinstall the Oracle software, after communicating with customers, they are confident that they can reinstall the software themselves, so they first install the database software, for the sake of insurance, let them install the software to a different location. I am a little surprised that the customer installs the software very quickly, may also be finished in more than 10 minutes. To illustrate, assume that the original software installation path is:
D:\app\erp\product\11.2.0\dbhome_1
The path to the new installation software is:
D:\app\erp\product\11.2.0\dbhome_2
When the software is finished, the next thing to do is to see if you can pull the database up with the newly installed software.
2. Setting Environment variables
Turn on computer advanced Settings--environment variable Settings---> Settings:
oracle_sid=ora11g
Oracle_base=d:\app\erp\product\
Oracle_home=d:\app\erp\product\11.2.0\dbhome_2
D:\app\erp\product\11.2.0\dbhome_1\bin the path to Oracle about-->d:\app\erp\product\11.2.0\dbhome_2\bin
3. Copy the corresponding file:
CP D:\app\erp\product\11.2.0\dbhome_1\database\*.* D:\app\erp\product\11.2.0\dbhome_2\database\
CP D:\app\erp\product\11.2.0\dbhome_1\network\*.* D:\app\erp\product\11.2.0\dbhome_2\network\
4. Log out and log back in to the OS user
5. Delete the old Oracle service first
ORADIM-DELETE-SRVC oracleserviceora11g
6. New Oracle Service:
ORADIM-NEW-SRVC oracleserviceora11g-sid ora11g-startmode auto-shutmode immediate-srvcstart demande-spfile
7. Restart the new Oracle service
net start oracleserviceora11g
Lsnrctl start
8. Login Database Test:
Sqlplus Test/[email protected]
If you can log in to the database, it all OK.
9. Delete the old Oracle software catalog to free up space.
10, to this point, the customer database recovery completed, about half an hour before and after the appearance.
Database Restore (bloodless)--half an hour to restore the customer database