Oracle 12c：使用 12c RMAN 活动数据库复制迁移非 CDB 并转换为 PDB-之路教程

Oracle 12c：使用 12c RMAN 活动数据库复制迁移非 CDB 并转换为 PDB

此方法利用了 12c 中 RMAN 的新功能，允许我们克隆数据库文件并将增量应用于活动数据库中的这些文件，而无需暂存区。
此外，在执行克隆和增量应用时，源非 CDB 应用程序活动可以继续。
准备好执行实际迁移时，必须将源非 CDB 置于 READ ONLY 模式。
此时，应用程序活动应停止并执行最终增量应用程序。

要在目标 PDB 的正确 ASM 目录中获取数据文件，我们可以从源非 CDB 执行 RMAN BACKUP AS COPY，同时还连接到同一 RMAN 会话中的目标 CDB。
在目标上使用 OMF 或者 ASM 时，这将确保将数据文件副本写入正确的位置。
增量应用也通过网络执行，并应用于目标位置的数据文件。

此操作需要一个临时实例用于增量应用。
创建数据文件副本时，新环境中的任何数据库都不知道它们，通过使用临时实例，我们在目标环境中创建源非 CDB 控制文件的副本，并将新创建的数据文件副本编目到临时实例。
我们现在有一个可以识别文件并可以对它们执行恢复的实例。
临时实例仅用于此目的，可以在迁移过程完成后丢弃。
临时实例只能以 nomount 或者 mount 模式启动，永远不应打开。

如果目标上有 Active Data Guard 物理备用，请在主目标和备用目标环境上执行 RMAN BACKUP AS COPY 和增量应用过程。
这会将文件放置在目标备用环境中的正确位置，以便插件操作的媒体恢复可以继续进行而不会停止。
我们必须为每个目标环境单独运行该过程，例如我们将运行 RMAN 进程将文件复制到目标主站点并运行 RMAN 进程将文件复制到目标备用站点，我们将在目标主站点和目标备用站点上创建一个临时实例等。
在目标主站点和备用站点上完成最终增量应用后，我们可以在主站点上插入新的 PDB，而无需在备用站点上执行进一步操作。

下面的示例记录了 ASM 用于文件存储和 Active Data Guard 物理备用数据库的过程。

注意：在执行此过程时不要将数据文件添加到源，因为增量应用（恢复数据库 noredo）命令不会恢复新的数据文件，它们只会恢复已经恢复/编目的数据文件。

在目标主数据库和备用数据库环境上创建一个 TNS 条目以指向要迁移的源非 CDB。
RMAN 将使用它来连接到源并在目标环境中创建数据文件副本，并在不需要暂存区的情况下跨网络执行增量应用。
此连接可以使用 SCAN 主机。

NONCDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [source-noncdb-scan])(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = [noncdb])
    )
  )

确保目标主环境和备用环境上都有指向各自目标实例的 TNS 条目。
换句话说，在目标主服务器上，必须有一个指向目标主数据库的TNS条目，而在目标备用服务器上，必须有一个指向目标备用数据库的TNS条目。
这些 TNS 条目可以使用 SCAN 主机。

目的地主要：

CONT3 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [target-prim-scan])(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = [CONT3])
    )
  )

目的地待机：

CONT3STBY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [target-stby-scan])(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cont3stby)
    )
  )

将指向目标主备环境的 TNS 条目复制到源非 CDB 环境。
作为 BACKUP AS COPY 过程的一部分，这些是允许源数据库连接到目的地所必需的。
这些 TNS 条目可以使用 SCAN 主机。
如果我们将 SCAN 主机用于指向目标环境中的非 CDB 源的 TNS 条目（上面的第一步）并且源非 CDB 是 Real Application Cluster 数据库，则这些指向目标的 TNS 条目应该位于所有非 CDB 数据库运行实例的节点。
备份作为将源非CDB 复制到连接到目标主备数据库实例的目标主备环境。
这将在 ASM 的正确目录中创建源非 CDB 的数据文件副本，此时数据库不会知道这些文件副本。
RMAN 目标（源 12c 非 CDB）和目标（12c CDB）都需要 TNS 连接。
在 RMAN 会话中，连接到我们将作为克隆实例迁移到的容器数据库的 ROOT。
源非 CDB 可以在复制发生时继续应用程序活动。

