Tell me your own story. Oracle Heterogeneous restore Cold Backup Database ___ Database

Ext: http://www.cnblogs.com/hustsay23/archive/2011/11/05/2237748.html

The biggest difference between an Oracle database and SQL Server is that the latter is simple to accomplish. The graphical interface can be done step-by-step, and Oracle needs you to really understand it, knowing the meaning of every step you make.

Cold backup should be said to be the simplest form of backup in Oracle database

It is commonly used for the use of local or heterogeneous machine to reload a similar database, then a cold backup is very convenient

The following is a real cold backup with my notebook and then restored to the virtual machine

Notebook (source) virtual machine (target)

Operating system WIN7 WINDOWS 2003

ORACLE 11GR2 11GR2

Install root directory D:\oracle11g D:\oracle11g

Database ORCL Database not created

You can see that in addition to the operating system version, the other is the same, this in the restoration of the problem encountered at least, the steps are generally not a problem

The other is that the database has not been created on the virtual machine, and then a ORCL database can be created (the configuration options in the creation process should not matter, because the restore will be overwritten)

The following are detailed steps for the operation:

Step 1:

View the source host on the ORCL database needs to back up the various file locations, cold backup needs to be backed up including control files, parameter files, password files, data files, online redo log files

Control file

Sql:select * from V$controlfile

Result:

------------------------------

D:\ORACLE11G\ORADATA\ORCL\CONTROL01. Ctl

D:\ORACLE11G\FLASH_RECOVERY_AREA\ORCL\CONTROL02. Ctl

Parameter file

Sql:select * from V$parameter where name like '%spfile% '

Result:

------------------------------

D:\ORACLE11G\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL. ORA

Password file

D:\Oracle11g\product\11.2.0\dbhome_1\database\PWDorcl.ora

Data files

Sql:select * from V$datafile

Result:

------------------------------

D:\ORACLE11G\ORADATA\ORCL\SYSTEM01. Dbf

D:\ORACLE11G\ORADATA\ORCL\SYSAUX01. Dbf

D:\ORACLE11G\ORADATA\ORCL\UNDOTBS01. Dbf

D:\ORACLE11G\ORADATA\ORCL\USERS01. Dbf

D:\ORACLE11G\ORADATA\ORCL\EXAMPLE01. Dbf

D:\ORACLE11G\ORADATA\ORCL\STUDYDEMO_DATA01. Dbf

Redo Log Files Online

Sql:select * from V$logfile

Result:

------------------------------

D:\ORACLE11G\ORADATA\ORCL\REDO03. LOG

D:\ORACLE11G\ORADATA\ORCL\REDO02. LOG

D:\ORACLE11G\ORADATA\ORCL\REDO01. LOG

Back up the above files

Step 2:

Because the target machine only installed Oracle software, no database installed, so you need to build a database with the same name as the source host ORCL

The instance is started after the database is loaded and needs to be closed first (using the shutdown Immediate command)

Then you replicate the files that were backed up on the source host to the target host directory. So cold backup actually succeeded.

Then confirm the cold backup restore success by starting the database

Start the Listener first

To start the database again

Validation is no problem, restore succeeded