Oracle数据库迁移之二：Duplicate

<div class="preview-main">
数据库的迁移方式千变万化，各有千秋。今天为大家呈现的是第二种方法，利用RMAN中的Duplicate来完成数据库的迁移工作。 1.创建目标数据库的辅助实例 为了使用迁移后的数据库，我们首先创建一个辅助实例。 1）创建参数文件 在本文中，我们将原数据库的参数文件和口令文件拷贝过来。 
[oracle@ENMOEDU ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/ [oracle@ENMOEDU dbs]$ ls hc_ENMOEDU.dat initENMOEDU.ora init.ora lkENMOEDU orapwENMOED spfileENMOEDU.ora 
 [oracle@ENMOEDU dbs]$ scp orapwENMOEDU spfileENMOEDU.ora oracle@192.168.80.27:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/ The authenticity of host '192.168.80.27 (192.168.80.27)' can't be established. RSA key fingerprint is db:39:d8:4c:81:41:aa:a3:e5:be:bc:60:f5:b6:43:56. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '192.168.80.27' (RSA) to the list of known hosts. oracle@192.168.80.27's password: orapwENMOEDU 100% 1536 1.5KB/s 00:00 spfileENMOEDU.ora 100% 2560 2.5KB/s 00:00 在备库中查询传输过来的文件。 [oracle@FRANK dbs]$ ls hc_FRANK.dat init.ora lkFRANK orapwENMOEDU orapwFRANK spfileENMOEDU.ora spfileFRANK.or 至此，口令文件和参数文件传输成功。 2）修改参数文件 [oracle@FRANK dbs]$ mv orapwENMOEDU orapwDBFRANK [oracle@FRANK dbs]$ mv spfileENMOEDU.ora spfileDBFRANK.ora [oracle@FRANK dbs]$ ls hc_FRANK.dat init.ora lkFRANK orapwDBFRANK orapwFRANK spfileDBFRANK.ora spfileFRANK.ora 创建pfile [oracle@FRANK dbs]$ export ORACLE_SID=DBFRANK [oracle@FRANK dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 8 00:31:40 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> create pfile from spfile; File created. [oracle@FRANK dbs]$ vi initDBFRANK.ora 将pfile中的ENMOEDU全部替换为DBFRANK，然后重新创建spfile. [oracle@FRANK dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 8 00:39:45 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> create spfile from pfile; File created. 3）创建所需要的目录 [oracle@FRANK dbs]$ cd /u01/app/oracle/admin/ [oracle@FRANK admin]$ mkdir -p DBFRANK/adump [oracle@FRANK DBFRANK]$ cd /u01/app/oracle/fast_recovery_area/ [oracle@FRANK fast_recovery_area]$ mkdir DBFRANK [oracle@FRANK fast_recovery_area]$ cd /u01/app/oracle/oradata/ [oracle@FRANK oradata]$ mkdir DBFRANK 4)启动辅助实例 [oracle@FRANK oradata]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 8 00:46:21 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 422670336 bytes Fixed Size 1345380 bytes Variable Size 335546524 bytes Database Buffers 79691776 bytes Redo Buffers 6086656 bytes 辅助实例在目标数据库上启动成功。 5）在原数据库上连接目标数据库的辅助实例 首先要配置目标数据库上的tnsname.ora文件 [oracle@ENMOEDU dbs]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/ [oracle@ENMOEDU admin]$ vi tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ENMOEDU = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.10)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ENMOEDU) ) ) DBFRANK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.27)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME