设为首页 收藏本站

运维网

 找回密码
 立即注册
查看: 667|回复: 0

[经验分享] 通过RMAN克隆11g数据库（基于active database）

[复制链接]
34233
累计签到：1 天
连续签到：1 天
发表于 2016-2-1 10:35:17 | 显示全部楼层 |阅读模式
11g的RMAN duplicate 可以通过Active databaseduplicate和Backup-based duplicate两种方法实现。这里的测试使用的是Active databaseduplicate，因为Active database duplicate 功能强大，不需要先把目标数据库进行rman备份，只要目标数据库处于归档模式下即可直接通过网络对数据库进行copy，且copy完成后自动open数据库。这对于大数据特别是T级别的数据库来说优点非常明显，复制前不需要进行备份，减少了备份和传送备份的时间，同时节省备份空间。下面来进行具体的duplicate操作。




监听，口令文件配置，pfile配置，创建clone库相关目录等过程同基于备份的RMAN复制一样

1
2
3
4
5
6
7
8
SQL>startup pfile=$ORACLE_HOME/dbs/initclonedb.ora nomount;
ORACLEinstance started.

TotalSystem Global Area  630501376 bytes
FixedSize                    2215984 bytes
VariableSize                  184553424 bytes
DatabaseBuffers          440401920 bytes
RedoBuffers                    3330048 bytes







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
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
[oracle@HE4~]$ rman target sys/MANAGER@orcl auxiliarysys/MANAGER@clonedb

RecoveryManager: Release 11.2.0.1.0 - Production on Thu Jan 28 19:57:31 2016

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

connectedto target database: ORCL (DBID=1426154421)
connectedto auxiliary database: CLONEDB (not mounted)
RMAN> duplicate target database to clonedb from active database;  (这里是异机异构恢复，如果是同结构的参数会报错，需添加nofilenamecheck,谨慎使用，防止文件被覆盖)
Starting DuplicateDb at 28-JAN-16
using targetdatabase control file instead of recovery catalog
allocated channel:ORA_AUX_DISK_1
channelORA_AUX_DISK_1: SID=20 device type=DISK

contents of MemoryScript:
{
   sql clone "create spfile frommemory";
}
executing MemoryScript

sql statement:create spfile from memory

contents of MemoryScript:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing MemoryScript

Oracle instance shutdown

connected toauxiliary database (not started)
Oracle instancestarted

Total System GlobalArea     630501376 bytes

Fixed Size                     2215984 bytes
Variable Size                188747728 bytes
DatabaseBuffers             436207616 bytes
Redo Buffers                   3330048 bytes

contents of MemoryScript:
{
   sql clone "alter system set  db_name =
''ORCL'' comment=
''Modified by RMAN duplicate''scope=spfile";
   sql clone "alter system set  db_unique_name =
''CLONEDB'' comment=
''Modified by RMAN duplicate''scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   backup as copy current controlfile auxiliaryformat '/u01/app/oracle/oradata/clonedb/control01.ctl';
   restore clone controlfile to '/u01/app/oracle/oradata/clonedb/control02.ctl' from
'/u01/app/oracle/oradata/clonedb/control01.ctl';
   alter clone database mount;
}
executing MemoryScript

sql statement: altersystem set  db_name =  ''ORCL'' comment= ''Modified by RMANduplicate'' scope=spfile

sql statement: altersystem set  db_unique_name =  ''CLONEDB'' comment= ''Modified by RMANduplicate'' scope=spfile

Oracle instance shutdown

Oracle instancestarted

Total System GlobalArea     630501376 bytes

Fixed Size                     2215984 bytes
Variable Size                188747728 bytes
DatabaseBuffers             436207616 bytes
Redo Buffers                   3330048 bytes