创建一个类似于以下的命令文件。
目标是要迁移的源非 CDB，克隆是将其中创建新 PDB 的目标 CDB。

基本的：

connect target sys@noncdb
connect auxiliary sys@cont3
backup as copy database auxiliary format '+data';

支持：

connect target sys@noncdb
connect auxiliary sys@cont3stby
backup as copy database auxiliary format '+datad1';

确保未在主数据库上启用磁盘设备类型的备份压缩。
启用压缩时不允许备份为副本。

RMAN> show device type;

具有 db_unique_name NONCDB 的数据库的 RMAN 配置参数是：

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

在目标主站点和目标备用站点上运行刚刚创建的代码块，将文件从源非 CDB 复制到目标环境。
注意主环境和备用环境中输出文件的目录结构（以“输出文件名”开头的行）。
在后面的步骤中将需要这些目录。

基本的：

$ rman
Recovery Manager: Release 12.1.0.1.0 - Production on Wed Sep 4 12:23:17 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
RMAN> @backup.cmd
RMAN> connect target *
target database Password:
connected to target database: NONCDB (DBID=1643045589)
RMAN> connect auxiliary *
auxiliary database Password:
connected to auxiliary database: CONT3 (DBID=1783201232)
RMAN> backup as copy database auxiliary format '+data';
Starting backup at 04-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=319 device type=DISK
...
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+DATAD1/NONCDB/DATAFILE/undotbs1.441.825151103
channel ORA_DISK_2: starting datafile copy
input datafile file number=00005 name=+DATAD1/NONCDB/DATAFILE/soets.438.825151965
channel ORA_DISK_3: starting datafile copy
input datafile file number=00006 name=+DATAD1/NONCDB/DATAFILE/soets2.436.825151971
channel ORA_DISK_4: starting datafile copy
input datafile file number=00007 name=+DATAD1/NONCDB/DATAFILE/soets3.451.825151981
...
input datafile file number=00001 name=+DATAD1/NONCDB/DATAFILE/system.455.825151099
output file name=+DATA/CONT3/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/system.387.825251193 tag=TAG20130904T102613  # Save this directory name to be used later
channel ORA_DISK_8: datafile copy complete, elapsed time: 00:01:05
channel ORA_DISK_8: starting datafile copy
input datafile file number=00004 name=+DATAD1/NONCDB/DATAFILE/users.288.825151109
output file name=+DATA/CONT3/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.386.825251261 tag=TAG20130904T102613
channel ORA_DISK_8: datafile copy complete, elapsed time: 00:00:05
...
output file name=+DATA/CONT3/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/undotbs1.272.825251181 tag=TAG20130904T102613
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:08:30
Finished backup at 04-SEP-13
RMAN> **end-of-file**

支持：

