Oracle RMAN同步数据库Active database duplicate
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;
相关文章：
Oracle RMAN同步数据库Active database duplicate
Active database duplicate，不需要先把目标数据库进行rman备份，只要目标数据库处于归档模式下即可直接通过网络对数据库进行copy，且copy完成后自动open数据库。这对于大数据特别是T级别的数据库来说优点非常明显，复制前不需要进行…...
Spring MVC 一个简单的多文件上传
原始代码逐行解释 PostMapping("/uploads") // ① 声明处理POST请求，路径为"/uploads" ResponseBody // ② 直接返回数据到响应体，不进行视图解析 public String uploads(MultipartFile[] files, // …...
基于DeepSeek/AI的资产测绘与威胁图谱构建
引言： 在网络安全攻防实践中，资产测绘是红队作战与蓝队安全运营的第一步，其本质都是通过系统性信息采集实现攻击面管理。 当前普遍存在的痛点在于，当企业级资产规模呈指数级增长时，传统基于规则引擎的低效批量处理方式…...
构建自动翻译工作流：技术与实践
一、引言 制药行业客户迫切需要一种翻译解决方案，以解决公司内部多样化的翻译难题。他们需要的不仅是提升翻译效率和准确性的工具，更希望能够保持文档的原始格式。我们观察到客户的需求广泛，包括多语言办公文件、研究文档和药品报批文件等&a…...
【Linux】中的网络管理
目录 1.ipv4原理，网关与DNS定义 2ip图形化配置--nm 2.1图形化平台配置 2.2无图形化平台配置 3.常用的网络命令--ping，wget，curl ping wget curl 4.ip命令临时配置---ifconfig，ip a ifconfig ip address 5.ip命令永久配…...
前端面试每日三题 - Day 10
这是我为准备前端/全栈开发工程师面试整理的第十天每日三题练习，涵盖： JavaScript 中 this 的指向详解与常见陷阱Vue 生命周期钩子的执行顺序与场景实践（Vue2 vs Vue3）系统设计实战：内容推荐系统的核心架构设计 ✅ 题…...
《深度学习》课程之卷积神经网络原理与实践教学设计方案
《深度学习》课程之卷积神经网络原理与实践教学设计方案 一、教学目标设计 （一）知识目标 学生能够准确描述卷积神经网络（CNN）的基本定义，包括其核心组成部分（如卷积层、池化层、全连接层等）及…...
elasticsearch中文分词器插件下载教程
一、下载原因： 我们的业务中通常使⽤的是中⽂分词，es的中⽂分词默认会将中⽂词每个字看成⼀个词⽐如：“我想吃⾁夹馍”会被分为”我”，”想”，”吃”，”⾁” ，”夹”，”馍” 这显然是…...
门面模式与适配器模式
一、门面模式 门面模式：提供统一接口访问子系统接口 1、包含角色 外观系统对外的统一接口子系统类的集合；并不知道外观角色的存在，需要为了配合外观角色而做特殊处理或修改 2、举例 原本开关灯要分别操作各个房间的灯，现在设置总…...
QSS【QT】
文章目录 QSSid选择器 & 类型选择器伪类选择器盒子模型 QSS 设置样式的时候，是可以指定某个控件来设置的。 指定控件之后，此时的样式就会针对这个指定的控件，也会针对子控件生效 ui->pushButton_2->setStyleSheet("QPushButt…...
第十六节：高频开放题-React与Vue设计哲学差异
响应式原理（Proxy vs 虚拟DOM） 组合式API vs Hooks React 与 Vue 设计哲学差异深度解析 一、响应式原理的底层实现差异 1. Vue 的响应式模型（Proxy/数据劫持） Vue 的响应式系统通过 数据劫持 实现自动依赖追踪： • …...
css 中float属性及clear的释疑
float属性可以让元素脱离文档流，父元素中的子元素设置为float,则会导致父元素的高度塌陷。 <style type"text/css"> .father{ /*没有给父元素定义高度*/background:#ccc; border:1px dashed #999; } .box01,.box02,.box0…...
缓存 --- 内存缓存 or 分布式缓存
缓存 --- 内存缓存 or 分布式缓存 内存缓存（In-Memory Cache）分布式缓存（Distributed Cache）内存缓存 vs 分布式缓存 内存缓存和分布式缓存是两种常见的缓存策略，它们在存储位置、访问速度和适用场景上有所不同。下面分…...
2025.4.17总结
工作：今天对需求的测试设计进行了完善，然后，对测试设计进行了评审，最后提了个问题单。 反思这个过程，要说不足的地方，就是评审的时候总觉得自己吐字不清晰，表达能力早就想提升了，但…...
BH1750光照传感器---附代码
目录 BH1750简介BH1750指令集BH1750工作流程 BH1750简介 VCC-->电源正； ADDR-->地址端口； GND-->电源负； PA5-->SDA-->I2C数据线； PA3-->SCL-->I2C时钟线； DVI-->I2C端口参考电压；…...
机器学习在催化剂设计中的应用理论加实操
背景介绍 数据智能驱动，催化理性设计新纪元 催化材料设计是能源转化、化工合成及环境治理等领域的核心挑战。传统催化研究主要依赖密度泛函理论(DFT)计算与实验试错法，通过量子力学模拟揭示活性位点电子结构，结合高通量实验筛选候选…...
蔡浩宇的AIGC游戏革命：从《原神》到《Whispers》的技术跨越
目录 引言：游戏行业的AI革命前夜 一、《Whispers》的技术突破与市场挑战 1.1 多模态AI技术的集成应用 1.2 与传统游戏的差异化体验 1.3 面临的商业化难题 二、从《原神》到《Whispers》的技术演进 2.1 《原神》成功的时代因素分析 2.2 蔡浩宇的技术路线转变 …...
Docker Compose 命令实现动态构建和部署
Docker Compose 命令实现动态构建和部署 一、编写支持动态版本号的 docker-compose.yml version: 3.8services:myapp:build: context: . # Dockerfile所在目录args:APP_VERSION: ${TAG:-latest} # 从环境变量获取版本号，默认latestimage: myapp:${TAG:-latest} …...
前端vue+typeScritp+elementPlus基础页面实现：
效果： 前端代码： index.vue: <template><el-container><el-main><el-card class"search-card" shadow"never"><transition :enter-active-class"proxy?.animate.searchAnimate.enter" :le…...
leetcode第20题（有效的括号）
思路解析（使用栈）： 使用一个栈来保存左括号。 每当遇到一个右括号时，检查栈顶元素是否是匹配的左括号。 如果匹配，则弹出栈顶元素； 如果不匹配或者栈为空，则说明无效； 最后如果栈…...
超简单的git学习教程
本博客仅用于记录学习和使用 前提声明全部内容全部来自下面廖雪峰网站，如果侵权联系我删除 0.前言 相信有不少人被推荐那个游戏学习git，一个不止我一个完全没学习过的进去后一脸懵，半天都通不过一关然后就放弃了，我个人觉得那个…...
【DVWA File Upload 漏洞实战指南】（Low / Medium / High 全级别解析）
前言 文件上传功能是 Web 应用中非常常见的一种功能，用于上传头像、文档、图片等文件。但如果验证不当，攻击者可能上传恶意脚本，进而控制服务器。在 DVWA 中，File Upload 模块专门设计用于演练此类漏洞的不同防御等级。 一、Low …...
iPhone 13P 换超容电池，一年实记的“电池循环次数-容量“柱状图
继上一篇 iPhone 13P 更换"移植电芯"和"超容电池"🔋体验，详细记录了如何更换这两种电池，以及各自的优略势对比。 一晃一年过去，时间真快，这次分享下记录了使用超容电池的 “循环次数 - 容量(mAh)…...
Django 使用教程
Django 使用教程 Django 是一个高级的 Python Web 框架，采用了 MTV（Model-Template-View）设计模式，旨在帮助开发者快速构建高效、可维护的 Web 应用。它有着非常丰富的功能，包括 ORM、用户认证、表单处理、管理后台等…...
【集群IP管理分配技术_DHCP】一、DHCP技术概念与快速上手
在网络技术飞速发展的今天，动态主机配置协议（DHCP）作为网络中自动分配 IP 地址及相关配置参数的重要工具，极大地简化了网络管理流程。然而，随着网络规模的不断扩大和应用场景的日益复杂，传统 DHCP 在灵活性…...
Tailwindcss 入门 v4.1
以 react 为例，步骤如下： npm create vitelatest my-app -- --template react 选择 React 和 JavaScript 根据上述命令的输出提示，运行以下命令 cd my-app npm install npm run dev 一个 React App 初始化完成。 安装 Tailwindcss theme …...
【Linux】NAT、代理服务、内网穿透
NAT、代理服务、内网穿透 一. NAT1. NAT 技术2. NAT IP 转换过程3. NAPT 技术4. NAT 技术的缺陷 二. 代理服务器1. 正向代理2. 反向代理3. NAT 和代理服务器 内网穿透内网打洞 一. NAT NAT（Network Address Translation，网络地址转换）技术&a…...
PCA——主成分分析数学原理及代码
主成分分析 PCA的目的是：对数据进行一个线性变换，在最大程度保留原始信息的前提下去除数据中彼此相关的信息。反映在变量上就是说，对所有的变量进行一个线性变换，使得变换后得到的变量彼此之间不相关，并且是所有可能的…...
AWS EC2完全指南：如何快速搭建高性能云服务器？
一、什么是AWS EC2？云时代的虚拟服务器革命 AWS Elastic Compute Cloud（EC2）作为全球领先的云服务器解决方案，正在重新定义虚拟服务器的可能性。与传统VPS相比，EC2提供： 秒级弹性扩展：CPU/RAM按…...
TLS/SSL 弱密码套件中危漏洞修复
TLS/SSL 弱密码套件漏洞是一种常见的安全问题，它可能导致加密通信被破解或降级攻击。修复此漏洞的关键是禁用不安全的密码套件，并配置服务器使用强密码套件。以下是修复步骤和详细说明： 1. 了解弱密码套件 弱密码套件通常包括以下类型&…...