Starting backup at28-JAN-16
allocated channel:ORA_DISK_1
channel ORA_DISK_1:SID=36 device type=DISK
channel ORA_DISK_1:starting datafile copy
copying currentcontrol file
output filename=/u01/app/oracle/product/11gr2/db_1/dbs/snapcf_orcl.ftag=TAG20160128T204953 RECID=5 STAMP=902350193
channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:03
Finished backup at28-JAN-16

Starting restore at28-JAN-16
allocated channel:ORA_AUX_DISK_1
channelORA_AUX_DISK_1: SID=18 device type=DISK

channelORA_AUX_DISK_1: copied control file copy
Finished restore at28-JAN-16

database mounted

contents of MemoryScript:
{
   set newname for datafile  1 to
"/u01/app/oracle/oradata/clonedb/system01.dbf";
   set newname for datafile  2 to
"/u01/app/oracle/oradata/clonedb/sysaux01.dbf";
   set newname for datafile  3 to
"/u01/app/oracle/oradata/clonedb/undotbs01.dbf";
   set newname for datafile  4 to
"/u01/app/oracle/oradata/clonedb/users01.dbf";
   set newname for datafile  5 to
"/u01/app/oracle/oradata/clonedb/example01.dbf";
   set newname for datafile  6 to
"/u01/app/oracle/oradata/clonedb/heleitbs01.dbf";
   backup as copy reuse
   datafile 1 auxiliary format
"/u01/app/oracle/oradata/clonedb/system01.dbf"   datafile
2 auxiliary format
"/u01/app/oracle/oradata/clonedb/sysaux01.dbf"   datafile
3 auxiliary format
"/u01/app/oracle/oradata/clonedb/undotbs01.dbf"   datafile
4 auxiliary format
"/u01/app/oracle/oradata/clonedb/users01.dbf"   datafile
5 auxiliary format
"/u01/app/oracle/oradata/clonedb/example01.dbf"   datafile
6 auxiliary format
"/u01/app/oracle/oradata/clonedb/heleitbs01.dbf"   ;
   sql 'alter system archive log current';
}
executing MemoryScript

executing command:SET NEWNAME

executing command:SET NEWNAME

executing command:SET NEWNAME

executing command:SET NEWNAME

executing command:SET NEWNAME

executing command:SET NEWNAME

Starting backup at28-JAN-16
using channelORA_DISK_1
channel ORA_DISK_1:starting datafile copy
input datafile filenumber=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
output filename=/u01/app/oracle/oradata/clonedb/system01.dbf tag=TAG20160128T205002
channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:59
channel ORA_DISK_1:starting datafile copy
input datafile filenumber=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
output filename=/u01/app/oracle/oradata/clonedb/sysaux01.dbf tag=TAG20160128T205002
channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1:starting datafile copy
input datafile filenumber=00006 name=/u01/app/oracle/oradata/orcl/heleitbs01.dbf
output filename=/u01/app/oracle/oradata/clonedb/heleitbs01.dbf tag=TAG20160128T205002
channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:16
channel ORA_DISK_1:starting datafile copy
input datafile filenumber=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
output filename=/u01/app/oracle/oradata/clonedb/example01.dbf tag=TAG20160128T205002
channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1:starting datafile copy
input datafile filenumber=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
output filename=/u01/app/oracle/oradata/clonedb/undotbs01.dbf tag=TAG20160128T205002
channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:08
channel ORA_DISK_1:starting datafile copy
input datafile filenumber=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
output filename=/u01/app/oracle/oradata/clonedb/users01.dbf tag=TAG20160128T205002
channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:01
Finished backup at28-JAN-16

sql statement: altersystem archive log current

contents of MemoryScript:
{
   backup as copy reuse
   archivelog like "/u01/archivelog/1_13_898373685.dbf" auxiliary format
"/u01/archivelog/1_13_898373685.dbf"   ;
   catalog clone archivelog "/u01/archivelog/1_13_898373685.dbf";
   switch clone datafile all;
}
executing MemoryScript