$ rman
Recovery Manager: Release 12.1.0.1.0 - Production on Wed Sep 4 10:26:51 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
RMAN> @backup.cmd
RMAN> connect target *
target database Password:
connected to target database: NONCDB (DBID=1643045589)
RMAN> connect auxiliary *
auxiliary database Password:
connected to auxiliary database: CONT3 (DBID=1783201232)
RMAN> backup as copy database auxiliary format '+datad1';
Starting backup at 04-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=556 device type=DISK
...
input datafile file number=00001 name=+DATAD1/NONCDB/DATAFILE/system.455.825151099
output file name=+DATAD1/CONT3STBY/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/sysaux.528.825244029 tag=TAG20130904T102706  # Save this directory name to be used later
channel ORA_DISK_7: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_7: starting datafile copy
input datafile file number=00004 name=+DATAD1/NONCDB/DATAFILE/users.288.825151109
output file name=+DATAD1/CONT3STBY/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/system.517.825244029 tag=TAG20130904T102706
channel ORA_DISK_8: datafile copy complete, elapsed time: 00:00:16
output file name=+DATAD1/CONT3STBY/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.510.825244043 tag=TAG20130904T102706
channel ORA_DISK_7: datafile copy complete, elapsed time: 00:00:01
output file name=+DATAD1/CONT3STBY/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/undotbs1.516.825244027 tag=TAG20130904T102706
...
output file name=+DATAD1/CONT3STBY/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets5.515.825244029 tag=TAG20130904T102706
channel ORA_DISK_6: datafile copy complete, elapsed time: 00:00:51
Finished backup at 04-SEP-13
RMAN>
RMAN> **end-of-file**

将密码文件从源非 CDB 复制到临时实例的目标站点（主站点和备用站点）。
以下示例显示了存储在 ASM 中的源 CDB 的密码文件。
密码文件从源上的 ASM 中提取并写入本地文件系统，然后远程复制到目标环境（主环境和备用环境）。
为便于使用，应将文件复制到目标环境中临时实例使用的 $ORACLE_HOME/dbs 目录（默认位置），并为其指定默认名称 orapw[$ORACLE_SID 的临时实例]。

[oracle@source]$ asmcmd -p
ASMCMD [+] > cd datad1/noncdb
ASMCMD [+datad1/noncdb] > cp orapwnoncdb /home/oracle/temp/orapwtemp
copying +datad1/noncdb/orapwnoncdb -> /home/oracle/temp/orapwtemp

[oracle@source]$ scp /home/oracle/temp/orapwtemp oracle@destination-prim:[ORACLE_HOME]/dbs
[oracle@source]$ scp /home/oracle/temp/orapwtemp oracle@destination-stby:[ORACLE_HOME]/dbs/orapwtempstby

为临时实例创建一个小的 pfile。
尽管目标主环境和备用环境不需要不同，但为了清楚起见，在本示例中它们是不同的，每个临时实例获得不同的 DB_UNIQUE_NAME。
请注意每个初始化参数设置的注释。

基本的：

db_name=cont4                   # MUST match db_name of source CDB/non-CDB
db_unique_name=junk             # ONLY specify if the source db is on the same system as the TEMP instance
control_files='/home/oracle/temp/control1.ctl','/home/oracle/temp/control2.ctl'   # Just use local files
compatible='12.1.0.0.0'         #  required if compatible is not set to default value
# Since the source is a non-CDB, we do not use the enable_pluggable_database parameter

支持：

db_name=cont4                   # MUST match db_name of source CDB/non-CDB
db_unique_name=junkstby         # ONLY specify if the source db is on the same system as the TEMP instance
control_files='/home/oracle/temp/control1.ctl','/home/oracle/temp/control2.ctl'   # Just use local files
compatible='12.1.0.0.0'         #  required if compatible is not set to default value
# Since the source is a non-CDB, we do not use the enable_pluggable_database parameter

为目标临时实例创建一个 TNS 别名。
这应该在我们将运行 RMAN 的环境中完成（在本例中，目标主环境和备用环境）。
如果需要指定 DB_UNIQUE_NAME，则还必须为 TNS 地址中的 SERVICE_NAME 指定相同的值。
不要使用主机的 SCAN 地址，因为临时实例不会注册到 SCAN 侦听器。
(UR = A ) 允许我们在数据库处于挂载/不挂载模式时连接到服务。

基本的：

TEMP =
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = [primhostdb01])(PORT = 1521))
      (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = junk) (UR = A)
      )
   )

支持：

TEMPSTBY =
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = [stbyhostdb01])(PORT = 1521))
      (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = junkstby) (UR = A)
      )
   )

