Cold backup and recovery of Oracle database in Windows environment

1. Click "Run" on the Start menu and enter Sqlplus/nolog

2. In the popup command line window login as SYSDBA, to enter: System username/Login Password @ DB instance name, such as sys/[email protected]

3. Enter ALTER DATABASE backup Controlfile to trace Resetlogs, and then locate the file that you just executed under D:\oracle\product\10.1.0\admin\orcl\udump. Copy the following paragraph:

STARTUP Nomount
CREATE controlfile SET DATABASE "ORCL" Resetlogs ARCHIVELOG
Maxlogfiles 16
Maxlogmembers 3
Maxdatafiles 100
Maxinstances 8
Maxloghistory 454
LOGFILE
GROUP 1 ' D:\oracle\product\10.1.0\ORADATA\ORCL\REDO01. LOG ' SIZE 10M,
GROUP 2 ' D:\oracle\product\10.1.0\ORADATA\ORCL\REDO02. LOG ' SIZE 10M,
GROUP 3 ' D:\oracle\product\10.1.0\ORADATA\ORCL\REDO03. LOG ' SIZE 10M
DataFile
' D:\oracle\product\10.1.0\ORADATA\ORCL\SYSTEM01. DBF ',
' D:\oracle\product\10.1.0\ORADATA\ORCL\UNDOTBS01. DBF ',
' D:\oracle\product\10.1.0\ORADATA\ORCL\SYSAUX01. DBF ',
' D:\oracle\product\10.1.0\ORADATA\ORCL\USERS01. DBF ',
' D:\oracle\product\10.1.0\ORADATA\ORCL\USERS02. DBF ',
' D:\oracle\product\10.1.0\ORADATA\ORCL\TOOLS01. DBF '
CHARACTER SET ZHS16GBK;

4. Enter shutdown immediate to stop the current DB instance.

The 5.d:\oracle\product\10.1.0\db_1\database folder and the 3rd step show those logfile and datafile files are copied out.

6. Stop the new DB instance (the new DB instance has the same name as the source DB instance), and overwrite the files and folders you copied in step 5th with the corresponding files and folders under the New Database installation folder.

7. If the installation directory of the new DB instance is different from the installation directory of the source DB instance, you need to modify the section of the 3rd step copy to the path that matches the new DB instance and execute this statement with the SYS user login in Sqlplus, and the backup is complete.

Cold backup and recovery of Oracle database in Windows environment