Starting backup at28-JAN-16
using channelORA_DISK_1
channel ORA_DISK_1:starting archived log copy
input archived logthread=1 sequence=13 RECID=9 STAMP=902350337
output filename=/u01/archivelog/1_13_898373685.dbf RECID=0 STAMP=0
channel ORA_DISK_1:archived log copy complete, elapsed time: 00:00:01
Finished backup at28-JAN-16

cataloged archivedlog
archived log filename=/u01/archivelog/1_13_898373685.dbf RECID=9 STAMP=902350338

datafile 1 switchedto datafile copy
input datafile copyRECID=5 STAMP=902350338 file name=/u01/app/oracle/oradata/clonedb/system01.dbf
datafile 2 switchedto datafile copy
input datafile copyRECID=6 STAMP=902350338 file name=/u01/app/oracle/oradata/clonedb/sysaux01.dbf
datafile 3 switchedto datafile copy
input datafile copyRECID=7 STAMP=902350338 file name=/u01/app/oracle/oradata/clonedb/undotbs01.dbf
datafile 4 switchedto datafile copy
input datafile copyRECID=8 STAMP=902350338 file name=/u01/app/oracle/oradata/clonedb/users01.dbf
datafile 5 switchedto datafile copy
input datafile copyRECID=9 STAMP=902350338 file name=/u01/app/oracle/oradata/clonedb/example01.dbf
datafile 6 switchedto datafile copy
input datafile copyRECID=10 STAMP=902350338 filename=/u01/app/oracle/oradata/clonedb/heleitbs01.dbf

contents of MemoryScript:
{
   set until scn  1028975;
   recover
   clone database
    delete archivelog
   ;
}
executing MemoryScript

executing command:SET until clause

Starting recover at28-JAN-16
using channelORA_AUX_DISK_1

starting mediarecovery

archived log forthread 1 with sequence 13 is already on disk as file/u01/archivelog/1_13_898373685.dbf
archived log filename=/u01/archivelog/1_13_898373685.dbf thread=1 sequence=13
media recoverycomplete, elapsed time: 00:00:00
Finished recover at28-JAN-16

