Duplicating 功能，克隆一个pdb到一个新cdb

原创许玉冲 2021-07-26

1153

1，数据库处于归档模式
2，目标cdb已经存在。

环境：
数据库版本：19.11.0.0.0
#cdb,pdb字符集可以不同。
源：ORA：pdb008（字符集ZHS16GBK）
目标: cdb （字符集AL32UTF8）

连接数据库：

RMAN> connect target sys/oracle@127.0.0.1/ora

connected to target database: ORA (DBID=1697176833)

RMAN> connect auxiliary sys/oracle@127.0.0.1/cdb

connected to auxiliary database: CDB (DBID=2195211038)

执行duplicate命令：

RMAN> DUPLICATE PLUGGABLE DATABASE PDB008 TO cdb
DB_FILE_NAME_CONVERT('/u01/app/oracle/oradata/ORA/pdb008/','/u01/app/oracle/oradata/CDB/pdb008/')
FROM ACTIVE DATABASE
SECTION SIZE 400M;2> 3> 4>

Starting Duplicate PDB at 26-JUL-21
using channel ORA_AUX_DISK_1
current log archived
current log archived

contents of Memory Script:
{
   set newname for datafile  9 to
 "/u01/app/oracle/oradata/CDB/pdb008/system01.dbf";
   set newname for datafile  10 to
 "/u01/app/oracle/oradata/CDB/pdb008/sysaux01.dbf";
   set newname for datafile  11 to
 "/u01/app/oracle/oradata/CDB/pdb008/undotbs01.dbf";
   set newname for datafile  12 to
 "/u01/app/oracle/oradata/CDB/pdb008/users01.dbf";
   restore
   from  nonsparse   section size
 400 m   clone foreign pluggable database
    "PDB008"
   from service  '127.0.0.1/ora'   ;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 26-JUL-21
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring section 1 of 1
channel ORA_AUX_DISK_1: restoring foreign file 9 to /u01/app/oracle/oradata/CDB/pdb008/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring section 1 of 2
channel ORA_AUX_DISK_1: restoring foreign file 10 to /u01/app/oracle/oradata/CDB/pdb008/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring section 2 of 2
channel ORA_AUX_DISK_1: restoring foreign file 10 to /u01/app/oracle/oradata/CDB/pdb008/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring section 1 of 1
channel ORA_AUX_DISK_1: restoring foreign file 11 to /u01/app/oracle/oradata/CDB/pdb008/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring section 1 of 1
channel ORA_AUX_DISK_1: restoring foreign file 12 to /u01/app/oracle/oradata/CDB/pdb008/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-JUL-21

contents of Memory Script:
{
   set archivelog destination to  '/u01/tmp';
   restore clone force from service  '127.0.0.1/ora'
           foreign archivelog from scn  2717597;
}
executing Memory Script

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 26-JUL-21
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/u01/tmp
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=14
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/u01/tmp
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=15
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/u01/tmp
channel ORA_AUX_DISK_1: using network backup set from service 127.0.0.1/ora
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=16
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-JUL-21

Performing import of metadata...
Finished Duplicate PDB at 26-JUL-21

RMAN>

目标的检查数据库状态和字符集：

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB001                         READ WRITE NO
         4 PDB01                          READ WRITE NO
SQL> COLUMN parameter FORMAT A30

COLUMN value FORMAT A30

SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';
SQL> SQL> SQL> SQL>
PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_CHARACTERSET               AL32UTF8

SQL>
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB001                         READ WRITE NO
         4 PDB01                          READ WRITE NO
         5 PDB008                         READ WRITE NO
SQL> ALTER SESSION SET CONTAINER=pdb008;

COLUMN parameter FORMAT A30

COLUMN value FORMAT A30

SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';

Session altered.

SQL> SQL> SQL> SQL> SQL> SQL>
PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_CHARACTERSET               ZHS16GBK

oracle

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

Duplicating 功能，克隆一个pdb到一个新cdb

评论