--基于ACTIVE DATABASE


1、创建pfile
  create pfile from spfile
添加
  log_archive_dest




复制完之后可删除


2、创建密码文件及文件夹


orapwd file=D:\app\product\11.2.0\dbhome_1\database\PWDTEST1.ora password=TEST1 entries=4


3、listener.ora、tnsnames.ora创建本地命名（如果不是同机，本地命名一定要在目标及辅助数据库进行命名，不然回报远程连接失败，备份不成功）


4、注册新实例


oradim –new –sid test1 –intpwd test1


5、创建spfile


create  spfile from pfile='D:\app\product\11.2.0\dbhome_1\database\inittest1.ora' 




6、连接rman 
 
rman  target sys/oracle@orcl  AUXILIARY  sys/test1@test1


CONNECT AUXILIARY SYS/sysdba@dupdb; # duplicate database instance




7、克隆数据库


--运行成功
run{   
set newname for datafile 1  to 'D:\APP\ORADATA\TEST1\SYSTEM01.DBF';                           
set newname for datafile 2  to 'D:\APP\ORADATA\TEST1\SYSAUX01.DBF';                           
set newname for datafile 3  to 'D:\APP\ORADATA\TEST1\UNDOTBS01.DBF';
set newname for datafile 4  to 'D:\APP\ORADATA\TEST1\USERS01.DBF';   
set newname for datafile 5  to 'D:\APP\ORADATA\TEST1\RMANTS.ORA';
set newname for tempfile 1  to 'D:\APP\ORADATA\TEST1\TEMP01.DBF';


duplicate target database to test1
  FROM ACTIVE DATABASE  
logfile   
group 1 ('D:\APP\ORADATA\TEST1\REDO01.LOG') size 10m,   
group 2 ('D:\APP\ORADATA\TEST1\REDO02.LOG') size 10m,   
group 3 ('D:\APP\ORADATA\TEST1\REDO03.LOG') size 10m;   
switch datafile all;   
}   
--修改实例名称 
alter system  set db_name=test1 scope=spfile


----------------------------------供参考-------------------------------------------------
DUPLICATE DATABASE TO dupdb
  UNTIL TIME "TO_DATE('11/01/2007 14:00:00', 'MM/DD/YYYY HH24:MI:SS')"
  SPFILE
  BACKUP LOCATION '/prod_backups'
  NOFILENAMECHECK;




DUPLICATE TARGET DATABASE TO dupdb
  FROM ACTIVE DATABASE
  PASSWORD FILE
  SPFILE
  NOFILENAMECHECK;


RUN
{
  SET NEWNAME FOR DATABASE TO 'D:/oradata/test1/%U'; 
  DUPLICATE TARGET DATABASE TO test1
     FROM ACTIVE DATABASE
    LOGFILE
      GROUP 1 ('D:/oradata/redo01a.log', 
               'D:/oradata/redo01b.log') SIZE 4M REUSE, 
      GROUP 2 ('D:/oradata/redo02a.log', 
               'D:/oradata/redo02b.log') SIZE 4M REUSE;
}




duplicate target database to test1 pfile =D:\app\product\11.2.0\dbhome_1\database\inittest1.ora 


logfile


'D:/oradata/test1/redo01.log' size 50m,


'D:/oradata/test1/redo02.log' size 50m,


'D:/oradata/test1/redo03.log' size 50m


NOFILENAMECHECK;


--修改实例名称 alter system  set db_name=test1 scope=spfile


 run{
allocate auxiliary channel ch1 device type disk;
duplicate target database to test1 NOFILENAMECHECK ;
}




rman  target sys/oracle@orcl  AUXILIARY  sys/test1@test1