Active database duplicate，不需要先把目标数据库进行rman备份，只要目标数据库处于归档模式下即可直接通过网络对数据库进行copy，且copy完成后自动open数据库。这对于大数据特别是T级别的数据库来说优点非常明显，复制前不需要进行备份，减少了备份和传送备份的时间，同时节省备份空间。
1.环境说明
| 目标数据库（被复制的数据库） | 复制后的数据库 | |
|---|---|---|
| IP | 172.16.215.70 | 172.16.215.38 |
| SID | orcl | orcl |
| 数据库版本 | Oracle 11.2.0.4 | 仅安装了数据库软件Oracle 11.2.0.4 |
2.确保目标数据库处于归档模式
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 266667
Next log sequence to archive 266669
Current log sequence 266669
3.在辅助数据库服务器上创建相应的目录
查询目标数据库的相关目录
select name,value from v$parameter
where name in ('audit_file_dest','background_dump_dest','control_files','core_dump_dest','user_dump_dest')
ORDER BY name ASC;
在辅助数据库服务器创建相同的目录
[oracle@oracledb ~]$ mkdir -p /u01/app/oracle/admin/orcl/adump
[oracle@oracledb ~]$ mkdir -p /u01/app/oracle/diag/rdbms/orcl/orcl/trace
[oracle@oracledb ~]$ mkdir -p /u01/app/oracle/oradata/orcl
[oracle@oracledb ~]$ mkdir -p /u01/app/oracle/fast_recovery_area/orcl
[oracle@oracledb ~]$ mkdir -p /u01/app/oracle/diag/rdbms/orcl/orcl/cdump
[oracle@oracledb ~]$ mkdir -p /u01/app/oracle/diag/rdbms/orcl/orcl/trace
4.创建口令文件
方法一： 直接从目标数据库复制密钥文件到辅助数据库相同目录
[oracle@***db ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs[oracle@***db ~]$ ls
hc_DBUA0.dat hc_orcl.dat init.ora lkORCL orapworcl snapcf_orcl.f spfileorcl.ora[oracle@***db dbs]$ scp orapworcl oracle@172.16.215.38:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
The authenticity of host '172.16.215.38 (172.16.215.38)' can't be established.
ECDSA key fingerprint is SHA256:m3/iKdDWotOXQvlNIQbNZP1xy5d+LQZG69010qrf1hM.
ECDSA key fingerprint is MD5:13:09:d3:34:ed:20:17:7b:2c:45:a8:9e:ed:ce:fc:4d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.16.215.38' (ECDSA) to the list of known hosts.
oracle@172.16.215.38's password:
orapworcl 100% 1536 1.8MB/s 00:00
方法二： orapwd生成
orapwd FILE=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl password=目标数据库sys密码 entries=30;
5.创建Pfile文件
在源数据库根据spfile生产pfile
SYS@orcl>create pfile from spfile;File created.
6.复制口令文件、pfile文件到远端目标数据库
复制口令文件和pfile文件
[oracle@***db dbs]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@***db dbs]$ scp initorcl.ora oracle@172.16.215.38:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
oracle@172.16.215.38's password:
initorcl.ora 100% 1070 1.1MB/s 00:00
[oracle@***db dbs]$ scp orapworcl oracle@172.16.215.38:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
oracle@172.16.215.38's password:
orapworcl 100% 1536 2.6MB/s 00:00
7.启动辅助数据库到nomount状态
使用复制的pfile启动，或者由pfile生成spfile后，由spfile启动
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile;File created.SQL> startup nomount
ORACLE instance started.Total System Global Area 4.0219E+10 bytes
Fixed Size 2261888 bytes
Variable Size 1.9193E+10 bytes
Database Buffers 2.0938E+10 bytes
Redo Buffers 85803008 bytes
8.辅助数据库配置监听并启动
启动监听
9.目标数据库配置网络服务名
oradu =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.215.38)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))
测试
[oracle@***db ~]$ tnsping oraduTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-APR-2025 14:07:48Copyright (c) 1997, 2013, Oracle. All rights reserved.Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.oraUsed TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.215.38)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
10.使用RMAN duplicate命令复制
[oracle@***db admin]$ rman target "sys/目标数据库密码"@orcl auxiliary "sys/目标数据库密码"@oradu
RMAN> duplicate target database to orcl from active database nofilenamecheck;
注意：sys密码一定相同才可以复制
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Apr 21 11:19:02 2025Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: ORCL (DBID=1664237422)
connected to auxiliary database: ORCL (not mounted)RMAN> duplicate target database to orcl from active database nofilenamecheck;Starting Duplicate Db at 2025-04-21 11:19:12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=699 device type=DISKcontents of Memory Script:
{sql clone "alter system set db_name = ''ORCL'' 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 nomountbackup as copy current controlfile auxiliary format '/u01/app/oracle/oradata/orcl/control01.ctl';restore clone controlfile to '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl' from '/u01/app/oracle/oradata/orcl/control01.ctl';alter clone database mount;
}
executing Memory Scriptsql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfilesql statement: alter system set db_unique_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfileOracle instance shut downOracle instance startedTotal System Global Area 40219168768 bytesFixed Size 2261888 bytes
Variable Size 19193138304 bytes
Database Buffers 20937965568 bytes
Redo Buffers 85803008 bytesStarting backup at 2025-04-21 11:19:23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=442 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f tag=TAG20250421T111923 RECID=1 STAMP=1199013563
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2025-04-21 11:19:24Starting restore at 2025-04-21 11:19:24
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=583 device type=DISKchannel ORA_AUX_DISK_1: copied control file copy
Finished restore at 2025-04-21 11:19:25database mountedcontents of Memory Script:
{set newname for datafile 1 to "/u01/app/oracle/oradata/orcl/system01.dbf";set newname for datafile 2 to "/u01/app/oracle/oradata/orcl/sysaux01.dbf";set newname for datafile 3 to "/u01/app/oracle/oradata/orcl/undotbs01.dbf";set newname for datafile 4 to "/u01/app/oracle/oradata/orcl/users01.dbf";set newname for datafile 5 to "/u01/app/oracle/oradata/orcl/users02.dbf";set newname for datafile 6 to "/u01/app/oracle/oradata/orcl/users03.dbf";set newname for datafile 7 to "/u01/app/oracle/oradata/orcl/users04.dbf";set newname for datafile 8 to "/u01/app/oracle/oradata/orcl/users05.dbf";set newname for datafile 9 to "/u01/app/oracle/oradata/orcl/users06.dbf";set newname for datafile 10 to "/u01/app/oracle/oradata/orcl/users07.dbf";set newname for datafile 11 to "/u01/app/oracle/oradata/orcl/users08.dbf";set newname for datafile 12 to "/u01/app/oracle/oradata/orcl/users09.dbf";set newname for datafile 13 to "/u01/app/oracle/oradata/orcl/users10.dbf";set newname for datafile 14 to "/u01/app/oracle/oradata/orcl/users11.dbf";set newname for datafile 15 to "/u01/app/oracle/oradata/orcl/users12.dbf";set newname for datafile 16 to "/u01/app/oracle/oradata/orcl/users13.dbf";set newname for datafile 17 to "/u01/app/oracle/oradata/orcl/users14.dbf";set newname for datafile 18 to "/u01/app/oracle/oradata/orcl/users15.dbf";set newname for datafile 19 to "/u01/app/oracle/oradata/orcl/undotbs02.dbf";set newname for datafile 20 to "/u01/app/oracle/oradata/orcl/undotbs03.dbf";set newname for datafile 21 to "/u01/app/oracle/oradata/orcl/undotbs04.dbf";set newname for datafile 22 to "/u01/app/oracle/oradata/orcl/undotbs05.dbf";set newname for datafile 23 to "/u01/app/oracle/oradata/orcl/undotbs06.dbf";set newname for datafile 24 to "/u01/app/oracle/oradata/orcl/undotbs07.dbf";set newname for datafile 25 to "/u01/app/oracle/oradata/orcl/undotbs08.dbf";set newname for datafile 26 to "/u01/app/oracle/oradata/orcl/undotbs09.dbf";set newname for datafile 27 to "/u01/app/oracle/oradata/orcl/undotbs10.dbf";set newname for datafile 28 to "/u01/app/oracle/oradata/orcl/users16.dbf";set newname for datafile 29 to "/u01/app/oracle/oradata/orcl/users17.dbf";set newname for datafile 30 to "/u01/app/oracle/oradata/orcl/users18.dbf";set newname for datafile 31 to "/u01/app/oracle/oradata/orcl/users19.dbf";backup as copy reusedatafile 1 auxiliary format "/u01/app/oracle/oradata/orcl/system01.dbf" datafile 2 auxiliary format "/u01/app/oracle/oradata/orcl/sysaux01.dbf" datafile 3 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs01.dbf" datafile 4 auxiliary format "/u01/app/oracle/oradata/orcl/users01.dbf" datafile 5 auxiliary format "/u01/app/oracle/oradata/orcl/users02.dbf" datafile 6 auxiliary format "/u01/app/oracle/oradata/orcl/users03.dbf" datafile 7 auxiliary format "/u01/app/oracle/oradata/orcl/users04.dbf" datafile 8 auxiliary format "/u01/app/oracle/oradata/orcl/users05.dbf" datafile 9 auxiliary format "/u01/app/oracle/oradata/orcl/users06.dbf" datafile 10 auxiliary format "/u01/app/oracle/oradata/orcl/users07.dbf" datafile 11 auxiliary format "/u01/app/oracle/oradata/orcl/users08.dbf" datafile 12 auxiliary format "/u01/app/oracle/oradata/orcl/users09.dbf" datafile 13 auxiliary format "/u01/app/oracle/oradata/orcl/users10.dbf" datafile 14 auxiliary format "/u01/app/oracle/oradata/orcl/users11.dbf" datafile 15 auxiliary format "/u01/app/oracle/oradata/orcl/users12.dbf" datafile 16 auxiliary format "/u01/app/oracle/oradata/orcl/users13.dbf" datafile 17 auxiliary format "/u01/app/oracle/oradata/orcl/users14.dbf" datafile 18 auxiliary format "/u01/app/oracle/oradata/orcl/users15.dbf" datafile 19 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs02.dbf" datafile 20 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs03.dbf" datafile 21 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs04.dbf" datafile 22 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs05.dbf" datafile 23 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs06.dbf" datafile 24 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs07.dbf" datafile 25 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs08.dbf" datafile 26 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs09.dbf" datafile 27 auxiliary format "/u01/app/oracle/oradata/orcl/undotbs10.dbf" datafile 28 auxiliary format "/u01/app/oracle/oradata/orcl/users16.dbf" datafile 29 auxiliary format "/u01/app/oracle/oradata/orcl/users17.dbf" datafile 30 auxiliary format "/u01/app/oracle/oradata/orcl/users18.dbf" datafile 31 auxiliary format "/u01/app/oracle/oradata/orcl/users19.dbf" ;sql 'alter system archive log current';
}
executing Memory Scriptexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting backup at 2025-04-21 11:19:30
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
output file name=/u01/app/oracle/oradata/orcl/users01.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
output file name=/u01/app/oracle/oradata/orcl/system01.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
output file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/users02.dbf
output file name=/u01/app/oracle/oradata/orcl/users02.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/users03.dbf
output file name=/u01/app/oracle/oradata/orcl/users03.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/orcl/users04.dbf
output file name=/u01/app/oracle/oradata/orcl/users04.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/u01/app/oracle/oradata/orcl/users05.dbf
output file name=/u01/app/oracle/oradata/orcl/users05.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=/u01/app/oracle/oradata/orcl/users06.dbf
output file name=/u01/app/oracle/oradata/orcl/users06.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=/u01/app/oracle/oradata/orcl/users07.dbf
output file name=/u01/app/oracle/oradata/orcl/users07.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/u01/app/oracle/oradata/orcl/users08.dbf
output file name=/u01/app/oracle/oradata/orcl/users08.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=/u01/app/oracle/oradata/orcl/users09.dbf
output file name=/u01/app/oracle/oradata/orcl/users09.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=/u01/app/oracle/oradata/orcl/users10.dbf
output file name=/u01/app/oracle/oradata/orcl/users10.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00014 name=/u01/app/oracle/oradata/orcl/users11.dbf
output file name=/u01/app/oracle/oradata/orcl/users11.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00015 name=/u01/app/oracle/oradata/orcl/users12.dbf
output file name=/u01/app/oracle/oradata/orcl/users12.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00016 name=/u01/app/oracle/oradata/orcl/users13.dbf
output file name=/u01/app/oracle/oradata/orcl/users13.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00017 name=/u01/app/oracle/oradata/orcl/users14.dbf
output file name=/u01/app/oracle/oradata/orcl/users14.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00018 name=/u01/app/oracle/oradata/orcl/users15.dbf
output file name=/u01/app/oracle/oradata/orcl/users15.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00019 name=/u01/app/oracle/oradata/orcl/undotbs02.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs02.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00020 name=/u01/app/oracle/oradata/orcl/undotbs03.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs03.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00021 name=/u01/app/oracle/oradata/orcl/undotbs04.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs04.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00022 name=/u01/app/oracle/oradata/orcl/undotbs05.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs05.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00023 name=/u01/app/oracle/oradata/orcl/undotbs06.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs06.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00024 name=/u01/app/oracle/oradata/orcl/undotbs07.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs07.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00025 name=/u01/app/oracle/oradata/orcl/undotbs08.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs08.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00026 name=/u01/app/oracle/oradata/orcl/undotbs09.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs09.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00027 name=/u01/app/oracle/oradata/orcl/undotbs10.dbf
output file name=/u01/app/oracle/oradata/orcl/undotbs10.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00028 name=/u01/app/oracle/oradata/orcl/users16.dbf
output file name=/u01/app/oracle/oradata/orcl/users16.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00029 name=/u01/app/oracle/oradata/orcl/users17.dbf
output file name=/u01/app/oracle/oradata/orcl/users17.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00030 name=/u01/app/oracle/oradata/orcl/users18.dbf
output file name=/u01/app/oracle/oradata/orcl/users18.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00031 name=/u01/app/oracle/oradata/orcl/users19.dbf
output file name=/u01/app/oracle/oradata/orcl/users19.dbf tag=TAG20250421T111930
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
Finished backup at 2025-04-21 12:56:59sql statement: alter system archive log currentcontents of Memory Script:
{backup as copy reusearchivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266686_n0cgtd60_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266686_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266693_n0cj4mtn_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266693_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266702_n0clwdbj_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266702_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266690_n0chlnjl_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266690_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266695_n0cjl09z_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266695_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266704_n0cmrpgw_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266704_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266705_n0cn0v8b_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266705_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266689_n0chbt3b_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266689_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266691_n0chossb_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266691_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266703_n0cmhwmx_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266703_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266687_n0cgzotn_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266687_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266694_n0cjcg6h_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266694_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266699_n0cl6jdv_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266699_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266696_n0cjt7wo_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266696_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266701_n0clkbpo_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266701_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266685_n0cgmvtd_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266685_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266698_n0ckm0d3_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266698_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266700_n0clhg4o_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266700_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266684_n0cgdno7_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266684_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266688_n0ch5682_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266688_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266697_n0ck76qq_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266697_%u_.arc" archivelog like "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266692_n0chv7vn_.arc" auxiliary format "/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266692_%u_.arc" ;catalog clone recovery area;switch clone datafile all;
}
executing Memory ScriptStarting backup at 2025-04-21 12:56:59
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266686 RECID=240424 STAMP=1199014092
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266686_vs3nf5cs_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266693 RECID=240431 STAMP=1199015443
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266693_vt3nf5ct_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266702 RECID=240440 STAMP=1199018252
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266702_vu3nf5cu_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266690 RECID=240428 STAMP=1199014868
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266690_vv3nf5cv_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266695 RECID=240433 STAMP=1199015872
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266695_003nf5d0_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266704 RECID=240442 STAMP=1199019158
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266704_013nf5d1_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266705 RECID=240443 STAMP=1199019419
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266705_023nf5d2_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266689 RECID=240427 STAMP=1199014618
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266689_033nf5d3_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266691 RECID=240429 STAMP=1199014969
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266691_043nf5d4_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266703 RECID=240441 STAMP=1199018876
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266703_053nf5d5_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266687 RECID=240425 STAMP=1199014261
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266687_063nf5d7_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266694 RECID=240432 STAMP=1199015662
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266694_073nf5d8_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266699 RECID=240437 STAMP=1199017552
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266699_083nf5d9_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266696 RECID=240434 STAMP=1199016136
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266696_093nf5da_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266701 RECID=240439 STAMP=1199017898
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266701_0a3nf5db_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266685 RECID=240423 STAMP=1199013883
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266685_0b3nf5dc_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266698 RECID=240436 STAMP=1199016928
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266698_0c3nf5dd_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266700 RECID=240438 STAMP=1199017838
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266700_0d3nf5de_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266684 RECID=240422 STAMP=1199013652
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266684_0e3nf5df_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266688 RECID=240426 STAMP=1199014438
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266688_0f3nf5dg_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266697 RECID=240435 STAMP=1199016550
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266697_0g3nf5dh_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=266692 RECID=240430 STAMP=1199015143
output file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266692_0h3nf5di_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 2025-04-21 12:57:23searching for all files in the recovery areaList of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266686_vs3nf5cs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266693_vt3nf5ct_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266702_vu3nf5cu_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266690_vv3nf5cv_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266695_003nf5d0_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266704_013nf5d1_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266705_023nf5d2_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266689_033nf5d3_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266691_043nf5d4_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266703_053nf5d5_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266687_063nf5d7_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266694_073nf5d8_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266699_083nf5d9_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266696_093nf5da_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266701_0a3nf5db_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266685_0b3nf5dc_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266698_0c3nf5dd_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266700_0d3nf5de_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266684_0e3nf5df_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266688_0f3nf5dg_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266697_0g3nf5dh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266692_0h3nf5di_.arc
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266686_vs3nf5cs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266693_vt3nf5ct_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266702_vu3nf5cu_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266690_vv3nf5cv_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266695_003nf5d0_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266704_013nf5d1_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266705_023nf5d2_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266689_033nf5d3_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266691_043nf5d4_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266703_053nf5d5_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266687_063nf5d7_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266694_073nf5d8_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266699_083nf5d9_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266696_093nf5da_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266701_0a3nf5db_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266685_0b3nf5dc_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266698_0c3nf5dd_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266700_0d3nf5de_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266684_0e3nf5df_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266688_0f3nf5dg_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266697_0g3nf5dh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266692_0h3nf5di_.arcdatafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1199019443 file name=/u01/app/oracle/oradata/orcl/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=1199019443 file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=1199019443 file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=6 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users03.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=7 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users04.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=8 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users05.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=9 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users06.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=10 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users07.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=11 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users08.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=12 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users09.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=13 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users10.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=14 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users11.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=15 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users12.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=16 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users13.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=17 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users14.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=18 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users15.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=19 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs02.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=20 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs03.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=21 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs04.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=22 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs05.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=23 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs06.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=24 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs07.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=25 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs08.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=26 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs09.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=27 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/undotbs10.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=28 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users16.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=29 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users17.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=30 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users18.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=31 STAMP=1199019444 file name=/u01/app/oracle/oradata/orcl/users19.dbfcontents of Memory Script:
{set until scn 20934017615087;recoverclone databasedelete archivelog;
}
executing Memory Scriptexecuting command: SET until clauseStarting recover at 2025-04-21 12:57:24
using channel ORA_AUX_DISK_1starting media recoveryarchived log for thread 1 with sequence 266684 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266684_0e3nf5df_.arc
archived log for thread 1 with sequence 266685 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266685_0b3nf5dc_.arc
archived log for thread 1 with sequence 266686 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266686_vs3nf5cs_.arc
archived log for thread 1 with sequence 266687 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266687_063nf5d7_.arc
archived log for thread 1 with sequence 266688 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266688_0f3nf5dg_.arc
archived log for thread 1 with sequence 266689 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266689_033nf5d3_.arc
archived log for thread 1 with sequence 266690 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266690_vv3nf5cv_.arc
archived log for thread 1 with sequence 266691 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266691_043nf5d4_.arc
archived log for thread 1 with sequence 266692 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266692_0h3nf5di_.arc
archived log for thread 1 with sequence 266693 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266693_vt3nf5ct_.arc
archived log for thread 1 with sequence 266694 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266694_073nf5d8_.arc
archived log for thread 1 with sequence 266695 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266695_003nf5d0_.arc
archived log for thread 1 with sequence 266696 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266696_093nf5da_.arc
archived log for thread 1 with sequence 266697 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266697_0g3nf5dh_.arc
archived log for thread 1 with sequence 266698 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266698_0c3nf5dd_.arc
archived log for thread 1 with sequence 266699 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266699_083nf5d9_.arc
archived log for thread 1 with sequence 266700 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266700_0d3nf5de_.arc
archived log for thread 1 with sequence 266701 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266701_0a3nf5db_.arc
archived log for thread 1 with sequence 266702 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266702_vu3nf5cu_.arc
archived log for thread 1 with sequence 266703 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266703_053nf5d5_.arc
archived log for thread 1 with sequence 266704 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266704_013nf5d1_.arc
archived log for thread 1 with sequence 266705 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266705_023nf5d2_.arc
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266684_0e3nf5df_.arc thread=1 sequence=266684
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266685_0b3nf5dc_.arc thread=1 sequence=266685
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266686_vs3nf5cs_.arc thread=1 sequence=266686
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266687_063nf5d7_.arc thread=1 sequence=266687
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266688_0f3nf5dg_.arc thread=1 sequence=266688
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266689_033nf5d3_.arc thread=1 sequence=266689
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266690_vv3nf5cv_.arc thread=1 sequence=266690
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266691_043nf5d4_.arc thread=1 sequence=266691
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266692_0h3nf5di_.arc thread=1 sequence=266692
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266693_vt3nf5ct_.arc thread=1 sequence=266693
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266694_073nf5d8_.arc thread=1 sequence=266694
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266695_003nf5d0_.arc thread=1 sequence=266695
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266696_093nf5da_.arc thread=1 sequence=266696
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266697_0g3nf5dh_.arc thread=1 sequence=266697
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266698_0c3nf5dd_.arc thread=1 sequence=266698
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266699_083nf5d9_.arc thread=1 sequence=266699
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266700_0d3nf5de_.arc thread=1 sequence=266700
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266701_0a3nf5db_.arc thread=1 sequence=266701
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266702_vu3nf5cu_.arc thread=1 sequence=266702
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266703_053nf5d5_.arc thread=1 sequence=266703
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266704_013nf5d1_.arc thread=1 sequence=266704
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2025_04_21/o1_mf_1_266705_023nf5d2_.arc thread=1 sequence=266705
media recovery complete, elapsed time: 00:00:32
Finished recover at 2025-04-21 12:57:57
Oracle instance startedTotal System Global Area 40219168768 bytesFixed Size 2261888 bytes
Variable Size 19193138304 bytes
Database Buffers 20937965568 bytes
Redo Buffers 85803008 bytescontents 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";shutdown clone immediate;startup clone nomount;
}
executing Memory Scriptsql statement: alter system set db_name = ''ORCL'' comment= ''Reset to original value by RMAN'' scope=spfilesql statement: alter system reset db_unique_name scope=spfileOracle instance shut downconnected to auxiliary database (not started)
Oracle instance startedTotal System Global Area 40219168768 bytesFixed Size 2261888 bytes
Variable Size 19193138304 bytes
Database Buffers 20937965568 bytes
Redo Buffers 85803008 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG MAXLOGFILES 16MAXLOGMEMBERS 3MAXDATAFILES 100MAXINSTANCES 8MAXLOGHISTORY 9344LOGFILEGROUP 1 SIZE 50 M ,GROUP 2 SIZE 50 M ,GROUP 3 SIZE 50 M DATAFILE'/u01/app/oracle/oradata/orcl/system01.dbf'CHARACTER SET ZHS16GBKcontents of Memory Script:
{set newname for tempfile 1 to "/u01/app/oracle/oradata/orcl/temp01.dbf";switch clone tempfile all;catalog clone datafilecopy "/u01/app/oracle/oradata/orcl/sysaux01.dbf", "/u01/app/oracle/oradata/orcl/undotbs01.dbf", "/u01/app/oracle/oradata/orcl/users01.dbf", "/u01/app/oracle/oradata/orcl/users02.dbf", "/u01/app/oracle/oradata/orcl/users03.dbf", "/u01/app/oracle/oradata/orcl/users04.dbf", "/u01/app/oracle/oradata/orcl/users05.dbf", "/u01/app/oracle/oradata/orcl/users06.dbf", "/u01/app/oracle/oradata/orcl/users07.dbf", "/u01/app/oracle/oradata/orcl/users08.dbf", "/u01/app/oracle/oradata/orcl/users09.dbf", "/u01/app/oracle/oradata/orcl/users10.dbf", "/u01/app/oracle/oradata/orcl/users11.dbf", "/u01/app/oracle/oradata/orcl/users12.dbf", "/u01/app/oracle/oradata/orcl/users13.dbf", "/u01/app/oracle/oradata/orcl/users14.dbf", "/u01/app/oracle/oradata/orcl/users15.dbf", "/u01/app/oracle/oradata/orcl/undotbs02.dbf", "/u01/app/oracle/oradata/orcl/undotbs03.dbf", "/u01/app/oracle/oradata/orcl/undotbs04.dbf", "/u01/app/oracle/oradata/orcl/undotbs05.dbf", "/u01/app/oracle/oradata/orcl/undotbs06.dbf", "/u01/app/oracle/oradata/orcl/undotbs07.dbf", "/u01/app/oracle/oradata/orcl/undotbs08.dbf", "/u01/app/oracle/oradata/orcl/undotbs09.dbf", "/u01/app/oracle/oradata/orcl/undotbs10.dbf", "/u01/app/oracle/oradata/orcl/users16.dbf", "/u01/app/oracle/oradata/orcl/users17.dbf", "/u01/app/oracle/oradata/orcl/users18.dbf", "/u01/app/oracle/oradata/orcl/users19.dbf";switch clone datafile all;
}
executing Memory Scriptexecuting command: SET NEWNAMErenamed tempfile 1 to /u01/app/oracle/oradata/orcl/temp01.dbf in control filecataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf RECID=1 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf RECID=2 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users01.dbf RECID=3 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users02.dbf RECID=4 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users03.dbf RECID=5 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users04.dbf RECID=6 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users05.dbf RECID=7 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users06.dbf RECID=8 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users07.dbf RECID=9 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users08.dbf RECID=10 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users09.dbf RECID=11 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users10.dbf RECID=12 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users11.dbf RECID=13 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users12.dbf RECID=14 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users13.dbf RECID=15 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users14.dbf RECID=16 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users15.dbf RECID=17 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs02.dbf RECID=18 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs03.dbf RECID=19 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs04.dbf RECID=20 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs05.dbf RECID=21 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs06.dbf RECID=22 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs07.dbf RECID=23 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs08.dbf RECID=24 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs09.dbf RECID=25 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/undotbs10.dbf RECID=26 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users16.dbf RECID=27 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users17.dbf RECID=28 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users18.dbf RECID=29 STAMP=1199019489
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/orcl/users19.dbf RECID=30 STAMP=1199019489datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users03.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users04.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users05.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users06.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users07.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users08.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users09.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users10.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users11.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users12.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users13.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users14.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users15.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs02.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs03.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs04.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs05.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs06.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs07.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs08.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs09.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/undotbs10.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users16.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users17.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users18.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=1199019489 file name=/u01/app/oracle/oradata/orcl/users19.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database add supplemental log data
Executing: alter database add supplemental log data(ALL) columns
Executing: alter database force loggingcontents of Memory Script:
{Alter clone database open resetlogs;
}
executing Memory Scriptdatabase opened
Finished Duplicate Db at 2025-04-21 12:58:13
11.检查结果
logfile的文件名变化了，后期自己rename
select * from v$logfile order by group# asc;