使用上面创建的 pfile 在目标主环境和备用环境上启动临时实例。

基本的：

$ export ORACLE_SID=[temp]
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep 4 12:51:52 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/home/oracle/demo/pfile.ora'
ORACLE instance started.
Total System Global Area  384200704 bytes
Fixed Size                  2288536 bytes
Variable Size             322962536 bytes
Database Buffers           50331648 bytes
Redo Buffers                8617984 bytes

支持：

$ export ORACLE_SID=[tempstby]
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep 4 10:53:06 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/home/oracle/demo/pfile.ora'
ORACLE instance started.
Total System Global Area  634732544 bytes
Fixed Size                  2291424 bytes
Variable Size             524290336 bytes
Database Buffers          100663296 bytes
Redo Buffers                7487488 bytes

将控制文件从源非 CDB 恢复到目标主备环境临时实例。
使用 TNS 连接到临时实例（例如 rman target sys@temp）。

RESTORE 命令中的 FROM SERVICE 子句提供到源非 CDB 的连接。
示例中的子句对上面创建的源非 CDB 使用 TNS 别名。
这是这些命令中源非 CDB 使用和需要的唯一连接。

基本的：

$ rman
Recovery Manager: Release 12.1.0.1.0 - Production on Wed Sep 4 13:32:03 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
RMAN> connect target sys@[temp]
target database Password:
connected to target database: NONCDB (not mounted)
RMAN> restore controlfile from service noncdb;
Starting restore at 04-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=790 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service noncdb
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
output file name=/home/oracle/demo/control1.ctl
output file name=/home/oracle/demo/control2.ctl
Finished restore at 04-SEP-13

支持：

$ rman
Recovery Manager: Release 12.1.0.1.0 - Production on Wed Sep 4 11:33:33 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
RMAN> connect target sys@[tempstby]
target database Password:
connected to target database: NONCDB (not mounted)
RMAN> restore controlfile from service noncdb;
Starting restore at 04-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=514 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service noncdb
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/home/oracle/demo/control1.ctl
output file name=/home/oracle/demo/control2.ctl
Finished restore at 04-SEP-13

在目标主环境和备用环境上挂载临时实例以允许对克隆的数据库文件进行编目。

RMAN> alter database mount;
Statement processed

使用“START WITH”对目标主环境和备用环境上的临时实例中的数据文件进行编目，以定位上面恢复的数据文件副本。
目录位置可以在 BACKUP AS COPY 屏幕输出中以“输出文件名”开头的行中找到。

基本的：

RMAN> catalog start with '+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE';
searching for all files that match the pattern +DATA/CONT3/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE
List of Files Unknown to the Database
=====================================
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.283.825173903
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.388.825182125
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.259.825200151
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.272.825251181
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS.384.825251183
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS2.390.825251185
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS3.374.825251187
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS4.389.825251189
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS5.373.825251191
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSAUX.385.825251191
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSTEM.387.825251193
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/USERS.386.825251261
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.283.825173903
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.388.825182125
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.259.825200151
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.272.825251181
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS.384.825251183
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS2.390.825251185
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS3.374.825251187
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS4.389.825251189
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS5.373.825251191
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSAUX.385.825251191
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSTEM.387.825251193
File Name: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/USERS.386.825251261

支持：

RMAN> catalog start with '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE';
searching for all files that match the pattern +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE
List of Files Unknown to the Database
=====================================
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.516.825244027
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS.511.825244027
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS2.513.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS3.529.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS4.514.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSAUX.528.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS5.515.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSTEM.517.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/USERS.510.825244043
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/UNDOTBS1.516.825244027
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS.511.825244027
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS2.513.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS3.529.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS4.514.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSAUX.528.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS5.515.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSTEM.517.825244029
File Name: +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/USERS.510.825244043

将目标主备环境中临时实例中的文件切换到刚刚编目的数据文件副本

