目标数据库：jadl0g
复制的结果数据库：d10g
注意：****目标库与clone结果库在同一台机子上****
1.vi /u01/oracle/10g/network/admin/tnsnames.ora
d10g =(description =(address = (protocol = tcp)(host = oracle.db.com)(port = 1521))(connect_data =(server = dedicated)(service_name = d10g))(failover = on))
2.vi /u01/oracle/10g/network/admin/listener.ora
sid_list_listener =(sid_list =(sid_desc =(global_dbname=jadl10g)(sid_name = jadl10g)(oracle_home = /u01/oracle/10g))(sid_desc =(global_dbname=d10g)(sid_name = d10g)(oracle_home = /u01/oracle/10g)))
3.重启监听
lsnrctl stoplsnrctl starttnsping d10gtnsping jadl10g
4.创建密码文件和参数文件
[oracle@oracle ~]$ cd /u01/oracle/10g/dbs/[oracle@oracle dbs]$ orapwd file=orapwd10g password=oracle[oracle@oracle dbs]$ strings spfilejadl10g.ora > initd10g.ora[oracle@oracle dbs]$ vi initd10g.ora:1,$ s/jadl10g/d10g/g---执行该命令[oracle@oracle dbs]$ grep u01 initd10g.ora*.audit_file_dest='/u01/oracle/admin/d10g/adump'*.background_dump_dest='/u01/oracle/admin/d10g/bdump'*.control_files='/u01/oracle/oradata/d10g/control01.ctl','/u01/oracle/flash_recovery_area/d10g/control02.ctl'#restore controlfile*.core_dump_dest='/u01/oracle/admin/d10g/cdump'*.db_recovery_file_dest='/u01/oracle/flash_recovery_area'*.user_dump_dest='/u01/oracle/admin/d10g/udump'5.创建相应的文件[oracle@oracle dbs]$ mkdir /u01/oracle/admin/d10g/adump -p[oracle@oracle dbs]$ mkdir /u01/oracle/admin/d10g/bdump -p[oracle@oracle dbs]$ mkdir /u01/oracle/admin/d10g/cdump -p[oracle@oracle dbs]$ mkdir /u01/oracle/admin/d10g/udump -p[oracle@oracle dbs]$ mkdir /u01/oracle/oradata/d10g[oracle@oracle dbs]$ export oracle_sid=d10g[oracle@oracle dbs]$ rman target /recovery manager: release 10.2.0.5.0 - production on fri nov 7 12:59:20 2014copyright (c) 1982, 2007, oracle. all rights reserved.connected to target database (not started)rman> startup nomountoracle instance startedtotal system global area 599785472 bytesfixed size 2098112 bytesvariable size 171969600 bytesdatabase buffers 419430400 bytesredo buffers 6287360 bytesrman> exitrecovery manager complete.[oracle@oracle dbs]$ sqlplus / as sysdbasql*plus: release 10.2.0.5.0 - production on fri nov 7 13:00:15 2014copyright (c) 1982, 2010, oracle. all rights reserved.connected to:oracle database 10g enterprise edition release 10.2.0.5.0 - 64bit productionwith the partitioning, oracle label security, olap, data mining scoring engineand real application testing optionssql> create spfile from pfile;file created.sql> shutdownora-01507: database not mountedoracle instance shut down.sql> startup nomountoracle instance started.total system global area 599785472 bytesfixed size 2098112 bytesvariable size 171969600 bytesdatabase buffers 419430400 bytesredo buffers 6287360 bytessql> exitdisconnected from oracle database 10g enterprise edition release 10.2.0.5.0 - 64bit productionwith the partitioning, oracle label security, olap, data mining scoring engineand real application testing options****************************[oracle@oracle dbs]$ rman target sys/oracle@jadl10g auxiliary sys/oracle@d10grecovery manager: release 10.2.0.5.0 - production on fri nov 7 13:26:11 2014copyright (c) 1982, 2007, oracle. all rights reserved.rman-00571: ===========================================================rman-00569: =============== error message stack follows ===============rman-00571: ===========================================================rman-00554: initialization of internal recovery manager package failedrman-04005: error from target database:ora-01031: insufficient privileges
这个错误是由于我的目标数据库没有密码文件造成的。
解决方法就是创建密码文件
[oracle@oracle dbs]$ orapwd file=orapwjadl10g password=oracle****************************[oracle@oracle dbs]$ rman target sys/oracle@jadl10g auxiliary sys/oracle@d10grecovery manager: release 10.2.0.5.0 - production on fri nov 7 13:34:12 2014copyright (c) 1982, 2007, oracle. all rights reserved.connected to target database: jadl10g (dbid=2011530396)connected to auxiliary database: d10g (not mounted)执行如下命令(注意必须是远程和本地的顺序)：rman> duplicate target database to d10g nofilenamecheck2> db_file_name_convert('/u01/oracle/oradata/jadl10g/','/u01/oracle/oradata/d10g/')3> logfile '/u01/oracle/oradata/d10g/redo01.log' size 10m,4> '/u01/oracle/oradata/d10g/redo02.log' size 10m;starting duplicate db at 07-nov-14using target database control file instead of recovery catalogallocated channel: ora_aux_disk_1channel ora_aux_disk_1: sid=156 devtype=diskcontents of memory script:{set until scn 556591;set newname for datafile 1 to/u01/oracle/oradata/d10g/system01.dbf;set newname for datafile 2 to/u01/oracle/oradata/d10g/undotbs01.dbf;set newname for datafile 3 to/u01/oracle/oradata/d10g/sysaux01.dbf;set newname for datafile 4 to/u01/oracle/oradata/d10g/users01.dbf;set newname for datafile 5 to/u01/oracle/oradata/d10g/example01.dbf;restorecheck readonlyclone database;}executing memory scriptexecuting command: set until clauseexecuting command: set newnameexecuting command: set newnameexecuting command: set newnameexecuting command: set newnameexecuting command: set newnamestarting restore at 07-nov-14using channel ora_aux_disk_1skipping datafile 1; alrea【本文来自鸿网互联 (http://www.68idc.cn)】dy restored to file /u01/oracle/oradata/d10g/system01.dbfskipping datafile 2; already restored to file /u01/oracle/oradata/d10g/undotbs01.dbfskipping datafile 3; already restored to file /u01/oracle/oradata/d10g/sysaux01.dbfskipping datafile 4; already restored to file /u01/oracle/oradata/d10g/users01.dbfskipping datafile 5; already restored to file /u01/oracle/oradata/d10g/example01.dbfrestore not done; all files readonly, offline, or already restoredfinished restore at 07-nov-14sql statement: create controlfile reuse set database d10g resetlogs archivelogmaxlogfiles 16maxlogmembers 3maxdatafiles 100maxinstances 8maxloghistory 292logfilegroup 1 '/u01/oracle/oradata/d10g/redo01.log' size 10 m ,group 2 '/u01/oracle/oradata/d10g/redo02.log' size 10 mdatafile'/u01/oracle/oradata/d10g/system01.dbf'character set al32utf8contents of memory script:{switch clone datafile all;}executing memory scriptdatafile 2 switched to datafile copyinput datafile copy recid=1 stamp=863013896 filename=/u01/oracle/oradata/d10g/undotbs01.dbfdatafile 3 switched to datafile copyinput datafile copy recid=2 stamp=863013896 filename=/u01/oracle/oradata/d10g/sysaux01.dbfdatafile 4 switched to datafile copyinput datafile copy recid=3 stamp=863013896 filename=/u01/oracle/oradata/d10g/users01.dbfdatafile 5 switched to datafile copyinput datafile copy recid=4 stamp=863013896 filename=/u01/oracle/oradata/d10g/example01.dbfcontents of memory script:{set until scn 556591;recoverclone databasedelete archivelog;}executing memory scriptexecuting command: set until clausestarting recover at 07-nov-14using channel ora_aux_disk_1starting media recoveryarchive log thread 1 sequence 1 is already on disk as file /u01/oracle/flash_recovery_area/jadl10g/archivelog/2014_11_07/o1_mf_1_1_b5qkpgh1_.arcarchive log thread 1 sequence 2 is already on disk as file /u01/oracle/flash_recovery_area/jadl10g/archivelog/2014_11_07/o1_mf_1_2_b5qkpk0o_.arcarchive log thread 1 sequence 1 is already on disk as file /u01/oracle/flash_recovery_area/jadl10g/archivelog/2014_11_07/o1_mf_1_1_b5rqvjwq_.arcarchive log thread 1 sequence 2 is already on disk as file /u01/oracle/flash_recovery_area/jadl10g/archivelog/2014_11_07/o1_mf_1_2_b5rqvmxf_.arcarchive log filename=/u01/oracle/flash_recovery_area/jadl10g/archivelog/2014_11_07/o1_mf_1_1_b5qkpgh1_.arc thread=1 sequence=1archive log filename=/u01/oracle/flash_recovery_area/jadl10g/archivelog/2014_11_07/o1_mf_1_2_b5qkpk0o_.arc thread=1 sequence=2media recovery complete, elapsed time: 00:00:23finished recover at 07-nov-14contents of memory script:{shutdown clone;startup clone nomount ;}executing memory scriptdatabase dismountedoracle instance shut downconnected to auxiliary database (not started)oracle instance startedtotal system global area 599785472 bytesfixed size 2098112 bytesvariable size 171969600 bytesdatabase buffers 419430400 bytesredo buffers 6287360 bytessql statement: create controlfile reuse set database d10g resetlogs archivelogmaxlogfiles 16maxlogmembers 3maxdatafiles 100maxinstances 8maxloghistory 292logfilegroup 1 '/u01/oracle/oradata/d10g/redo01.log' size 10 m ,group 2 '/u01/oracle/oradata/d10g/redo02.log' size 10 mdatafile'/u01/oracle/oradata/d10g/system01.dbf'character set al32utf8contents of memory script:{set newname for tempfile 1 to/u01/oracle/oradata/d10g/temp01.dbf;switch clone tempfile all;catalog clone datafilecopy /u01/oracle/oradata/d10g/undotbs01.dbf;catalog clone datafilecopy /u01/oracle/oradata/d10g/sysaux01.dbf;catalog clone datafilecopy /u01/oracle/oradata/d10g/users01.dbf;catalog clone datafilecopy /u01/oracle/oradata/d10g/example01.dbf;switch clone datafile all;}executing memory scriptexecuting command: set newnamerenamed temporary file 1 to /u01/oracle/oradata/d10g/temp01.dbf in control filecataloged datafile copydatafile copy filename=/u01/oracle/oradata/d10g/undotbs01.dbf recid=1 stamp=863013929cataloged datafile copydatafile copy filename=/u01/oracle/oradata/d10g/sysaux01.dbf recid=2 stamp=863013929cataloged datafile copydatafile copy filename=/u01/oracle/oradata/d10g/users01.dbf recid=3 stamp=863013929cataloged datafile copydatafile copy filename=/u01/oracle/oradata/d10g/example01.dbf recid=4 stamp=863013929datafile 2 switched to datafile copyinput datafile copy recid=1 stamp=863013929 filename=/u01/oracle/oradata/d10g/undotbs01.dbfdatafile 3 switched to datafile copyinput datafile copy recid=2 stamp=863013929 filename=/u01/oracle/oradata/d10g/sysaux01.dbfdatafile 4 switched to datafile copyinput datafile copy recid=3 stamp=863013929 filename=/u01/oracle/oradata/d10g/users01.dbfdatafile 5 switched to datafile copyinput datafile copy recid=4 stamp=863013929 filename=/u01/oracle/oradata/d10g/example01.dbfcontents of memory script:{alter clone database open resetlogs;}executing memory scriptdatabase openedfinished duplicate db at 07-nov-14rman> exitrecovery manager complete.验证是否clone成功：[oracle@oracle dbs]$ sqlplus / as sysdbasql*plus: release 10.2.0.5.0 - production on fri nov 7 14:21:20 2014copyright (c) 1982, 2010, oracle. all rights reserved.connected to:oracle database 10g enterprise edition release 10.2.0.5.0 - 64bit productionwith the partitioning, oracle label security, olap, data mining scoring engineand real application testing optionssql> select instance_name from v$instance;instance_name----------------d10g
1.密码文件问题
2.网络问题
3.参数问题
4.rman语句 db_file_name_convert 在同一个服务器设置语法有问题
5.注意必须要有备份，远程的话需要copy备份到目标库