Cold backup data must be open not in a state database. The following steps will give a detailed process:

◆ (1): the closure of DB: shutdown immediate;

◆ (2): copy oradata directory of all documents, including data files, control files, redo, and so on, also need to copy the password file in the directory database under ora92 the pwd file. All copy to a safe directory. Can be directly in the sql plus a host and then use the dos command. Such as host copy ………….

◆ (3): If you are reinstalling the operating system, as long as it is the same system, the same database version, is prepared to do the restoration of the cold. You talk about is the system re-installation steps.

◆ (4): normal install oracle software (before the pub on a brother that it does not need to install oracle can get, expressed doubts), only need to install the software, you can not build example, built examples of relatively long time, nor necessary. Software installed, they began to prepare to resume.

◆ (5): data coverage over the past including the pwd file, on the original directory, if the directory change is necessary to create control files, modify pfile.

◆ (6): Services set up: Use cmd command oradim under oradim-new-sid erp express set up a service, sid for erp. About oradim give special order to explain another.

◆ (7): monitor set up: net configuration assintant to set up, or set up and open the script.

◆ (8): Open the database: using oem also line, cmd line also.

Set oracle_sid = erp;

Sqlplus “/ as sysdba”;

Startup;

Select * from v $ instance;

Thus, the cold backup and recovery success. Even if you open the database now oem discovered is not able to find sid, but in reality you are successful, at this point only need to restart your server about it.