基本的：

RMAN> switch database to copy;
datafile 1 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/system.387.825251193"
datafile 2 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/sysaux.385.825251191"
datafile 3 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/undotbs1.272.825251181"
datafile 4 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.386.825251261"
datafile 5 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets.384.825251183"
datafile 6 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets2.390.825251185"
datafile 7 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets3.374.825251187"
datafile 8 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets4.389.825251189"
datafile 9 switched to datafile copy "+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets5.373.825251191"

支持：

RMAN> switch database to copy;
datafile 1 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/system.517.825244029"
datafile 2 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/sysaux.528.825244029"
datafile 3 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/undotbs1.516.825244027"
datafile 4 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.510.825244043"
datafile 5 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets.511.825244027"
datafile 6 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets2.513.825244029"
datafile 7 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets3.529.825244029"
datafile 8 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets4.514.825244029"
datafile 9 switched to datafile copy "+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets5.515.825244029"

在目标主环境和备用环境的临时实例中设置 RMAN 并行度：

RMAN> configure device type disk parallelism 8;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

每隔一段时间，从源非 CDB 到目标主环境和备用环境上的临时实例执行增量应用，以保持目标数据文件在一定程度上是最新的。
这可以根据需要执行多次，直到我们准备好执行迁移。
增量过程会将临时实例中的文件与源非CDB中的文件进行比较，并确定哪些文件需要应用恢复，因此主环境临时实例和备用临时实例中所做的恢复工作可以不同例如，取决于它们各自文件的状态。
源非 CDB 可以在增量应用发生时继续应用活动。

RECOVER 命令中的 FROM SERVICE 子句提供到源非 CDB 的连接。
示例中的子句对上面创建的源非 CDB 使用 TNS 别名。
这是这些命令中源非 CDB 使用和需要的唯一连接。

基本的：

RMAN> connect target sys@[temp]
target database Password:
connected to target database: NONCDB (mounted)

RMAN> recover database noredo from service noncdb;
Starting recover at 04-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=136 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=529 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=660 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=791 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=922 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=6 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=137 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=268 device type=DISK
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service noncdb
destination for restore of datafile 00001: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/system.387.825251193
channel ORA_DISK_2: starting incremental datafile backup set restore
channel ORA_DISK_2: using network backup set from service noncdb
destination for restore of datafile 00002: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/sysaux.385.825251191
channel ORA_DISK_3: starting incremental datafile backup set restore
channel ORA_DISK_3: using network backup set from service noncdb
destination for restore of datafile 00003: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/undotbs1.272.825251181
channel ORA_DISK_4: starting incremental datafile backup set restore
channel ORA_DISK_4: using network backup set from service noncdb
destination for restore of datafile 00004: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.386.825251261
channel ORA_DISK_5: starting incremental datafile backup set restore
channel ORA_DISK_5: using network backup set from service noncdb
destination for restore of datafile 00005: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets.384.825251183
channel ORA_DISK_6: starting incremental datafile backup set restore
channel ORA_DISK_6: using network backup set from service noncdb
destination for restore of datafile 00006: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets2.390.825251185
channel ORA_DISK_7: starting incremental datafile backup set restore
channel ORA_DISK_7: using network backup set from service noncdb
destination for restore of datafile 00007: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets3.374.825251187
channel ORA_DISK_8: starting incremental datafile backup set restore
channel ORA_DISK_8: using network backup set from service noncdb
destination for restore of datafile 00008: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets4.389.825251189
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service noncdb
destination for restore of datafile 00009: +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets5.373.825251191
channel ORA_DISK_4: restore complete, elapsed time: 00:00:08
channel ORA_DISK_6: restore complete, elapsed time: 00:00:15
channel ORA_DISK_7: restore complete, elapsed time: 00:00:15
channel ORA_DISK_8: restore complete, elapsed time: 00:00:14
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_2: restore complete, elapsed time: 00:00:33
channel ORA_DISK_5: restore complete, elapsed time: 00:01:43
channel ORA_DISK_3: restore complete, elapsed time: 00:02:23
Finished recover at 04-SEP-13

