基于RMAN的异机数据库克隆(rman duplicate)(三)
database/sybo3/oradata/undotbs01.dbf",
"/u01/database/sybo3/oradata/users01.dbf",
"/u01/database/sybo3/oradata/example01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/database/sybo3/oradata/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/sysaux01.dbf RECID=1 STAMP=822223994
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/undotbs01.dbf RECID=2 STAMP=822223994
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/users01.dbf RECID=3 STAMP=822223994
cataloged datafile copy
datafile copy file name=/u01/database/sybo3/oradata/example01.dbf RECID=4 STAMP=822223994
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=822223994 file name=/u01/database/sybo3/oradata/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=822223994 file name=/u01/database/sybo3/oradata/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=822223994 file name=/u01/database/sybo3/oradata/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=822223994 file name=/u01/database/sybo3/oradata/example01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 31-JUL-13
--对于那些没有连接到target db或者catalog而使用duplicate方式克隆的数据库，必须要指定BACKUP LOCATION，否则收到如下错误提示。
--这是由于所有和备份相关的信息，包括备份位置都记录在catalog或controlfile里，但是duplicate方式发布命令时，此时controlfile还没有还原。
--RMAN-05546: DUPLICATE without TARGET and CATALOG connections requires that BACKUP LOCATION is specified
f、验证结果(根据需要创建监听)
[oracle@linux4 ~]$ sqlplus / as sysdba
SQL>
select instance_name,host_name from v$instance;
INSTANCE_NAME HOST_NAME
---------------- ------------------------------
sybo3 linux4.orasrv.com
SQL> select * from t;
NAME ACTION
---------- --------------------
Robinson Transfer DB
Jackson Transfer DB by rman
4、后记
a、在异机克隆时，如果auxiliary DB使用了与target DB相同的磁盘配置，目录结构以及文件名时，必须指定NOFILENAMECHECK。
NOFILENAMECHECK可以阻止检查target DB的数据文件及联机日志文件是否处于正常使用的状态。而auxiliary DB与target DB的磁盘配置，
目录结构以及文件名任一不同时，应避免使用NOFILENAMECHECK。
b、对于没有连接到target DB或catalog的情形，应使用BACKUP LOCATION ''指定备份文件所在的位置。