redo01.log 100% 50MB 5.6MB/s 00:09

redo02.log 100% 50MB 6.3MB/s 00:08

redo03.log 100% 50MB 5.0MB/s 00:10

sysaux01.dbf 100% 510MB 4.2MB/s 02:01

system01.dbf 100% 710MB 5.3MB/s 02:13

temp01.dbf 100% 29MB 5.8MB/s 00:05

undotbs01.dbf 100% 75MB 5.0MB/s 00:15

users01.dbf 100%5128KB 5.0MB/s 00:01

6. 将source 端的初始化文件和口令文件copy到target 端

SQL> create pfile from spfile;

File created.

[oracle@tianlesoftware dbs]$ scp initanqing.ora 192.168.3.201:/u02/app/oracle/product/11.2.0/db_1/dbs

oracle@192.168.3.201's password:

initanqing.ora 100% 1017 1.0KB/s 00:00

7. 在Target 端修改初始化文件

修改的内容包括控制文件保存位置，user_dump_dest,background_dump_dest,core_dump_dest 等。

修改之后如下：

rac1:/u02/app/oracle/product/11.2.0/db_1/dbs>cat initanqing.ora

anqing.__db_cache_size=570425344

anqing.__java_pool_size=16777216

anqing.__large_pool_size=16777216

anqing.__oracle_base='/u02/app/oracle'#ORACLE_BASEset from environment

anqing.__pga_aggregate_target=570425344

anqing.__sga_target=838860800

anqing.__shared_io_pool_size=0

anqing.__shared_pool_size=218103808

anqing.__streams_pool_size=0

*.audit_file_dest='/u02/app/oracle/admin/anqing/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u02/app/oracle/oradata/anqing/control01.ctl','/u02/app/oracle/fast_recovery_area/anqing/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='anqing'

*.db_recovery_file_dest='/u02/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4194304000

*.diagnostic_dest='/u02/app/oracle'

*.dispatchers='(PROTOCOL=TCP)(SERVICE=anqingXDB)'

*.log_archive_dest_1='LOCATION=/u02/archivelog'

*.log_archive_format='%t_%s_%r.arc'

*.memory_target=1393557504

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

8. 在Target 端重建控制文件

在重建控制之前先rm 掉我们从Source 端copy 过来的控制文件，同时修改我们的控制文件代码，使路径使用Target 的路径。

rac1:/u02/app/oracle/oradata/anqing> ls

control01.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbf

redo01.log redo03.log system01.dbf undotbs01.dbf

rac1:/u02/app/oracle/oradata/anqing> rmcontrol01.ctl

rac1:/u02/app/oracle/oradata/anqing> rmtemp01.dbf

rac1:/u02/app/oracle/oradata/anqing> ls

redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf undotbs01.dbf users01.dbf

--使用pfile 启动DB 致nomout 状态：

rac1:/u02/app/oracle/oradata/anqing>sqlplus / as sysdba