支持：

RMAN> connect target sys@[tempstby]
target database Password:
connected to target database: NONCDB (mounted)

RMAN> recover database noredo from service noncdb;
Starting recover at 04-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=770 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=834 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=898 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=961 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=1026 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1090 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=1154 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1218 device type=DISK
skipping datafile 1; already restored to SCN 7688784
skipping datafile 2; already restored to SCN 7688782
skipping datafile 3; already restored to SCN 7688777
skipping datafile 5; already restored to SCN 7688778
skipping datafile 6; already restored to SCN 7688779
skipping datafile 7; already restored to SCN 7688780
skipping datafile 8; already restored to SCN 7688781
skipping datafile 9; already restored to SCN 7688783
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: using network backup set from service noncdb
destination for restore of datafile 00004: +DATAD1/CONT3STBY/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.510.825244043
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished recover at 04-SEP-13

构建要在目标主数据库上执行的插件语句。
使用 SOURCE_FILE_DIRECTORY 子句指向文件在目标 CDB 主数据库环境中恢复到的位置。
请注意，插件进程将在 SOURCE_FILE_DIRECTORY 中搜索与 DBMS_PDB.DESCRIBE 执行创建的列表 XML 文件中包含的信息匹配的文件。
使用 NOCOPY 子句，因为文件已在其预期位置。
该语句可以在中断窗口之外预先创建。

create pluggable database my_pdb using '/home/oracle/noncdb/noncdb_unplug.xml'
source_file_directory= '+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE'
nocopy;

关闭源非 CDB 并以只读方式重新启动它。
关机不能 ABORT。
此时，应用程序活动应停止。

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3206836224 bytes
Fixed Size                  3079928 bytes
Variable Size             922747144 bytes
Database Buffers         2264924160 bytes
Redo Buffers               16084992 bytes
Database mounted.
SQL> alter database open read only;
Database altered.

在源非 CDB 上，使用 DBMS_PDB.DESCRIBE()，为源非 CDB 创建 xml 列表：

SQL> exec dbms_pdb.describe('/home/oracle/demo/noncdb_unplug.xml');
PL/SQL procedure successfully completed.

保持源非 CDB 运行并通过目标主和备用环境上的临时实例执行最终增量应用。

基本的：

recover database noredo from service noncdb;

支持：

recover database noredo from service noncdb;

关闭临时实例。
将 xml 列表文件复制到目标主要主机。
如果目标主数据库和备用数据库的磁盘组名称不同，请确保在备用数据库上设置了 db_file_name_convert，仅指定磁盘组名称。

支持：

SQL> show parameter db_file_name_convert
NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------------------
db_file_name_convert                 string      +DATA, +DATAC1

登录到目标 CDB 主数据库，并使用上面创建的插件语句将非 CDB 作为 PDB 插入。
只要文件在插件之前已经存在于备用数据库中，在正确的目录中（对于 ASM，[dgname]/[dbuniqname]/[guid]/DATAFILE）并且在目标备用环境中是最新的，不需要另外的步骤待机所需。
媒体恢复将找到文件并继续处理。

SQL> set echo on
SQL> @plugin_mypdb
SQL> create pluggable database my_pdb using '/home/oracle/demo/noncdb_unplug.xml'
  2  source_file_directory= '+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE'
  3  nocopy;
Pluggable database created.