contents of MemoryScript:
{
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  db_name =
''CLONEDB'' comment=
''Reset to original value by RMAN''scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing MemoryScript

database dismounted
Oracle instance shutdown

connected toauxiliary database (not started)
Oracle instancestarted

Total System GlobalArea     630501376 bytes

Fixed Size                     2215984 bytes
Variable Size                188747728 bytes
DatabaseBuffers             436207616 bytes
Redo Buffers                   3330048 bytes

sql statement: altersystem set  db_name =  ''CLONEDB'' comment= ''Reset to originalvalue by RMAN'' scope=spfile

sql statement: altersystem reset  db_unique_name scope=spfile

Oracle instance shutdown

connected toauxiliary database (not started)
Oracle instancestarted

Total System GlobalArea     630501376 bytes

Fixed Size                     2215984 bytes
Variable Size                188747728 bytes
DatabaseBuffers             436207616 bytes
Redo Buffers                   3330048 bytes
sql statement:CREATE CONTROLFILE REUSE SET DATABASE "CLONEDB" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
LOGFILE
  GROUP 1 ( '/u01/app/oracle/oradata/clonedb/redo01.log' ) SIZE 50 M  REUSE,
  GROUP 2 ( '/u01/app/oracle/oradata/clonedb/redo02.log' ) SIZE 50 M  REUSE,
  GROUP 3 ( '/u01/app/oracle/oradata/clonedb/redo03.log' ) SIZE 50 M  REUSE
DATAFILE
'/u01/app/oracle/oradata/clonedb/system01.dbf'
CHARACTER SET ZHS16GBK


contents of MemoryScript:
{
   set newname for tempfile  1 to
"/u01/app/oracle/oradata/clonedb/temp01.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy "/u01/app/oracle/oradata/clonedb/sysaux01.dbf",
"/u01/app/oracle/oradata/clonedb/undotbs01.dbf",
"/u01/app/oracle/oradata/clonedb/users01.dbf",
"/u01/app/oracle/oradata/clonedb/example01.dbf",
"/u01/app/oracle/oradata/clonedb/heleitbs01.dbf";
   switch clone datafile all;
}
executing MemoryScript

executing command:SET NEWNAME

renamed tempfile 1to /u01/app/oracle/oradata/clonedb/temp01.dbf in control file

cataloged datafilecopy
datafile copy filename=/u01/app/oracle/oradata/clonedb/sysaux01.dbf RECID=1 STAMP=902350346
cataloged datafilecopy
datafile copy filename=/u01/app/oracle/oradata/clonedb/undotbs01.dbf RECID=2 STAMP=902350346
cataloged datafilecopy
datafile copy filename=/u01/app/oracle/oradata/clonedb/users01.dbf RECID=3 STAMP=902350346
cataloged datafilecopy
datafile copy filename=/u01/app/oracle/oradata/clonedb/example01.dbf RECID=4 STAMP=902350346
cataloged datafilecopy
datafile copy filename=/u01/app/oracle/oradata/clonedb/heleitbs01.dbf RECID=5 STAMP=902350346

datafile 2 switchedto datafile copy
input datafile copyRECID=1 STAMP=902350346 file name=/u01/app/oracle/oradata/clonedb/sysaux01.dbf
datafile 3 switchedto datafile copy
input datafile copyRECID=2 STAMP=902350346 file name=/u01/app/oracle/oradata/clonedb/undotbs01.dbf
datafile 4 switchedto datafile copy
input datafile copyRECID=3 STAMP=902350346 file name=/u01/app/oracle/oradata/clonedb/users01.dbf
datafile 5 switchedto datafile copy
input datafile copyRECID=4 STAMP=902350346 file name=/u01/app/oracle/oradata/clonedb/example01.dbf
datafile 6 switchedto datafile copy
input datafile copyRECID=5 STAMP=902350346 filename=/u01/app/oracle/oradata/clonedb/heleitbs01.dbf

contents of MemoryScript:
{
   Alter clone database open resetlogs;
}
executing MemoryScript

database opened
Finished DuplicateDb at 28-JAN-16





database, active, 数据库

相关帖子


运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表，该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有，请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意，请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息，一经发现立即删除。若您因此触犯法律，一切后果自负，我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集，我们仅提供一个展示、介绍、观摩学习的平台，我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责，亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏，不得用于商业或者其他用途，否则，一切后果均由您自己承担，我们对此不承担任何法律责任
7、如涉及侵犯版权等问题，请您及时通知我们，我们将立即采取措施予以解决
8、联系人Email：admin@iyunv.com 网址：www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址：https://www.yunweiku.com/thread-172260-1-1.html 上篇帖子： 解决oracle sqlplus 不能修改，退格问题 下篇帖子： ORACLE进程占用CPU情况分析 database active 数据库
回复

使用道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群，最新一手资源尽在官方微信交流群！快快加入我们吧...

扫描微信二维码查看详情

客服 E-mail:iyunvcom@gmail.com

本站由青云提供云计算服务

运维网--中国最专业的运维工程师交流社区

豫ICP备20007574号-1 Copyright © 2012-2025

关于我们

发展历程

联系我们

关注我们

广告服务

广告案例

隐私条款

免责声明

用户登录

用户注册

版主守则

申请版主

手机版

金币获取

帮助中心

每日签到

Good Good

Study

Day Day

UP


客服E-mail:kefu@iyunv.com 客服QQ：1061981298


QQ群⑦：运维网交流群⑦ QQ群⑧：运维网交流群⑧ k8s群：运维网kubernetes交流群


提醒：禁止发布任何违反国家法律、法规的言论与图片等内容；本站内容均来自个人观点与网络等信息，非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来，其版权均归原作者及其网站所有，我们尊重他人的合法权益，如有内容侵犯您的合法权益，请及时与我们联系进行核实删除！



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表