Describes how to recover from Oracle Database cold backup

The cold backup data must be that the database is not in the open state. The detailed process is shown in the following steps:

◆ (1): Shut down the database: shutdown immediate;

◆ (2): copy all files under the oradata directory, including data files, control files, redo, and so on. copy the pwd files in the database under the ora92 directory. copy all to a security directory. You can directly add a host in SQL and then use the doscommand. For example, host copy .............

◆ (3): If the operating system is reinstalled, you can perform cold Backup recovery as long as the system is the same and the database version is the same. Next we will talk about the system re-installation steps.

◆ (4): oracle software is installed normally (a brother on pub said that oracle can be done without installation, indicating suspicion). You only need to install the software without creating an instance, it takes a long time to create an instance and is not necessary. After the software is installed, start preparing for recovery.

◆ (5): The data overwrites the pwd File and stores it in the original directory. If the directory changes, create a control file and modify the pfile.

◆ (6): create a service: Use oradim command cmd oradim-new-sid erp to create a service, sid is erp. The oradim command also provides a special explanation.

◆ (7): Create a listener: net configuration assintant, or use a script to create and enable the listener.

◆ (8): Open the database. You can also use oem or cmd.

Set oracle_sid = erp;
Sqlplus "/as sysdba ";
Startup;
Select * from v $ instance;

Now, the cold backup is successfully restored. Even if you find that the sid cannot be found when you open the database with an oem, you have actually succeeded. In this case, you only need to restart your server.