以下是主要用于查找文件的警报日志的示例输出：

Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/system.455.825151099 with afn -1
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSTEM.384.825258561 for oroirnal file-+DATAD1/NONCDB/DATAFILE/system.455.825151099 with afn-1
Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/sysaux.317.825151101 with afn -2
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SYSAUX.390.825258559 for oroirnal file-+DATAD1/NONCDB/DATAFILE/sysaux.317.825151101 with afn-2
Creating new file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/temp.444.825151103 for oroirnal file-+DATAD1/NONCDB/TEMPFILE/temp.444.825151103
Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/users.288.825151109 with afn -4
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/USERS.272.825258627 for oroirnal file-+DATAD1/NONCDB/DATAFILE/users.288.825151109 with afn-4
Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/soets.438.825151965 with afn -5
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS.387.825258551 for oroirnal file-+DATAD1/NONCDB/DATAFILE/soets.438.825151965 with afn-5
Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/soets2.436.825151971 with afn -6
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS2.385.825258553 for oroirnal file-+DATAD1/NONCDB/DATAFILE/soets2.436.825151971 with afn-6
Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/soets3.451.825151981 with afn -7
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS3.373.825258555 for oroirnal file-+DATAD1/NONCDB/DATAFILE/soets3.451.825151981 with afn-7
Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/soets4.452.825151987 with afn -8
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS4.389.825258557 for oroirnal file-+DATAD1/NONCDB/DATAFILE/soets4.452.825151987 with afn-8
Scanning source datafile directory - +DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for file oroirnally created          as +DATAD1/NONCDB/DATAFILE/soets5.443.825151993 with afn -9
Using file-+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/SOETS5.374.825258557 for oroirnal file-+DATAD1/NONCDB/DATAFILE/soets5.443.825151993 with afn-9

以下是备用数据库上用于查找文件的警报日志的示例输出：

Wed Sep 04 12:43:07 2013
Recovery scanning directory +DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE for any matching files
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/system.384.825258561
Successfully added datafile 37 to media recovery
Datafile #37: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/system.511.825251253'
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/sysaux.390.825258559
Successfully added datafile 38 to media recovery
Datafile #38: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/sysaux.528.825251253'
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/users.272.825258627
Successfully added datafile 39 to media recovery
Datafile #39: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.516.825251265'
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/soets.387.825258551
Successfully added datafile 40 to media recovery
Datafile #40: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets.517.825251253'
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/soets2.385.825258553
Successfully added datafile 41 to media recovery
Datafile #41: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets2.515.825251253'
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/soets3.373.825258555
Successfully added datafile 42 to media recovery
Datafile #42: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets3.514.825251253'
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/soets4.389.825258557
Successfully added datafile 43 to media recovery
Datafile #43: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets4.529.825251253'
Deleted Oracle managed file +DATAD1/[CONT3]/e57ca3f121dfd48ae043f646f40a61ea/datafile/soets5.374.825258557
Successfully added datafile 44 to media recovery
Datafile #44: '+DATAD1/[CONT3STBY]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets5.513.825251253'

在插件操作使用的目标主 CDB 根中的同一 SQL*Plus 会话中，使用 noncdb_to_pdb.sql 脚本完成非 CDB 到 PDB 的转换。
我们将连接到新创建的 PDB，PDB 应处于挂载模式（未打开），并且脚本应在连接到 PDB 时执行。

SQL> alter session set container=my_pdb;
Session altered.

