这是Oracle OCP给出的一个duplicating a CDB的一般步骤：
从Oracle 18c开始，我们可以在rman中直接使用duplicate来复制一个cdb，下边给出一个示例：
2.4.1 环境介绍
1、新建一个容器（可以当做一个新主机）
1-- 新建一个容器
2docker rm -f ocp19c
3docker run -itd -h ocp19c --name ocp19c \
4-p 222:22 -p 1521:1521 -p 5500:5500 -p 5501:5501 \
5--privileged=true \
6lhrbest/oracle19clhr_rpm_db /usr/sbin/init
7
8-- 进入容器
9docker exec -it ocp19c bash
2、创建CDB2的spfile和密码文件，启动到nomount阶段
1-- 1、创建密码文件
2orapwd file=$ORACLE_HOME/dbs/orapwCDB2 force=y format=12 password=lhr
3
4-- 2、创建CDB2的数据文件存储路径
5mkdir -p /opt/oracle/oradata/CDB2/
6
7-- 3、创建pfile文件
8cat > /home/oracle/a.txt <<"EOF"
9
10db_name='CDB2'
11compatible='19.0.0'
12control_files='/opt/oracle/oradata/CDB2/control01.ctl','/opt/oracle/oradata/CDB2/control02.ctl'
13enable_pluggable_database=true
14sga_target=1024m
15log_archive_dest_1='location=/opt/oracle/oradata/CDB2/'
16DB_FILE_NAME_CONVERT=(/opt/oracle/oradata/ORCLCDB/,/opt/oracle/oradata/CDB2/)
17LOG_FILE_NAME_CONVERT=(/opt/oracle/oradata/ORCLCDB/,/opt/oracle/oradata/CDB2/)
18
19EOF
20
21-- 4、创建spfile文件并且启动到nomount阶段
22export ORACLE_SID=CDB2
23sqlplus / as sysdba
24create spfile from pfile='/home/oracle/a.txt';
25startup nomount;
启动过程：
1[oracle@ocp19c ~]$ sas
2
3SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 20 20:27:42 2020
4Version 19.3.0.0.0
5
6Copyright (c) 1982, 2019, Oracle. All rights reserved.
7
8Connected to an idle instance.
9
10SYS@CDB2> create spfile from pfile='/home/oracle/a.txt';
11
12File created.
13
14SYS@CDB2> startup nomount;
15ORACLE instance started.
16
17Total System Global Area 1073739248 bytes
18Fixed Size 9143792 bytes
19Variable Size 293601280 bytes
20Database Buffers 763363328 bytes
21Redo Buffers 7630848 bytes
22SYS@CDB2>
3、执行复制
推荐写法：
1-- 连接到源库和目标库
2rman target sys/lhr@tns_ORCLCDB auxiliary sys/lhr@tns_CDB2
3或
4rman target sys/lhr@172.17.0.3:1521/ORCLCDB auxiliary sys/lhr
5
6-- 执行复制
7DUPLICATE TARGET DATABASE TO CDB2 FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT ('ORCLCDB', 'CDB2');
注意：需要保证使用sqlplus可以正常连接到源库和目标库。
执行过程日志：
1[oracle@lhr2019ocp ~]$ rman target sys/lhr@172.17.0.3:1521/ORCLCDB auxiliary sys/lhr
2
3Recovery Manager: Release 19.0.0.0.0 - Production on Thu Aug 20 20:52:45 2020
4Version 19.3.0.0.0
5
6Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
7
8connected to target database: ORCLCDB (DBID=2814923791)
9connected to auxiliary database: CDB2 (not mounted)
10
11RMAN> DUPLICATE TARGET DATABASE TO CDB2 FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT ('ORCLCDB', 'CDB2');
12
13Starting Duplicate Db at 2020-08-20 20:53:07
14using target database control file instead of recovery catalog
15allocated channel: ORA_AUX_DISK_1
16channel ORA_AUX_DISK_1: SID=661 device type=DISK
17current log archived
18
19contents of Memory Script:
20{
21 sql clone "alter system set db_name =
22 ''ORCLCDB'' comment=
23 ''Modified by RMAN duplicate'' scope=spfile";
24 sql clone "alter system set db_unique_name =
25 ''CDB2'' comment=
26 ''Modified by RMAN duplicate'' scope=spfile";
27 shutdown clone immediate;
28 startup clone force nomount
29 restore clone from service '172.17.0.3:1521/ORCLCDB' primary controlfile;
30 alter clone database mount;
31}
32executing Memory Script
33
34sql statement: alter system set db_name = ''ORCLCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
35
36sql statement: alter system set db_unique_name = ''CDB2'' comment= ''Modified by RMAN duplicate'' scope=spfile
37
38Oracle instance shut down
39
40Oracle instance started
41
42Total System Global Area 1073739248 bytes
43
44Fixed Size 9143792 bytes
45Variable Size 293601280 bytes
46Database Buffers 763363328 bytes
47Redo Buffers 7630848 bytes
48
49Starting restore at 2020-08-20 20:53:39
50allocated channel: ORA_AUX_DISK_1
51channel ORA_AUX_DISK_1: SID=399 device type=DISK
52
53channel ORA_AUX_DISK_1: starting datafile backup set restore
54channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
55channel ORA_AUX_DISK_1: restoring control file
56channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
57output file name=/opt/oracle/oradata/CDB2/control01.ctl
58output file name=/opt/oracle/oradata/CDB2/control02.ctl
59Finished restore at 2020-08-20 20:53:43
60
61database mounted
62
63contents of Memory Script:
64{
65 set newname for datafile 1 to
66 "/opt/oracle/oradata/CDB2/system01.dbf";
67 set newname for datafile 3 to
68 "/opt/oracle/oradata/CDB2/sysaux01.dbf";
69 set newname for datafile 4 to
70 "/opt/oracle/oradata/CDB2/undotbs01.dbf";
71 set newname for datafile 5 to
72 "/opt/oracle/oradata/CDB2/pdbseed/system01.dbf";
73 set newname for datafile 6 to
74 "/opt/oracle/oradata/CDB2/pdbseed/sysaux01.dbf";
75 set newname for datafile 7 to
76 "/opt/oracle/oradata/CDB2/users01.dbf";
77 set newname for datafile 8 to
78 "/opt/oracle/oradata/CDB2/pdbseed/undotbs01.dbf";
79 set newname for datafile 9 to
80 "/opt/oracle/oradata/CDB2/ORCLPDB1/system01.dbf";
81 set newname for datafile 10 to
82 "/opt/oracle/oradata/CDB2/ORCLPDB1/sysaux01.dbf";
83 set newname for datafile 11 to
84 "/opt/oracle/oradata/CDB2/ORCLPDB1/undotbs01.dbf";
85 set newname for datafile 12 to
86 "/opt/oracle/oradata/CDB2/ORCLPDB1/users01.dbf";
87 restore
88 from nonsparse from service
89 '172.17.0.3:1521/ORCLCDB' clone database
90 ;
91 sql 'alter system archive log current';
92}
93executing Memory Script
94
95executing command: SET NEWNAME
96
97executing command: SET NEWNAME
98
99executing command: SET NEWNAME
100
101executing command: SET NEWNAME
102
103executing command: SET NEWNAME
104
105executing command: SET NEWNAME
106
107executing command: SET NEWNAME
108
109executing command: SET NEWNAME
110
111executing command: SET NEWNAME
112
113executing command: SET NEWNAME
114
115executing command: SET NEWNAME
116
117Starting restore at 2020-08-20 20:53:48
118using channel ORA_AUX_DISK_1
119
120channel ORA_AUX_DISK_1: starting datafile backup set restore
121channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
122channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
123channel ORA_AUX_DISK_1: restoring datafile 00001 to /opt/oracle/oradata/CDB2/system01.dbf
124channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
125channel ORA_AUX_DISK_1: starting datafile backup set restore
126channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
127channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
128channel ORA_AUX_DISK_1: restoring datafile 00003 to /opt/oracle/oradata/CDB2/sysaux01.dbf
129channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
130channel ORA_AUX_DISK_1: starting datafile backup set restore
131channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
132channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
133channel ORA_AUX_DISK_1: restoring datafile 00004 to /opt/oracle/oradata/CDB2/undotbs01.dbf
134channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
135channel ORA_AUX_DISK_1: starting datafile backup set restore
136channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
137channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
138channel ORA_AUX_DISK_1: restoring datafile 00005 to /opt/oracle/oradata/CDB2/pdbseed/system01.dbf
139channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
140channel ORA_AUX_DISK_1: starting datafile backup set restore
141channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
142channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
143channel ORA_AUX_DISK_1: restoring datafile 00006 to /opt/oracle/oradata/CDB2/pdbseed/sysaux01.dbf
144channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04
145channel ORA_AUX_DISK_1: starting datafile backup set restore
146channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
147channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
148channel ORA_AUX_DISK_1: restoring datafile 00007 to /opt/oracle/oradata/CDB2/users01.dbf
149channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
150channel ORA_AUX_DISK_1: starting datafile backup set restore
151channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
152channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
153channel ORA_AUX_DISK_1: restoring datafile 00008 to /opt/oracle/oradata/CDB2/pdbseed/undotbs01.dbf
154channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
155channel ORA_AUX_DISK_1: starting datafile backup set restore
156channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
157channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
158channel ORA_AUX_DISK_1: restoring datafile 00009 to /opt/oracle/oradata/CDB2/ORCLPDB1/system01.dbf
159channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
160channel ORA_AUX_DISK_1: starting datafile backup set restore
161channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
162channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
163channel ORA_AUX_DISK_1: restoring datafile 00010 to /opt/oracle/oradata/CDB2/ORCLPDB1/sysaux01.dbf
164channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
165channel ORA_AUX_DISK_1: starting datafile backup set restore
166channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
167channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
168channel ORA_AUX_DISK_1: restoring datafile 00011 to /opt/oracle/oradata/CDB2/ORCLPDB1/undotbs01.dbf
169channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
170channel ORA_AUX_DISK_1: starting datafile backup set restore
171channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
172channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
173channel ORA_AUX_DISK_1: restoring datafile 00012 to /opt/oracle/oradata/CDB2/ORCLPDB1/users01.dbf
174channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
175Finished restore at 2020-08-20 20:54:12
176
177sql statement: alter system archive log current
178current log archived
179
180contents of Memory Script:
181{
182 restore clone force from service '172.17.0.3:1521/ORCLCDB'
183 archivelog from scn 2547761;
184 switch clone datafile all;
185}
186executing Memory Script
187
188Starting restore at 2020-08-20 20:54:12
189using channel ORA_AUX_DISK_1
190
191channel ORA_AUX_DISK_1: starting archived log restore to default destination
192channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
193channel ORA_AUX_DISK_1: restoring archived log
194archived log thread=1 sequence=11
195channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
196channel ORA_AUX_DISK_1: starting archived log restore to default destination
197channel ORA_AUX_DISK_1: using network backup set from service 172.17.0.3:1521/ORCLCDB
198channel ORA_AUX_DISK_1: restoring archived log
199archived log thread=1 sequence=12
200channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
201Finished restore at 2020-08-20 20:54:15
202
203datafile 1 switched to datafile copy
204input datafile copy RECID=15 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/system01.dbf
205datafile 3 switched to datafile copy
206input datafile copy RECID=16 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/sysaux01.dbf
207datafile 4 switched to datafile copy
208input datafile copy RECID=17 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/undotbs01.dbf
209datafile 5 switched to datafile copy
210input datafile copy RECID=18 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/pdbseed/system01.dbf
211datafile 6 switched to datafile copy
212input datafile copy RECID=19 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/pdbseed/sysaux01.dbf
213datafile 7 switched to datafile copy
214input datafile copy RECID=20 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/users01.dbf
215datafile 8 switched to datafile copy
216input datafile copy RECID=21 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/pdbseed/undotbs01.dbf
217datafile 9 switched to datafile copy
218input datafile copy RECID=22 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/ORCLPDB1/system01.dbf
219datafile 10 switched to datafile copy
220input datafile copy RECID=23 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/ORCLPDB1/sysaux01.dbf
221datafile 11 switched to datafile copy
222input datafile copy RECID=24 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/ORCLPDB1/undotbs01.dbf
223datafile 12 switched to datafile copy
224input datafile copy RECID=25 STAMP=1048971255 file name=/opt/oracle/oradata/CDB2/ORCLPDB1/users01.dbf
225
226contents of Memory Script:
227{
228 set until scn 2547918;
229 recover
230 clone database
231 delete archivelog
232 ;
233}
234executing Memory Script
235
236executing command: SET until clause
237
238Starting recover at 2020-08-20 20:54:15
239using channel ORA_AUX_DISK_1
240
241starting media recovery
242
243archived log for thread 1 with sequence 11 is already on disk as file /opt/oracle/oradata/CDB2/1_11_1043862417.dbf
244archived log for thread 1 with sequence 12 is already on disk as file /opt/oracle/oradata/CDB2/1_12_1043862417.dbf
245archived log file name=/opt/oracle/oradata/CDB2/1_11_1043862417.dbf thread=1 sequence=11
246archived log file name=/opt/oracle/oradata/CDB2/1_12_1043862417.dbf thread=1 sequence=12
247media recovery complete, elapsed time: 00:00:01
248Finished recover at 2020-08-20 20:54:17
249
250contents of Memory Script:
251{
252 delete clone force archivelog all;
253}
254executing Memory Script
255
256released channel: ORA_AUX_DISK_1
257allocated channel: ORA_DISK_1
258channel ORA_DISK_1: SID=628 device type=DISK
259deleted archived log
260archived log file name=/opt/oracle/oradata/CDB2/1_11_1043862417.dbf RECID=1 STAMP=1048971253
261deleted archived log
262archived log file name=/opt/oracle/oradata/CDB2/1_12_1043862417.dbf RECID=2 STAMP=1048971254
263Deleted 2 objects
264
265Oracle instance started
266
267Total System Global Area 1073739248 bytes
268
269Fixed Size 9143792 bytes
270Variable Size 293601280 bytes
271Database Buffers 763363328 bytes
272Redo Buffers 7630848 bytes
273
274contents of Memory Script:
275{
276 sql clone "alter system set db_name =
277 ''CDB2'' comment=
278 ''Reset to original value by RMAN'' scope=spfile";
279 sql clone "alter system reset db_unique_name scope=spfile";
280}
281executing Memory Script
282
283sql statement: alter system set db_name = ''CDB2'' comment= ''Reset to original value by RMAN'' scope=spfile
284
285sql statement: alter system reset db_unique_name scope=spfile
286Oracle instance started
287
288Total System Global Area 1073739248 bytes
289
290Fixed Size 9143792 bytes
291Variable Size 293601280 bytes
292Database Buffers 763363328 bytes
293Redo Buffers 7630848 bytes
294sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CDB2" RESETLOGS ARCHIVELOG
295 MAXLOGFILES 16
296 MAXLOGMEMBERS 3
297 MAXDATAFILES 1024
298 MAXINSTANCES 8
299 MAXLOGHISTORY 292
300 LOGFILE
301 GROUP 1 ( '/opt/oracle/oradata/CDB2/redo01.log' ) SIZE 200 M REUSE,
302 GROUP 2 ( '/opt/oracle/oradata/CDB2/redo02.log' ) SIZE 200 M REUSE,
303 GROUP 3 ( '/opt/oracle/oradata/CDB2/redo03.log' ) SIZE 200 M REUSE
304 DATAFILE
305 '/opt/oracle/oradata/CDB2/system01.dbf',
306 '/opt/oracle/oradata/CDB2/pdbseed/system01.dbf',
307 '/opt/oracle/oradata/CDB2/ORCLPDB1/system01.dbf'
308 CHARACTER SET AL32UTF8
309
310
311contents of Memory Script:
312{
313 set newname for tempfile 1 to
314 "/opt/oracle/oradata/CDB2/temp01.dbf";
315 set newname for tempfile 2 to
316 "/opt/oracle/oradata/CDB2/pdbseed/temp012020-06-23_09-54-06-505-AM.dbf";
317 set newname for tempfile 3 to
318 "/opt/oracle/oradata/CDB2/ORCLPDB1/temp01.dbf";
319 switch clone tempfile all;
320 catalog clone datafilecopy "/opt/oracle/oradata/CDB2/sysaux01.dbf",
321 "/opt/oracle/oradata/CDB2/undotbs01.dbf",
322 "/opt/oracle/oradata/CDB2/pdbseed/sysaux01.dbf",
323 "/opt/oracle/oradata/CDB2/users01.dbf",
324 "/opt/oracle/oradata/CDB2/pdbseed/undotbs01.dbf",
325 "/opt/oracle/oradata/CDB2/ORCLPDB1/sysaux01.dbf",
326 "/opt/oracle/oradata/CDB2/ORCLPDB1/undotbs01.dbf",
327 "/opt/oracle/oradata/CDB2/ORCLPDB1/users01.dbf";
328 switch clone datafile all;
329}
330executing Memory Script
331
332executing command: SET NEWNAME
333
334executing command: SET NEWNAME
335
336executing command: SET NEWNAME
337
338renamed tempfile 1 to /opt/oracle/oradata/CDB2/temp01.dbf in control file
339renamed tempfile 2 to /opt/oracle/oradata/CDB2/pdbseed/temp012020-06-23_09-54-06-505-AM.dbf in control file
340renamed tempfile 3 to /opt/oracle/oradata/CDB2/ORCLPDB1/temp01.dbf in control file
341
342cataloged datafile copy
343datafile copy file name=/opt/oracle/oradata/CDB2/sysaux01.dbf RECID=1 STAMP=1048971282
344cataloged datafile copy
345datafile copy file name=/opt/oracle/oradata/CDB2/undotbs01.dbf RECID=2 STAMP=1048971282
346cataloged datafile copy
347datafile copy file name=/opt/oracle/oradata/CDB2/pdbseed/sysaux01.dbf RECID=3 STAMP=1048971282
348cataloged datafile copy
349datafile copy file name=/opt/oracle/oradata/CDB2/users01.dbf RECID=4 STAMP=1048971282
350cataloged datafile copy
351datafile copy file name=/opt/oracle/oradata/CDB2/pdbseed/undotbs01.dbf RECID=5 STAMP=1048971282
352cataloged datafile copy
353datafile copy file name=/opt/oracle/oradata/CDB2/ORCLPDB1/sysaux01.dbf RECID=6 STAMP=1048971282
354cataloged datafile copy
355datafile copy file name=/opt/oracle/oradata/CDB2/ORCLPDB1/undotbs01.dbf RECID=7 STAMP=1048971282
356cataloged datafile copy
357datafile copy file name=/opt/oracle/oradata/CDB2/ORCLPDB1/users01.dbf RECID=8 STAMP=1048971282
358
359datafile 3 switched to datafile copy
360input datafile copy RECID=1 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/sysaux01.dbf
361datafile 4 switched to datafile copy
362input datafile copy RECID=2 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/undotbs01.dbf
363datafile 6 switched to datafile copy
364input datafile copy RECID=3 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/pdbseed/sysaux01.dbf
365datafile 7 switched to datafile copy
366input datafile copy RECID=4 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/users01.dbf
367datafile 8 switched to datafile copy
368input datafile copy RECID=5 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/pdbseed/undotbs01.dbf
369datafile 10 switched to datafile copy
370input datafile copy RECID=6 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/ORCLPDB1/sysaux01.dbf
371datafile 11 switched to datafile copy
372input datafile copy RECID=7 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/ORCLPDB1/undotbs01.dbf
373datafile 12 switched to datafile copy
374input datafile copy RECID=8 STAMP=1048971282 file name=/opt/oracle/oradata/CDB2/ORCLPDB1/users01.dbf
375
376contents of Memory Script:
377{
378 Alter clone database open resetlogs;
379}
380executing Memory Script
381
382database opened
383
384contents of Memory Script:
385{
386 sql clone "alter pluggable database all open";
387}
388executing Memory Script
389
390sql statement: alter pluggable database all open
391Finished Duplicate Db at 2020-08-20 20:54:58
392
393RMAN> exit
394
395
396Recovery Manager complete.
397[oracle@lhr2019ocp ~]$
398
4、查看目标数据库
1[oracle@lhr2019ocp ~]$ sas
2
3SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 20 20:55:05 2020
4Version 19.3.0.0.0
5
6Copyright (c) 1982, 2019, Oracle. All rights reserved.
7
8
9Connected to:
10Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
11Version 19.3.0.0.0
12
13SYS@CDB2> show pdbs
14
15 CON_ID CON_NAME OPEN MODE RESTRICTED
16---------- ------------------------------ ---------- ----------
17 2 PDB$SEED READ ONLY NO
18 3 ORCLPDB1 READ WRITE NO
19SYS@CDB2>
5、注意事项
1、源库必须是归档模式
2、源库执行备份（backup database）不能报错
本文结束。
• 微信公众号：DB宝，作者：小麦苗
• 作者博客地址：http://blog.itpub.net/26736162/
• 作者微信：db_bao• 作者QQ：646634621，QQ群：230161599、618766405
• 提供Oracle OCP、OCM、高可用（rac+dg+ogg）和MySQL DBA培训
• 版权所有，欢迎分享本文，转载请保留出处• 若有侵权请联系小麦苗删除
★DB宝分享的IT资料：https://mp.weixin.qq.com/s/Iwsy-zkzwgs8nYkcMz29ag★DB宝笔试面试详解：https://mp.weixin.qq.com/s/Vm5PqNcDcITkOr9cQg6T7w
长按下图识别二维码，关注小麦苗的微信公众号：DB宝，学习最实用的数据库技术。
文章转载自DB宝，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
