oracle迁移数据库 rman,通过rman全库备份迁移数据库

这一篇文章中，将讲述通过一个rman的完整全库备份来作数据库的迁移。

(使用的备份在上一篇博文中：http://blog.itpub.net/31392094/viewspace-2128466/)

---设备：

主机：oracle (HOST = 192.168.2.4)作为A库：target database: ORA11GR2 (DBID=238796283)

主机：enmo(HOST = 192.168.2.6)作为B库：target database:ORA11GR2 (DBID=238796283)

---在B库创建对应的目录存放备份文件并复制A库所有的备份文件：

[oracle@enmo app]$ cd backup

[oracle@enmo backup]$ pwd

/u01/app/backup

[oracle@enmo backup]$ scp 192.168.2.4:/u01/app/backup/db_0ari1305_1_1.rmn .

[email protected]'s password:

db_0ari1305_1_1.rmn                                                                100% 1225MB   7.4MB/s   02:46

[oracle@enmo backup]$ scp 192.168.2.4:/u01/app/backup/db_0bri135o_1_1.rmn .

[email protected]'s password:

db_0bri135o_1_1.rmn                                                                100% 9568KB   9.3MB/s   00:00

[oracle@enmo backup]$ ls

db_0ari1305_1_1.rmn  db_0bri135o_1_1.rmn  db_2grhjt7j_1_1.rmn  system01.dbf

[oracle@enmo ~]$

[oracle@enmo ~]$ mkdir -p /u01/app/FRA/ORA11GR2/autobackup/2016_10_10/

[oracle@enmo ~]$ cd /u01/app/FRA/ORA11GR2/autobackup/2016_10_10/

[oracle@enmo 2016_10_10]$ ls

[oracle@enmo 2016_10_10]$ scp 192.168.2.4:/u01/app/FRA/ORA11GR2/autobackup/2016_10_10/o1_mf_s_924880064_czphl11d_.bkp .

[email protected]'s password:

o1_mf_s_924880064_czphl11d_.bkp                                                           100% 9600KB   9.4MB/s   00:01

[oracle@enmo 2016_10_10]$ ls

o1_mf_s_924880064_czphl11d_.bkp

---设置B库空库的实例名：

[oracle@enmo ~]$ echo $ORACLE_SID

PROD

[oracle@enmo ~]$ export ORACLE_SID=OCMU

[oracle@enmo ~]$ echo $ORACLE_SID

OCMU

---使用rman进入一个空实例并制定dbid开启到nomount状态：

[oracle@enmo ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Oct 10 16:47:16 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> set dbid 238796283

executing command: SET DBID

RMAN> startup nomount;

startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initOCMU.ora'

starting Oracle instance without parameter file for retrieval of spfile

Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2260088 bytes

Variable Size                281019272 bytes