SQL> @?/rdbms/admin/noncdb_to_pdb
SQL> Rem
SQL> Rem $Header: rdbms/admin/noncdb_to_pdb.sql /st_rdbms_12.1.0.1/9 2013/04/14 20:05:50 talliu Exp $
SQL> Rem
SQL> Rem noncdb_to_pdb.sql
SQL> Rem
SQL> Rem Copyright (c) 2011, 2013, Oracle and/or its affiliates.
SQL> Rem All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem         noncdb_to_pdb.sql - Convert PDB
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem         Converts DB to PDB.
SQL> Rem
SQL> Rem    NOTES
SQL> Rem         Given a DB with proper obj$ common bits set, we convert it to a proper
SQL> Rem         PDB by deleting unnecessary metadata.
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    sankejai    04/11/13 - 16530655: do not update status in container$
SQL> Rem    pyam        04/03/13 - rename temp cdb$* views, to not interfere when
SQL> Rem                           this is run in multiple PDBs simultaneously
SQL> Rem    pyam        02/06/13 - error out for non-CDB
SQL> Rem    pyam        01/21/13 - stop exiting on sqlerror at end
...
TIMESTAMP
-------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2013-09-04 14:46:41
1 row selected.
SQL>
SQL>   DOC
DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
...
SQL> -- leave the PDB in the same state it was when we started
SQL> BEGIN
  2    execute immediate '&open_sql &restricted_state';
  3  EXCEPTION
  4    WHEN OTHERS THEN
  5    BEGIN
  6      IF (sqlcode <> -900) THEN
  7        RAISE;
  8      END IF;
  9    END;
 10  END;
 11  /
PL/SQL procedure successfully completed.
SQL>
SQL> WHENEVER SQLERROR CONTINUE;
SQL>

脚本成功完成后，打开主数据库上的 PDB。
PDB 在主数据库和备用数据库上的状态都为 NEW，直到 PDB 在主数据库中首次打开，此时状态将更改为 NORMAL。
必须在主节点上执行此初始打开。
此初始打开会生成少量重做，这些重做将传输到备用数据库并通过介质恢复应用。
在备用数据库上应用此重做以将状态从 NEW 更改为 NORMAL 之前，无法在备用数据库上打开 PDB。

SQL> alter session set container=cdb$root;
Session altered.

SQL> alter pluggable database stark open instances=all;
Pluggable database altered.

在备用状态下，确保新 PDB 处于 NORMAL 状态并在备用状态下打开 PDB。
如果我们没有在 CREATE PLUGGABLE DATABASE 语句上指定 TEMPFILE REUSE 子句，请将文件添加到备用数据库的 TEMP 表空间。

SQL> select pdb_name, status from cdb_pdbs;
PDB_NAME             STATUS
-------------------- ------------
PDB$SEED             NORMAL
STARK                NORMAL
MY_PDB               NORMAL

SQL> alter pluggable database my_pdb open instances=all;
Pluggable database altered.
SQL> alter session set container=my_pdb;
Session altered.
SQL> alter tablespace temp add tempfile '+DATA1' size 10g;
Tablespace altered.

备份 PDB。
没有备份就无法在新的容器数据库上恢复：

RMAN> backup pluggable database my_pdb;
Starting backup at 06-SEP-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00040 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets.387.825258551
input datafile file number=00041 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets2.385.825258553
input datafile file number=00042 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets3.373.825258555
input datafile file number=00043 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets4.389.825258557
input datafile file number=00044 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/soets5.374.825258557
input datafile file number=00038 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/sysaux.390.825258559
input datafile file number=00037 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/system.384.825258561
input datafile file number=00039 name=+DATA/[CONT3]/E57CA3F121DFD48AE043F646F40A61EA/DATAFILE/users.272.825258627
channel ORA_DISK_1: starting piece 1 at 06-SEP-13
channel ORA_DISK_1: finished piece 1 at 06-SEP-13
piece handle=+RECO/CONT3/E57CA3F121DFD48AE043F646F40A61EA/BACKUPSET/2013_09_06/nnndf0_tag20130906t152558_0.381.825434759 tag=TAG20130906T152558 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:16
Finished backup at 06-SEP-13
Starting Control File and SPFILE Autobackup at 06-SEP-13
piece handle=+RECO/CONT3/AUTOBACKUP/2013_09_06/s_825434834.358.825434835 comment=NONE
Finished Control File and SPFILE Autobackup at 06-SEP-13

日期：2020-09-17 00:11:30 来源：oir作者：oir

←Oracle Memoptimized Rowstore

如何在 Oracle 中添加和删除联机重做日志成员和组→