一、准备辅助实例
1、启动辅助实例
[oracle@19c02 ~]$ export ORACLE_SID=test
[oracle@19c02 ~]$ cat pfile.ora
db_name=orcl
ENABLE_PLUGGABLE_DATABASE=TRUE
SQL> startup nomount pfile='/home/oracle/pfile.ora';
ORACLE instance started.
Total System Global Area 356512392 bytes
Fixed Size 9134728 bytes
Variable Size 289406976 bytes
Database Buffers 50331648 bytes
Redo Buffers 7639040 bytes
此处复制的pdb,所以需要提前加入参数ENABLE_PLUGGABLE_DATABASE=TRUE
2、配置连接串
[oracle@19c02 admin]$ cat tnsnames.ora
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.220.202)(PORT = 1526))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PRODCDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.220.201)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PRODCDB)
)
)
3、配置静态监听
[oracle@19c02 ~]$ rman target sys/oracle@prodcdb auxiliary /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 7 11:29:59 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODCDB (DBID=3160879607)
connected to auxiliary database: ORCL (not mounted)
RMAN> duplicate target database to orcl from active database password file;
Starting Duplicate Db at 07-MAR-24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/07/2024 11:30:25
RMAN-05501: aborting duplication of target database
RMAN-06217: not connected to auxiliary database with a net service name
根据以上报错可以看出来异机复制的时候需要通过service name连接辅助库，在数据库只是处于nomount状态时连接，只有通过静态监听了
[oracle@19c02 admin]$ vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.220.202)(PORT = 1526))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl)
(SID_NAME=test)
(ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1)
)
)
根据模板随便改一个，注意ORACLE_HOME和SID_NAME填写正确即可，其它的随便填。
[oracle@19c02 admin]$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-MAR-2024 11:33:35
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/19c02/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.220.202)(PORT=1526)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.220.202)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 07-MAR-2024 11:33:35
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/19c02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.220.202)(PORT=1526)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
现在可以发现静态监听里面的GLOBAL_DBNAME只是被监听这里拿来当作服务名用，随便填写即可，主要tnsname.ora种的service_name需要和这里保持一致。
4、配置密码文件
需要造一个密码文件，因为复制到远程主机或者活动数据库复制时密码文件是必须的。在复制备库时会自动复制密码文件，但是其它复制情况下只有指定passwrd file参数才会复制密码文件。并且覆盖当前实例的密码文件。
关于创建密码文件，官方文档给出来4种方法
1、当在同机复制数据库时，直接复制目标库的密码文件并改名位辅助库的密码文件名即可。
2、手动创建密码文件。保证目标数据库和辅助实例中的SYSDBA和SYSBACKUP用户的密码相同。
3、使用orapwd创建一个sysbackup条目。
orapwd FILE='/u01/oracle/dbs/orapworcl' FORMAT=12.2
4、复制时指定password file。但是因为异机复制需要提前准备密码文件，使用fuplicate复制过来的密码文件只是覆盖之前的密码文件而已。
[oracle@19c02 dbs]$ orapwd FILE='/u01/app/oracle/product/19.3.0/dbhome_1/dbs/orapwtest' FORMAT=12.2 password=P@ssw0rd
SQL> select * from v$pwfile_users;
USERNAME SYSDBA SYSOPER SYSASM SYSBACKUP SYSDG SYSKM ACCOUNT_ST PASSWORD_PROFILE LAST_LOGIN LOCK_DATE EXPIRY_DATE EXTERNAL_NAME AUTHENTICATION_T COMMON CON_ID
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------- ---------- ------------ ------------ -------------------- ---------------- ------ ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE OPEN PASSWORD YES 0
SYSTEM FALSE TRUE FALSE FALSE FALSE FALSE OPEN PASSWORD NO 1
RMAN> duplicate target database to orcl from active database password file;
Starting Duplicate Db at 07-MAR-24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/07/2024 13:07:38
RMAN-05501: aborting duplication of target database
RMAN-05614: Passwords for target and auxiliary connections must be the same when using active duplicate
还要求目标库和辅助库密码相同
二、启动复制
1、有趣的报错
[oracle@19c02 admin]$ rman target sys/oracle@prodcdb auxiliary sys/oracle@orcl
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 7 13:20:45 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODCDB (DBID=3160879607)
connected to auxiliary database: ORCL (not mounted)
RMAN> duplicate target database to orcl from active database password file;
Starting Duplicate Db at 07-MAR-24
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=292 device type=DISK
current log archived
contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format '/u01/app/oracle/product/19.3.0/dbhome_1/dbs/orapwtest' ;
sql clone "create spfile from memory";
}
executing Memory Script
Starting backup at 07-MAR-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=145 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/07/2024 13:21:52
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/07/2024 13:21:52
ORA-17627: ORA-12541: TNS:no listener
ORA-17629: Cannot connect to the remote database server
这里报错无法连接目标库。检查数据库发现目标库和辅助库都使用静态监听、tnsnames.ora文件种均配置了目标库和辅助库。这个报错很奇怪。无意中换不通的复制命令竟然报错改变了。
2、password file子命令
[oracle@19c02 admin]$ rman target sys/oracle@prodcdb auxiliary sys/oracle@orcl
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 7 13:27:37 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODCDB (DBID=3160879607)
connected to auxiliary database: ORCL (not mounted)
RMAN> duplicate target database to orcl from active database;
Starting Duplicate Db at 07-MAR-24
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=8 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 356512392 bytes
Fixed Size 9134728 bytes
Variable Size 289406976 bytes
Database Buffers 50331648 bytes
Redo Buffers 7639040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''PRODCDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''orcl'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'prodcdb' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''PRODCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''orcl'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 356512392 bytes
Fixed Size 9134728 bytes
Variable Size 289406976 bytes
Database Buffers 50331648 bytes
Redo Buffers 7639040 bytes
Starting restore at 07-MAR-24
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=424 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service prodcdb
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/cntrltest.dbf
Finished restore at 07-MAR-24
database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/07/2024 13:28:59
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PDB1/data01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_system_lyfjqnmf_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PDB1/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PDB1/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PDB1/system01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_system_lydyzg24_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_system_lydywn4d_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/seed/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/seed/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/seed/system01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_system_lydxjthk_.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_3_lydxmtp7_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_3_lydxmsto_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_2_lydxmtgv_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_2_lydxmst7_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_1_lydxmt7k_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_1_lydxmssj_.log conflicts with a file used by the target database
RMAN> ^[[A
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02003: unrecognized character:
同样的监听和tnsnames.ora配置，只是将复制命令种的password file删除，竟然执行这么多。看来前面的连接错误与命令有关。目前这个命令是因为检查到重名文件，加上nofilenamecheck就成。
3、nofilenamecheck子命令
这条子命令的作用是检查辅助库是否与目标库有同名数据文件。当辅助库和目标库存在相同的为目录结构和数据文件时，官方给出了以下集中几种解决方式
RMAN> duplicate target database to orcl from active database nofilenamecheck;
Starting Duplicate Db at 07-MAR-24
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 356512392 bytes
Fixed Size 9134728 bytes
Variable Size 289406976 bytes
Database Buffers 50331648 bytes
Redo Buffers 7639040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''PRODCDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''orcl'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'prodcdb' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''PRODCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''orcl'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 356512392 bytes
Fixed Size 9134728 bytes
Variable Size 289406976 bytes
Database Buffers 50331648 bytes
Redo Buffers 7639040 bytes
Starting restore at 07-MAR-24
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=424 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service prodcdb
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/cntrltest.dbf
Finished restore at 07-MAR-24
database mounted
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_1_lydxmssj_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_1_lydxmt7k_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_2_lydxmst7_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_2_lydxmtgv_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_3_lydxmsto_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_3_lydxmtp7_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_system_lydxjthk_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/seed/system01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/seed/sysaux01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/seed/undotbs01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_system_lydywn4d_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_system_lydyzg24_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PDB1/system01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PDB1/sysaux01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PDB1/undotbs01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_system_lyfjqnmf_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/PDB1/data01.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_temp_lydxn0th_.tmp conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_temp_lyfjqnmn_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_temp_lydywn4f_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_temp_lydyzg26_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/PDB1/temp.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/PRODCDB/seed/temp01.dbf conflicts with a file used by the target database
contents of Memory Script:
{
set newname for datafile 1 to
"/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_system_lydxjthk_.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/PRODCDB/seed/system01.dbf";
set newname for datafile 6 to
"/u01/app/oracle/oradata/PRODCDB/seed/sysaux01.dbf";
set newname for datafile 7 to
"/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.dbf";
set newname for datafile 8 to
"/u01/app/oracle/oradata/PRODCDB/seed/undotbs01.dbf";
set newname for datafile 13 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_system_lydywn4d_.dbf";
set newname for datafile 14 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.dbf";
set newname for datafile 15 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.dbf";
set newname for datafile 16 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.dbf";
set newname for datafile 17 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_system_lydyzg24_.dbf";
set newname for datafile 18 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.dbf";
set newname for datafile 19 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.dbf";
set newname for datafile 20 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.dbf";
set newname for datafile 24 to
"/u01/app/oracle/oradata/PDB1/system01.dbf";
set newname for datafile 25 to
"/u01/app/oracle/oradata/PDB1/sysaux01.dbf";
set newname for datafile 26 to
"/u01/app/oracle/oradata/PDB1/undotbs01.dbf";
set newname for datafile 27 to
"/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_system_lyfjqnmf_.dbf";
set newname for datafile 28 to
"/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.dbf";
set newname for datafile 29 to
"/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.dbf";
set newname for datafile 48 to
"/u01/app/oracle/oradata/PDB1/data01.dbf";
restore
from nonsparse from service
'prodcdb' clone database
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
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 restore at 07-MAR-24
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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_system_lydxjthk_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/PRODCDB/seed/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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/PRODCDB/seed/sysaux01.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/PRODCDB/seed/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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_system_lydywn4d_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00014 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00015 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00016 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00017 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_system_lydyzg24_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00018 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00019 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00020 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00024 to /u01/app/oracle/oradata/PDB1/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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00025 to /u01/app/oracle/oradata/PDB1/sysaux01.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00026 to /u01/app/oracle/oradata/PDB1/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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00027 to /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_system_lyfjqnmf_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00028 to /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00029 to /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00048 to /u01/app/oracle/oradata/PDB1/data01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 07-MAR-24
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'prodcdb'
archivelog from scn 2947639;
switch clone datafile all;
}
executing Memory Script
Starting restore at 07-MAR-24
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service prodcdb
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=18
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service prodcdb
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=19
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 07-MAR-24
datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_system_lydxjthk_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/seed/system01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=8 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/seed/sysaux01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=9 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=10 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/seed/undotbs01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=11 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_system_lydywn4d_.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=12 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=13 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=14 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=15 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_system_lydyzg24_.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=16 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=17 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=18 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=19 STAMP=1162993189 file name=/u01/app/oracle/oradata/PDB1/system01.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=20 STAMP=1162993189 file name=/u01/app/oracle/oradata/PDB1/sysaux01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=21 STAMP=1162993189 file name=/u01/app/oracle/oradata/PDB1/undotbs01.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=22 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_system_lyfjqnmf_.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=23 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=24 STAMP=1162993189 file name=/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=25 STAMP=1162993189 file name=/u01/app/oracle/oradata/PDB1/data01.dbf
contents of Memory Script:
{
set until scn 2947916;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 07-MAR-24
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 18 is already on disk as file /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_18_1162805625.dbf
archived log for thread 1 with sequence 19 is already on disk as file /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_19_1162805625.dbf
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_18_1162805625.dbf thread=1 sequence=18
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_19_1162805625.dbf thread=1 sequence=19
media recovery complete, elapsed time: 00:00:00
Finished recover at 07-MAR-24
contents of Memory Script:
{
delete clone force archivelog all;
}
executing Memory Script
released channel: ORA_AUX_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=271 device type=DISK
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_18_1162805625.dbf RECID=1 STAMP=1162993187
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_19_1162805625.dbf RECID=2 STAMP=1162993188
Deleted 2 objects
Oracle instance started
Total System Global Area 356512392 bytes
Fixed Size 9134728 bytes
Variable Size 289406976 bytes
Database Buffers 50331648 bytes
Redo Buffers 7639040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''ORCL'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 356512392 bytes
Fixed Size 9134728 bytes
Variable Size 289406976 bytes
Database Buffers 50331648 bytes
Redo Buffers 7639040 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_1_lydxmssj_.log', '/u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_1_lydxmt7k_.log' ) SIZE 200 M REUSE,
GROUP 2 ( '/u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_2_lydxmst7_.log', '/u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_2_lydxmtgv_.log' ) SIZE 200 M REUSE,
GROUP 3 ( '/u01/app/oracle/oradata/PRODCDB/onlinelog/o1_mf_3_lydxmsto_.log', '/u01/app/oracle/fast_recovery_area/PRODCDB/onlinelog/o1_mf_3_lydxmtp7_.log' ) SIZE 200 M REUSE
DATAFILE
'/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_system_lydxjthk_.dbf',
'/u01/app/oracle/oradata/PRODCDB/seed/system01.dbf',
'/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_system_lydywn4d_.dbf',
'/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_system_lydyzg24_.dbf',
'/u01/app/oracle/oradata/PDB1/system01.dbf',
'/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_system_lyfjqnmf_.dbf'
CHARACTER SET AL32UTF8
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_temp_lydxn0th_.tmp";
set newname for tempfile 3 to
"/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_temp_lyfjqnmn_.dbf";
set newname for tempfile 4 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_temp_lydywn4f_.dbf";
set newname for tempfile 5 to
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_temp_lydyzg26_.dbf";
set newname for tempfile 10 to
"/u01/app/oracle/oradata/PDB1/temp.dbf";
set newname for tempfile 12 to
"/u01/app/oracle/oradata/PRODCDB/seed/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.dbf",
"/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.dbf",
"/u01/app/oracle/oradata/PRODCDB/seed/sysaux01.dbf",
"/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.dbf",
"/u01/app/oracle/oradata/PRODCDB/seed/undotbs01.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.dbf",
"/u01/app/oracle/oradata/PDB1/sysaux01.dbf",
"/u01/app/oracle/oradata/PDB1/undotbs01.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.dbf",
"/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.dbf",
"/u01/app/oracle/oradata/PDB1/data01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_temp_lydxn0th_.tmp in control file
renamed tempfile 3 to /u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_temp_lyfjqnmn_.dbf in control file
renamed tempfile 4 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_temp_lydywn4f_.dbf in control file
renamed tempfile 5 to /u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_temp_lydyzg26_.dbf in control file
renamed tempfile 10 to /u01/app/oracle/oradata/PDB1/temp.dbf in control file
renamed tempfile 12 to /u01/app/oracle/oradata/PRODCDB/seed/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.dbf RECID=1 STAMP=1162993214
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.dbf RECID=2 STAMP=1162993214
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/seed/sysaux01.dbf RECID=3 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.dbf RECID=4 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/seed/undotbs01.dbf RECID=5 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.dbf RECID=6 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.dbf RECID=7 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.dbf RECID=8 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.dbf RECID=9 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.dbf RECID=10 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.dbf RECID=11 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PDB1/sysaux01.dbf RECID=12 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PDB1/undotbs01.dbf RECID=13 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.dbf RECID=14 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.dbf RECID=15 STAMP=1162993215
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PDB1/data01.dbf RECID=16 STAMP=1162993215
datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1162993214 file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_sysaux_lydxkxml_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1162993214 file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_undotbs1_lydxldok_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/seed/sysaux01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/datafile/o1_mf_users_lydxlfqp_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=5 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/seed/undotbs01.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=6 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydywn4f_.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=7 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydywn4f_.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=8 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D4436AE063C9DC10AC124D/datafile/o1_mf_users_lydywn4f_.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=9 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_sysaux_lydyzg25_.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=10 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_undotbs1_lydyzg25_.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=11 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E12327A1D6436AE063C9DC10AC124D/datafile/o1_mf_users_lydyzg26_.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=12 STAMP=1162993215 file name=/u01/app/oracle/oradata/PDB1/sysaux01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=13 STAMP=1162993215 file name=/u01/app/oracle/oradata/PDB1/undotbs01.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=14 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_sysaux_lyfjqnmm_.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=15 STAMP=1162993215 file name=/u01/app/oracle/oradata/PRODCDB/12E54525F38C916EE063C9DC10AC8B21/datafile/o1_mf_undotbs1_lyfjqnmn_.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=16 STAMP=1162993215 file name=/u01/app/oracle/oradata/PDB1/data01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
contents of Memory Script:
{
sql clone "alter pluggable database all open";
}
executing Memory Script
sql statement: alter pluggable database all open
Cannot remove created server parameter file
Finished Duplicate Db at 07-MAR-24
复制成功。那么可以确定前面的报错RMAN-05501、RMAN-03015、RMAN-03009、ORA-17627: ORA-12541、ORA-17629与监听配置、tnsnames.ora配置无关。
三、复制语法
rman有几条命令语法非常复杂，此处使用的时duplicate
DUPLICATE [ { {DATABASE [['] database_name ['] [DBID integer] [INCARNATION primaryKey]] | TARGET DATABASE} | [TARGET] PLUGGABLE DATABASE pdb_name [AS pdb_name]}] [ {FOR {FARSYNC | STANDBY} | TO ['] database_name [']}] [dupOptionList
duplicate命令语法前半部分使用较为固定，为database/target database/target pluggable database 。
for关键字用于制作备库,字句有standby/farsync。
to关键字后面也是固定的新数据库的名字。
命令后半部分dupOptionList部分主要为复制的控制选项，用于控制整个复制命令。
常用的选项有
- BACKUP LOCATION：数据库的备份和副本的备份位置。此选项对于没有目标或恢复目录连接的复制有效。
- DORECOVER：创建后恢复备用数据库。如果指定untilClause，则 RMAN 将恢复到指定的 SCN 或时间并保持数据库已装载。
- fileNameConversionSpec：主要为DB_FILE_NAME_CONVERT等参数，用户调整辅助库数据文件目录。调整辅助库目录方法有很多。
- FROM ACTIVE DATABASE：直接从源数据库而不是从源数据库的备份提供复制数据库的文件
- LOGFILE:指定在创建非备用数据库的重复数据库时创建联机重做日志的选项
- logSpec:指定联机重做日志文件的文件名和组。
- NOCHECK:禁用 RMAN 检查一组表空间是否必须是独立的功能。当使用目标连接执行基于备份的复制时，RMAN 自动执行此检查。
- NOFILENAMECHECK:当源数据库文件与重复数据库文件同名时，阻止 RMAN 检查源数据库的数据文件和联机重做日志文件是否正在使用
- NOOPEN:指定重复数据库在创建后不得打开。
- PASSWORD FILE:使用源数据库上的密码文件覆盖辅助实例当前使用的密码文件
- PLUGGABLE DATABASE pdb_name:将逗号分隔列表中指定的一个或多个 PDB 复制到新的 CDB。
- PFILE filename:指定辅助实例使用的基于文本的初始化参数文件RMAN 在复制期间自动关闭并重新启动辅助实例。如果辅助实例不使用默认位置中的服务器参数文件，则必须指定 RMAN 在启动辅助实例时使用的基于文本的初始化参数文件。初始化参数文件必须与用于执行复制的 RMAN 客户端位于同一主机上。
- SKIP READONLY:从重复数据库中排除当前只读表空间中的数据文件。默认情况下，RMAN 复制当前只读表空间
- SKIP PLUGGABLE DATABASE pdb_name:将 CDB 中的所有 PDB（逗号分隔列表中指定的除外）复制pdb_name到新 CDB。
- SKIP TABLESPACE tablespace_name:从重复数据库中排除指定的表空间
- SKIP TABLESPACE pdb-name:tablespace_name:将 PDB 复制到新的 CDB 时，从重复的 PDB 中排除指定的表空间。
- SPFILE:将服务器参数文件从源数据库复制到复制数据库。不使用先前在辅助数据库中设置的初始化参数。
- TO RESTORE POINT restore_point_name：指定基于备份的复制的还原点，以创建还原点的 SCN 作为上限（包含上限）。
- untilClause：设置基于备份的复制中时间点恢复的结束时间、SCN 或日志序列号.注意该参数不支持活动数据库复制
- USING BACKUPSET：通过使用备份集将全部或部分数据从源数据库复制到目标数据库来执行活动数据库复制。
- USING COMPRESSED BACKUPSET：对从源数据库到辅助数据库的数据传输启用二进制压缩，从而减少网络带宽消耗。
- SET identifier string：将指定的初始化参数设置为指定的值
四、辅助数据库文件命名策略
1、辅助库与目标库使用相同文件名
适用于异机复制。辅助库和目标库使用相同的目录结构。如果时asm也需要相同磁盘组名称。如果使用OMF，则DB_CREATE_FILE_DEST参数需要与目标库相同。
2、辅助库与目标库不同文件名
1、set newname命令
SET NEWNAME FOR DATABASE
SET NEWNAME FOR DATAFILE
SET NEWNAME FOR TABLESPACE
SET NEWNAME FOR TEMPFILE
对于OMF和ASM数据库文件必须使用该SET NEWNAME…TO NEW命令，并且不能显式提供数据库文件的名称。必须使用该SET NEWNAME…TO NEW命令，并且不能显式提供数据库文件的名称。
2、CONFIGURE AUXNAME命令
指定辅助数据库文件的非 OMF 和非 ASM 备用名称。
3、duplicate的spfile字句
通过指定DB_FILE_NAME_CONVERT等路劲转换参数调整数据文件位置
4、DB_FILE_NAME_CONVERT和LOG_FILE_NAME_CONVERT初始化参数
5、DB_CREATE_FILE_DEST和DB_CREATE_ONLINE_LOG_DEST_n 参数
五、删库重来
RMAN> run
2> { set newname for database to '/u01/backup/test/%b';
3> duplicate target database to orcl from active database nofilenamecheck;
4> }
executing command: SET NEWNAME
Starting Duplicate Db at 07-MAR-24
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
current log archived
...
datafile 28 switched to datafile copy
input datafile copy RECID=14 STAMP=1163001161 file name=/u01/backup/test/o1_mf_sysaux_ly
Oracle instance shut down
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/07/2024 15:41:20
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: Oracle error from auxiliary database: ORA-19563: Inspect Datafile Copy: SCN number validation unsuccessful header validation failed for file /u01/backup/test/system01.dbf
RMAN>
第一次有一个上面的报错，pdb和cdb都有个叫system01的数据库文件，当转换到/u01/backup/test路径下冲突了。修改下数据文件名就行
六、将PDB复制到现有 CDB
RMAN> run
2> { set newname for database to '/u01/backup/test/%b';
3> DUPLICATE PLUGGABLE DATABASE pdb1 AS prodpdb1 TO PROD FROM ACTIVE DATABASE nofilenamecheck;
4> }
executing command: SET NEWNAME
Starting Duplicate PDB at 07-MAR-24
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=394 device type=DISK
current log archived
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location
contents of Memory Script:
{
set newname for datafile 24 to
"/u01/backup/test/system01.dbf";
set newname for datafile 25 to
"/u01/backup/test/sysaux01.dbf";
set newname for datafile 26 to
"/u01/backup/test/undotbs01.dbf";
set newname for datafile 48 to
"/u01/backup/test/data01.dbf";
restore
from nonsparse clone foreign pluggable database
"PDB1"
from service 'prodcdb' ;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 07-MAR-24
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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring foreign file 24 to /u01/backup/test/system01.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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring foreign file 25 to /u01/backup/test/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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring foreign file 26 to /u01/backup/test/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 prodcdb
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring foreign file 48 to /u01/backup/test/data01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 07-MAR-24
current log archived
contents of Memory Script:
{
set archivelog destination to '/u01/arch';
restore clone force from service 'prodcdb'
foreign archivelog from scn 3142295;
}
executing Memory Script
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 07-MAR-24
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/u01/arch
channel ORA_AUX_DISK_1: using network backup set from service prodcdb
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=36
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/u01/arch
channel ORA_AUX_DISK_1: using network backup set from service prodcdb
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=37
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 07-MAR-24
Performing import of metadata...
Finished Duplicate PDB at 07-MAR-24
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
