Oracle：Clone Oracle 10g DB By Rman Duplicate
源库：192.168.221.165/orcl:1521
目标库：192.168.221.166（No Instance：重设为_alice）
在开始前，首先在源库创建测试数据：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
[oracle@CenterServer ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 18 00:19:16 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ orcl OPEN SQL> show parameter db_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_name string orcl SQL> SQL> select * from scott.dept; DEPTNO DNAME LOC ---------- -------------- ------------- 89 Allah Yuan MY Guang Xi 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options [oracle@CenterServer ~]$ |
首先，将源库的实例相关文件SCP到目标库所在服务器的对应位置，并作出响应的修改（实例名从原“orcl”，修改为“alice”）。
系统参数文件：
Source：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
[oracle@CenterServer ~]$ whoami oracle [oracle@CenterServer ~]$ pwd /home/oracle [oracle@CenterServer ~]$ ls initbackme.ora install_media sqlnet.log [oracle@CenterServer ~]$ [oracle@CenterServer ~]$ ps -ef | grep ora_ oracle 4125 1 0 21:26 ? 00:00:00 ora_pmon_orcl oracle 4127 1 0 21:26 ? 00:00:00 ora_psp0_orcl oracle 4129 1 0 21:26 ? 00:00:00 ora_mman_orcl oracle 4131 1 0 21:26 ? 00:00:00 ora_dbw0_orcl oracle 4133 1 0 21:26 ? 00:00:00 ora_lgwr_orcl oracle 4135 1 0 21:26 ? 00:00:00 ora_ckpt_orcl oracle 4137 1 0 21:26 ? 00:00:00 ora_smon_orcl oracle 4139 1 0 21:26 ? 00:00:00 ora_reco_orcl oracle 4141 1 0 21:26 ? 00:00:00 ora_cjq0_orcl oracle 4143 1 0 21:26 ? 00:00:00 ora_mmon_orcl oracle 4145 1 0 21:26 ? 00:00:00 ora_mmnl_orcl oracle 4147 1 0 21:26 ? 00:00:00 ora_d000_orcl oracle 4149 1 0 21:26 ? 00:00:00 ora_s000_orcl oracle 4200 1 0 21:29 ? 00:00:00 ora_arc0_orcl oracle 4202 1 0 21:29 ? 00:00:00 ora_arc1_orcl oracle 4206 1 0 21:29 ? 00:00:00 ora_qmnc_orcl oracle 4230 1 0 21:30 ? 00:00:00 ora_q004_orcl oracle 4232 1 0 21:30 ? 00:00:00 ora_q005_orcl oracle 4684 1 0 22:46 ? 00:00:00 ora_j000_orcl oracle 4687 4406 0 22:46 pts/1 00:00:00 grep ora_ [oracle@CenterServer ~]$ [oracle@CenterServer ~]$ env | grep SID ORACLE_SID=orcl [oracle@CenterServer ~]$ [oracle@CenterServer ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 17 22:47:05 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ orcl OPEN SQL> SQL> create pfile='/home/oracle/initorcl.ora' from spfile; File created. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options [oracle@CenterServer ~]$ ls initbackme.ora initorcl.ora install_media sqlnet.log [oracle@CenterServer ~]$ [oracle@CenterServer ~]$ ls $ORACLE_HOME/dbs -l total 6952 -rw-r----- 1 oracle oinstall 1552 Jun 17 21:29 hc_orcl.dat -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 24 Jun 17 20:07 lkORCL -rw-r----- 1 oracle oinstall 1536 Jun 17 20:08 orapworcl -rw-r----- 1 oracle oinstall 7061504 Jun 17 22:09 snapcf_orcl.f -rw-r----- 1 oracle oinstall 2560 Jun 17 22:00 spfileorcl.ora [oracle@CenterServer ~]$ scp initorcl.ora ora10g:$ORACLE_HOME/dbs oracle@ora10g's password: initorcl.ora 100% 942 0.9KB/s 00:00 [oracle@CenterServer ~]$ |
Target：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 |
[root@ora10g admin]# su - oracle [oracle@ora10g ~]$ ls $ORACLE_HOME/dbs hc_backme.dat hc_bob.dat initbackme.ora initdw.ora init.ora lkBACKME [oracle@ora10g ~]$ [oracle@ora10g ~]$ ls $ORACLE_HOME/dbs -l total 48 -rw-rw---- 1 oracle oinstall 1552 Jun 17 22:43 hc_backme.dat -rw-r----- 1 oracle oinstall 1552 Jun 17 22:10 hc_bob.dat -rw-r--r-- 1 oracle oinstall 970 Jun 17 22:16 initbackme.ora -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 942 Jun 17 22:48 initorcl.ora -rw-rw---- 1 oracle oinstall 24 Jun 17 22:22 lkBACKME [oracle@ora10g ~]$ 源文件： [oracle@ora10g ~]$ cat /u01/app/oracle/product/10g/dbhome_1/dbs/initorcl.ora orcl.__db_cache_size=356515840 orcl.__java_pool_size=4194304 orcl.__large_pool_size=4194304 orcl.__shared_pool_size=167772160 orcl.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/orcl/adump' *.background_dump_dest='/u01/app/oracle/admin/orcl/bdump' *.compatible='10.2.0.1.0' *.control_files='/oradata/orcl/control01.ctl','/oradata/orcl/control02.ctl','/oradata/orcl/control03.ctl' *.core_dump_dest='/u01/app/oracle/admin/orcl/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='orcl' *.db_recovery_file_dest_size=2147483648 *.db_recovery_file_dest='/oradata/flash_recovery_area' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)' *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=402653184 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=536870912 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/oracle/admin/orcl/udump' [oracle@ora10g ~]$ 修改后： [oracle@ora10g ~]$ cat /u01/app/oracle/product/10g/dbhome_1/dbs/initorcl.ora alice.__db_cache_size=356515840 alice.__java_pool_size=4194304 alice.__large_pool_size=4194304 alice.__shared_pool_size=167772160 alice.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/alice/adump' *.background_dump_dest='/u01/app/oracle/admin/alice/bdump' *.compatible='10.2.0.1.0' *.control_files='/u01/app/oracle/oradata/alice/control01.ctl','/u01/app/oracle/oradata/alice/control02.ctl','/u01/app/oracle/oradata/alice/control03.ctl' *.core_dump_dest='/u01/app/oracle/admin/alice/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='alice' *.db_recovery_file_dest_size=2147483648 *.db_recovery_file_dest='/oradata/flash_recovery_area' *.dispatchers='(PROTOCOL=TCP) (SERVICE=aliceXDB)' *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=402653184 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=536870912 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/oracle/admin/alice/udump' *.db_file_name_convert='/oradata/orcl/','/u01/app/oracle/oradata/alice' *.log_file_name_convert='/oradata/orcl/','/u01/app/oracle/oradata/alice' [oracle@ora10g ~]$ mv /u01/app/oracle/product/10g/dbhome_1/dbs/initorcl.ora /u01/app/oracle/product/10g/dbhome_1/dbs/initalice.ora [oracle@ora10g ~]$ [oracle@ora10g ~]$ ls -ltr /u01/app/oracle/product/10g/dbhome_1/dbs/ total 52 -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 1552 Jun 17 22:10 hc_bob.dat -rw-r--r-- 1 oracle oinstall 970 Jun 17 22:16 initbackme.ora -rw-rw---- 1 oracle oinstall 24 Jun 17 22:22 lkBACKME -rw-rw---- 1 oracle oinstall 1552 Jun 17 22:43 hc_backme.dat -rw-r----- 1 oracle oinstall 1536 Jun 17 22:50 orapworcl -rw-r--r-- 1 oracle oinstall 955 Jun 17 22:55 initalice.ora [oracle@ora10g ~]$ |
上面参数文件中的“alice”实例的新增目录都需要在目标库的服务器上预先创建出来：
|
1 2 3 4 |
[oracle@ora10g ~]$ mkdir -p /u01/app/oracle/oradata/alice [oracle@ora10g ~]$ [oracle@ora10g ~]$ mkdir -p /u01/app/oracle/admin/alice/{adump,bdump,cdump,udump} [oracle@ora10g ~]$ |
密码文件：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@CenterServer ~]$ scp $ORACLE_HOME/dbs/orapworcl ora10g:$ORACLE_HOME/dbs oracle@ora10g's password: orapworcl 100% 1536 1.5KB/s 00:00 [oracle@CenterServer ~]$ 目标库，还需要对密码文件重命名： [oracle@ora10g ~]$ cd $ORACLE_HOME/dbs [oracle@ora10g dbs]$ ls hc_alice.dat hc_bob.dat initbackme.ora init.ora lkORCL spfilealice.ora hc_backme.dat initalice.ora initdw.ora lkBACKME orapworcl [oracle@ora10g dbs]$ [oracle@ora10g dbs]$ cp orapworcl orapwalice [oracle@ora10g dbs]$ |
监听文件：
tnsnames.ora
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
[oracle@CenterServer ~]$ cat /u01/app/oracle/product/10g/dbhome_1/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10g/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = CenterServer)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) BOB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora10g)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bob) ) ) ALICE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora10g)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = alice) ) ) [oracle@CenterServer ~]$ scp /u01/app/oracle/product/10g/dbhome_1/network/admin/tnsnames.ora ora10g:$ORACLE_HOME/network/admin oracle@ora10g's password: tnsnames.ora 100% 698 0.7KB/s 00:00 [oracle@CenterServer ~]$ |
listener.ora
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 |
[oracle@ora10g ~]$ cat $ORACLE_HOME/network/admin/listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/10g/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10g/dbhome_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = backme) (ORACLE_HOME = /u01/app/oracle/product/10g/dbhome_1) (SID_NAME = backme) ) (SID_DESC = (GLOBAL_DBNAME = alice) (ORACLE_HOME = /u01/app/oracle/product/10g/dbhome_1) (SID_NAME = alice) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = ora10g)(PORT = 1521)) ) ) [oracle@ora10g ~]$ [oracle@ora10g ~]$ lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-JUN-2015 23:07:18 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 17-JUN-2015 21:59:10 Uptime 0 days 1 hr. 8 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/10g/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/10g/dbhome_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora10g)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "backme" has 1 instance(s). Instance "backme", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@ora10g ~]$ [oracle@ora10g ~]$ lsnrctl reload LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-JUN-2015 23:07:23 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) The command completed successfully [oracle@ora10g ~]$ [oracle@ora10g ~]$ lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-JUN-2015 23:07:35 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 17-JUN-2015 21:59:10 Uptime 0 days 1 hr. 8 min. 25 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/10g/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/10g/dbhome_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora10g)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "alice" has 1 instance(s). Instance "alice", status UNKNOWN, has 1 handler(s) for this service... Service "backme" has 1 instance(s). Instance "backme", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@ora10g ~]$ [oracle@ora10g ~]$ tnsping alice TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 17-JUN-2015 23:08:59 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /u01/app/oracle/product/10g/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora10g)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = alice))) OK (10 msec) [oracle@ora10g ~]$ |
启动目标库的实例（ORACLE_SID = alice）：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
[oracle@ora10g ~]$ ps -ef | grep ora_ oracle 32174 31921 0 23:10 pts/2 00:00:00 grep ora_ [oracle@ora10g ~]$ export ORACLE_SID=alice [oracle@ora10g ~]$ [oracle@ora10g ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 17 23:12:40 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> !ls -ltr $ORACLE_HOME/dbs total 52 -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 1552 Jun 17 22:10 hc_bob.dat -rw-r--r-- 1 oracle oinstall 970 Jun 17 22:16 initbackme.ora -rw-rw---- 1 oracle oinstall 24 Jun 17 22:22 lkBACKME -rw-rw---- 1 oracle oinstall 1552 Jun 17 22:43 hc_backme.dat -rw-r----- 1 oracle oinstall 1536 Jun 17 22:50 orapworcl -rw-r--r-- 1 oracle oinstall 1146 Jun 17 23:12 initalice.ora SQL> SQL> create spfile from pfile; File created. SQL> !ls -ltr $ORACLE_HOME/dbs total 56 -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 1552 Jun 17 22:10 hc_bob.dat -rw-r--r-- 1 oracle oinstall 970 Jun 17 22:16 initbackme.ora -rw-rw---- 1 oracle oinstall 24 Jun 17 22:22 lkBACKME -rw-rw---- 1 oracle oinstall 1552 Jun 17 22:43 hc_backme.dat -rw-r----- 1 oracle oinstall 1536 Jun 17 22:50 orapworcl -rw-r--r-- 1 oracle oinstall 1146 Jun 17 23:12 initalice.ora -rw-r----- 1 oracle oinstall 3584 Jun 17 23:13 spfilealice.ora SQL> SQL> startup nomount; ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2022144 bytes Variable Size 176162048 bytes Database Buffers 356515840 bytes Redo Buffers 2170880 bytes SQL> SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ alice STARTED SQL> show parameter db_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_name string alice SQL> |
源库：
Rman创建一个全库备份：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
[oracle@CenterServer ~]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 17 23:16:20 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: ORCL (DBID=1410429159) RMAN> backup database format '/oradata/backup_me/all_backup_orcl_%d_%s.bak' plus archivelog; Starting backup at 17-JUN-2015 23:17:50 current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=152 devtype=DISK channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=3 recid=1 stamp=882648898 input archive log thread=1 sequence=4 recid=2 stamp=882648913 input archive log thread=1 sequence=5 recid=3 stamp=882648924 input archive log thread=1 sequence=6 recid=4 stamp=882653395 input archive log thread=1 sequence=7 recid=5 stamp=882655754 input archive log thread=1 sequence=8 recid=6 stamp=882655783 input archive log thread=1 sequence=9 recid=7 stamp=882659870 channel ORA_DISK_1: starting piece 1 at 17-JUN-2015 23:17:51 channel ORA_DISK_1: finished piece 1 at 17-JUN-2015 23:17:54 piece handle=/oradata/flash_recovery_area/ORCL/backupset/2015_06_17/o1_mf_annnn_TAG20150617T231750_br4rnhc8_.bkp tag=TAG20150617T231750 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04 Finished backup at 17-JUN-2015 23:17:54 Starting backup at 17-JUN-2015 23:17:54 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=/oradata/orcl/system01.dbf input datafile fno=00003 name=/oradata/orcl/sysaux01.dbf input datafile fno=00005 name=/oradata/orcl/example01.dbf input datafile fno=00002 name=/oradata/orcl/undotbs01.dbf input datafile fno=00004 name=/oradata/orcl/users01.dbf channel ORA_DISK_1: starting piece 1 at 17-JUN-2015 23:17:54 channel ORA_DISK_1: finished piece 1 at 17-JUN-2015 23:18:22 piece handle=/oradata/backup_me/all_backup_orcl_ORCL_10.bak tag=TAG20150617T231754 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:28 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current control file in backupset including current SPFILE in backupset channel ORA_DISK_1: starting piece 1 at 17-JUN-2015 23:18:22 channel ORA_DISK_1: finished piece 1 at 17-JUN-2015 23:18:23 piece handle=/oradata/backup_me/all_backup_orcl_ORCL_11.bak tag=TAG20150617T231754 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 17-JUN-2015 23:18:23 Starting backup at 17-JUN-2015 23:18:23 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=10 recid=8 stamp=882659903 channel ORA_DISK_1: starting piece 1 at 17-JUN-2015 23:18:24 channel ORA_DISK_1: finished piece 1 at 17-JUN-2015 23:18:25 piece handle=/oradata/flash_recovery_area/ORCL/backupset/2015_06_17/o1_mf_annnn_TAG20150617T231823_br4roj8b_.bkp tag=TAG20150617T231823 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 17-JUN-2015 23:18:25 RMAN> |
传到目标服务器：
由于生成的时候是放在“/oradata/backup_me/”，所以，在目标端，也应该放在同样的目录下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@CenterServer backup_me]$ pwd /oradata/backup_me [oracle@CenterServer backup_me]$ ls all_backup_orcl_ORCL_10.bak all_backup_orcl_ORCL_11.bak [oracle@CenterServer backup_me]$ du -sh * 605M all_backup_orcl_ORCL_10.bak 6.9M all_backup_orcl_ORCL_11.bak [oracle@CenterServer backup_me]$ [oracle@CenterServer backup_me]$ scp * ora10g:/software/backup oracle@ora10g's password: all_backup_orcl_ORCL_10.bak 100% 604MB 21.6MB/s 00:28 all_backup_orcl_ORCL_11.bak 100% 6976KB 6.8MB/s 00:00 [oracle@CenterServer backup_me]$ |
目标库服务器；
|
1 2 3 4 5 6 7 8 9 10 11 |
[root@ora10g oradata]# mkdir -p /oradata/backup_me/ [root@ora10g oradata]# chown -R oracle.oinstall /oradata/ [root@ora10g oradata]# su - oracle [oracle@ora10g ~]$ [oracle@ora10g ~]$ cp /software/backup/* /oradata/backup_me/ [oracle@ora10g ~]$ ls -l /oradata/backup_me/ total 626144 -rw-r----- 1 oracle oinstall 633389056 Jun 17 23:27 all_backup_orcl_ORCL_10.bak -rw-r----- 1 oracle oinstall 7143424 Jun 17 23:27 all_backup_orcl_ORCL_11.bak drwxr-xr-x 3 oracle oinstall 4096 Jun 17 22:05 ORCL [oracle@ora10g ~]$ |
源库的RMAN文件（/oradata/flash_recovery_area/ORCL/backupset）
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@CenterServer ~]$ ls -l /oradata/flash_recovery_area/ORCL/backupset/2015_06_17/ total 1921200 -rw-r----- 1 oracle oinstall 32367104 Jun 17 22:09 o1_mf_annnn_TAG20150617T220914_br4nmvfw_.bkp -rw-r----- 1 oracle oinstall 4096 Jun 17 22:09 o1_mf_annnn_TAG20150617T220943_br4nnrg6_.bkp -rw-r----- 1 oracle oinstall 35598848 Jun 17 23:17 o1_mf_annnn_TAG20150617T231750_br4rnhc8_.bkp -rw-r----- 1 oracle oinstall 76288 Jun 17 23:18 o1_mf_annnn_TAG20150617T231823_br4roj8b_.bkp -rw-r----- 1 oracle oinstall 7143424 Jun 17 21:28 o1_mf_ncsnf_TAG20150617T212717_br4l6ztm_.bkp -rw-r----- 1 oracle oinstall 7143424 Jun 17 21:31 o1_mf_ncsnf_TAG20150617T213130_br4lfsk5_.bkp -rw-r----- 1 oracle oinstall 7143424 Jun 17 22:09 o1_mf_ncsnf_TAG20150617T220918_br4nnpcl_.bkp -rw-r----- 1 oracle oinstall 621772800 Jun 17 21:28 o1_mf_nnndf_TAG20150617T212717_br4l55ww_.bkp -rw-r----- 1 oracle oinstall 621854720 Jun 17 21:31 o1_mf_nnndf_TAG20150617T213130_br4lf32p_.bkp -rw-r----- 1 oracle oinstall 632225792 Jun 17 22:09 o1_mf_nnndf_TAG20150617T220918_br4nmz0x_.bkp [oracle@CenterServer ~]$ |
目标库的RMAN文件（/oradata/flash_recovery_area/ORCL/backupset）
|
1 2 3 4 5 6 7 |
[oracle@ora10g ~]$ ls -l /oradata/flash_recovery_area/ORCL/backupset/2015_06_17/ total 1229656 -rw-r----- 1 oracle oinstall 7143424 Jun 17 22:05 o1_mf_ncsnf_TAG20150617T212717_br4l6ztm_.bkp -rw-r----- 1 oracle oinstall 7143424 Jun 17 22:05 o1_mf_ncsnf_TAG20150617T213130_br4lfsk5_.bkp -rw-r----- 1 oracle oinstall 621772800 Jun 17 22:05 o1_mf_nnndf_TAG20150617T212717_br4l55ww_.bkp -rw-r----- 1 oracle oinstall 621854720 Jun 17 22:05 o1_mf_nnndf_TAG20150617T213130_br4lf32p_.bkp [oracle@ora10g ~]$ |
SCP传输：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@CenterServer ~]$ scp /oradata/flash_recovery_area/ORCL/backupset/2015_06_17/* ora10g:/oradata/flash_recovery_area/ORCL/backupset/2015_06_17/ oracle@ora10g's password: o1_mf_annnn_TAG20150617T220914_br4nmvfw_.bkp 100% 31MB 30.9MB/s 00:01 o1_mf_annnn_TAG20150617T220943_br4nnrg6_.bkp 100% 4096 4.0KB/s 00:00 o1_mf_annnn_TAG20150617T231750_br4rnhc8_.bkp 100% 34MB 34.0MB/s 00:01 o1_mf_annnn_TAG20150617T231823_br4roj8b_.bkp 100% 75KB 74.5KB/s 00:00 o1_mf_ncsnf_TAG20150617T212717_br4l6ztm_.bkp 100% 6976KB 6.8MB/s 00:00 o1_mf_ncsnf_TAG20150617T213130_br4lfsk5_.bkp 100% 6976KB 6.8MB/s 00:00 o1_mf_ncsnf_TAG20150617T220918_br4nnpcl_.bkp 100% 6976KB 6.8MB/s 00:00 o1_mf_nnndf_TAG20150617T212717_br4l55ww_.bkp 100% 593MB 18.5MB/s 00:32 o1_mf_nnndf_TAG20150617T213130_br4lf32p_.bkp 100% 593MB 34.9MB/s 00:17 o1_mf_nnndf_TAG20150617T220918_br4nmz0x_.bkp 100% 603MB 17.7MB/s 00:34 [oracle@CenterServer ~]$ |
Rman：连接目标库（ORCL）辅助库（ALICE）：
|
1 2 3 4 5 6 7 8 9 10 |
[oracle@CenterServer ORCL]$ rman target / auxiliary sys/oracle@alice Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 17 23:47:40 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: ORCL (DBID=1410429159) connected to auxiliary database: ALICE (not mounted) RMAN> |
执行DUPLICATE：
Command：duplicate target database to alice;
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 |
[oracle@CenterServer ORCL]$ rman target / auxiliary sys/oracle@alice Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 18 00:07:30 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: ORCL (DBID=1410429159) connected to auxiliary database: ALICE (not mounted) RMAN> duplicate target database to alice; Starting Duplicate Db at 18-JUN-2015 00:07:40 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=155 devtype=DISK contents of Memory Script: { set until scn 593607; set newname for datafile 1 to "/u01/app/oracle/oradata/alice/system01.dbf"; set newname for datafile 2 to "/u01/app/oracle/oradata/alice/undotbs01.dbf"; set newname for datafile 3 to "/u01/app/oracle/oradata/alice/sysaux01.dbf"; set newname for datafile 4 to "/u01/app/oracle/oradata/alice/users01.dbf"; set newname for datafile 5 to "/u01/app/oracle/oradata/alice/example01.dbf"; restore check readonly clone database ; } executing Memory Script executing command: SET until clause executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 18-JUN-2015 00:07:40 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/app/oracle/oradata/alice/system01.dbf restoring datafile 00002 to /u01/app/oracle/oradata/alice/undotbs01.dbf restoring datafile 00003 to /u01/app/oracle/oradata/alice/sysaux01.dbf restoring datafile 00004 to /u01/app/oracle/oradata/alice/users01.dbf restoring datafile 00005 to /u01/app/oracle/oradata/alice/example01.dbf channel ORA_AUX_DISK_1: reading from backup piece /oradata/backup_me/all_backup_orcl_ORCL_10.bak channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/oradata/backup_me/all_backup_orcl_ORCL_10.bak tag=TAG20150617T231754 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:32 Finished restore at 18-JUN-2015 00:08:12 sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ALICE" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 ( '/u01/app/oracle/oradata/alice/redo01.log' ) SIZE 50 M REUSE, GROUP 2 ( '/u01/app/oracle/oradata/alice/redo02.log' ) SIZE 50 M REUSE, GROUP 3 ( '/u01/app/oracle/oradata/alice/redo03.log' ) SIZE 50 M REUSE DATAFILE '/u01/app/oracle/oradata/alice/system01.dbf' CHARACTER SET ZHS16GBK contents of Memory Script: { switch clone datafile all; } executing Memory Script released channel: ORA_AUX_DISK_1 datafile 2 switched to datafile copy input datafile copy recid=1 stamp=882662894 filename=/u01/app/oracle/oradata/alice/undotbs01.dbf datafile 3 switched to datafile copy input datafile copy recid=2 stamp=882662894 filename=/u01/app/oracle/oradata/alice/sysaux01.dbf datafile 4 switched to datafile copy input datafile copy recid=3 stamp=882662894 filename=/u01/app/oracle/oradata/alice/users01.dbf datafile 5 switched to datafile copy input datafile copy recid=4 stamp=882662894 filename=/u01/app/oracle/oradata/alice/example01.dbf contents of Memory Script: { set until scn 593607; recover clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 18-JUN-2015 00:08:13 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=155 devtype=DISK starting media recovery channel ORA_AUX_DISK_1: starting archive log restore to default destination channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=10 channel ORA_AUX_DISK_1: reading from backup piece /oradata/flash_recovery_area/ORCL/backupset/2015_06_17/o1_mf_annnn_TAG20150617T231823_br4roj8b_.bkp channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/oradata/flash_recovery_area/ORCL/backupset/2015_06_17/o1_mf_annnn_TAG20150617T231823_br4roj8b_.bkp tag=TAG20150617T231823 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archive log filename=/oradata/flash_recovery_area/ALICE/archivelog/2015_06_18/o1_mf_1_10_br4vly9d_.arc thread=1 sequence=10 channel clone_default: deleting archive log(s) archive log filename=/oradata/flash_recovery_area/ALICE/archivelog/2015_06_18/o1_mf_1_10_br4vly9d_.arc recid=1 stamp=882662894 media recovery complete, elapsed time: 00:00:02 Finished recover at 18-JUN-2015 00:08:17 contents of Memory Script: { shutdown clone; startup clone nomount ; } executing Memory Script database dismounted Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 536870912 bytes Fixed Size 2022144 bytes Variable Size 176162048 bytes Database Buffers 356515840 bytes Redo Buffers 2170880 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ALICE" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 ( '/u01/app/oracle/oradata/alice/redo01.log' ) SIZE 50 M REUSE, GROUP 2 ( '/u01/app/oracle/oradata/alice/redo02.log' ) SIZE 50 M REUSE, GROUP 3 ( '/u01/app/oracle/oradata/alice/redo03.log' ) SIZE 50 M REUSE DATAFILE '/u01/app/oracle/oradata/alice/system01.dbf' CHARACTER SET ZHS16GBK contents of Memory Script: { set newname for tempfile 1 to "/u01/app/oracle/oradata/alice/temp01.dbf"; switch clone tempfile all; catalog clone datafilecopy "/u01/app/oracle/oradata/alice/undotbs01.dbf"; catalog clone datafilecopy "/u01/app/oracle/oradata/alice/sysaux01.dbf"; catalog clone datafilecopy "/u01/app/oracle/oradata/alice/users01.dbf"; catalog clone datafilecopy "/u01/app/oracle/oradata/alice/example01.dbf"; switch clone datafile all; } executing Memory Script executing command: SET NEWNAME renamed temporary file 1 to /u01/app/oracle/oradata/alice/temp01.dbf in control file cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/alice/undotbs01.dbf recid=1 stamp=882662922 cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/alice/sysaux01.dbf recid=2 stamp=882662922 cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/alice/users01.dbf recid=3 stamp=882662922 cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/alice/example01.dbf recid=4 stamp=882662922 datafile 2 switched to datafile copy input datafile copy recid=1 stamp=882662922 filename=/u01/app/oracle/oradata/alice/undotbs01.dbf datafile 3 switched to datafile copy input datafile copy recid=2 stamp=882662922 filename=/u01/app/oracle/oradata/alice/sysaux01.dbf datafile 4 switched to datafile copy input datafile copy recid=3 stamp=882662922 filename=/u01/app/oracle/oradata/alice/users01.dbf datafile 5 switched to datafile copy input datafile copy recid=4 stamp=882662922 filename=/u01/app/oracle/oradata/alice/example01.dbf contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened Finished Duplicate Db at 18-JUN-2015 00:08:59 RMAN> |
查看下数据库的状态：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
[oracle@ora10g flash_recovery_area]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 18 00:10:50 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ alice OPEN SQL> SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2022144 bytes Variable Size 180356352 bytes Database Buffers 352321536 bytes Redo Buffers 2170880 bytes Database mounted. Database opened. SQL> SQL> select * from scott.dept; DEPTNO DNAME LOC ---------- -------------- ------------- 89 Allah Yuan MY Guang Xi 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> |
至此，数据库复制完整。
————————————————————
Done。
该文档不够完美，虽然最后效果上做出来了，但是其中有的步骤的理解不够深刻，… 而另一些步骤，甚至是多余的，… 还需要更努力。
对于：
*.db_file_name_convert=’/oradata/orcl/’,’/u01/app/oracle/oradata/alice’
*.log_file_name_convert=’/oradata/orcl/’,’/u01/app/oracle/oradata/alice’
写这两个参数的时候一定要在目录后加“/”，否则你会在duplicate的时候有惊喜。