Restore OA System database--oracle11g migrate data via cold backup-(very simple, practical, especially when data is small) ____ Database

http://blog.csdn.net/xuejiayue1105/article/details/28423015

Restore OA System Database

-------oracle11g migrate data by cold backup

---------------(very simple, very practical, especially when the volume of data is very useful)

oracle11g database Cold backup and recovery

All data files, control files, online redo log files, parameter files, password files:

1. All data files select name from V$datafile

D:\app\Administrator\oradata This directory for me to install the data directory

2. All Control Documents

Sql> select * from V$controlfile;

My control file.

D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01. Ctl

D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02. Ctl

3. All online redo log files

SELECT * from V$logfile;

My log file

D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03. LOG

D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02. LOG

D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01. LOG

4. parameter file and password file, new 10G above spfile old database copy init.ora file (optional)

It is best to back up the entire directory of parameters (parameter file, password file Pwdorcl.ora)

My parameter file

SELECT * from V$parameter where name like '%spfile% '

D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEECOLOGY. ORA

My parameter file directory

D:\Oracle11g\product\11.2.0\dbhome_1\database\

After the work is done, look at show parameter all the parameters ...

Look at the character set

Sql> select * from V$nls_parameters;

It is best to make the character set consistent.

It is worth noting that cold backups must be done in the case of a database shutdown and that performing a database file system backup is not valid when the database is open.

Target machine If it is possible to recommend that the target machine only has Oracle software installed and does not have a database installed, you need to build a database with the same name as the source host

If it is already established, it is recommended that you delete the startup DBCA Delete the original database, establish the database with the same name as the source data, and now the DBCA has a very friendly interface, you need to enter a user sys user with SYSDBA permissions.

And then all the way to the next step,

Re-establish a

The following is a complete example of a cold backup.

Why rebuild here? In fact, can also be manually configured, but the benefits of reconstruction are all aspects of the canonical example of the system of services he can help you build up, the configuration is correct, and you can do an empty database cold backup, later to do test.

(1) Close the database

Sqlplus/nolog

Sql>connect/as SYSDBA

Sql>shutdown Normal;

(2) Copy command to back up all the data files, redo log files, control files, initialization parameters file

copy sticky paste

(3) Restart Oracle database

Sql>startup

Ok