暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / duplicate database快速在线克隆生产库作为测试库

duplicate database快速在线克隆生产库作为测试库

原创 jieguo 2023-05-17
256

生产库：192.168.10.35
测试库：192.168.10.36

需要快速搭建测试库，数据库版本一致12.2.0.1，目录结构一致，空间足够。
image.png

duplicate database to testdb from active database nofilenamecheck;
800多G的库，不到3小时完成。

25.1.1 Purpose of Database Duplication
A duplicate database is useful for a variety of purposes, most of which involve testing. You can perform the following tasks in a duplicate database:

Test backup and recovery procedures

For example, you can duplicate the production database on host1 to host2, and then use the duplicate database on host2 to practice restoring and recovering this database while the production database on host1 operates as usual.

Test an upgrade to a new release of Oracle Database

Test the effect of applications on database performance

Create a standby database

You can create a physical standby database or an Oracle Data Guard far sync instance. A standby database is a copy of the primary database that you update continually with archived redo log files from the primary database. If the primary database is inaccessible, then you can fail over to the standby database, which becomes the new primary database. A database copy, however, cannot be used in this way: it is not intended for failover scenarios and does not support the various standby recovery and failover options.

Generate reports

参看：https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-duplicating-databases.html#GUID-BBCD4E68-DC14-4D24-BE74-9BAE7684C6ED

测试库36上操作即可：

1.添加静态监听lisnter.ora：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = testdb)
      (ORACLE_HOME = /data1/oracle/product/12.2.0/db_1)
      (SID_NAME = testdb)
    )
  )

2.添加tnsnames.ora

testdb_36 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.36)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb)
    )
  )
testdb_35 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.35)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb)
    )
  )

3.检查生产和测试库的联通性

确认连接正常才行。

sqlplus sys/pwd@testdb_35 as sysdba
sqlplus sys/pwd@testdb_36 as sysdba

4.编辑脚本放后台恢复：

vi /home/oracle/r.sh

rman target sys/pwd@testdb_35 auxiliary sys/pwd@testdb_36<<EOF
run{
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
duplicate database to testdb from active database nofilenamecheck;
release channel aux1;
release channel aux2;
release channel ch1;
release channel ch2;
}
exit;
EOF

执行：
cd /home/oracle
nohup ./r.sh > ./r.log &
检查恢复日志:
tail -f r.log
有时候为了防止终端超时，可以使用：
watch -n 1 tail -10 r.log

5.监控资源消耗进度：

cpu资源消耗：
sar 1 10
io速度：
iostat 1 10 
网卡流量速度：
sar -n DEV 1
磁盘空间：
df -h

6.完整的恢复记录参看：

more r.log

Recovery Manager: Release 12.2.0.1.0 - Production on Wed May 17 12:04:53 2023

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: testdb (DBID=2262838366)
connected to auxiliary database: testdb (not mounted)

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=1735 device type=DISK

RMAN-06908: warning: operation will not run in parallel on the allocated channels
RMAN-06909: warning: parallelism require Enterprise Edition
allocated channel: ch2
channel ch2: SID=951 device type=DISK

allocated channel: aux1
channel aux1: SID=1890 device type=DISK

allocated channel: aux2
channel aux2: SID=3771 device type=DISK

Starting Duplicate Db at 17-MAY-23
current log archived

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''testdb'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''testdb'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone from service  'testdb_35' primary controlfile;
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''testdb'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''testdb'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area   25769803776 bytes

Fixed Size                     8635096 bytes
Variable Size               4697623848 bytes
Database Buffers           21005074432 bytes
Redo Buffers                  58470400 bytes
allocated channel: aux1
channel aux1: SID=2 device type=DISK
allocated channel: aux2
channel aux2: SID=3771 device type=DISK

Starting restore at 17-MAY-23

channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: restoring control file
channel aux1: restore complete, elapsed time: 00:00:01
output file name=/data1/oracle/oradata/testdb/control01.ctl
output file name=/data1/oracle/oradata/testdb/control02.ctl
Finished restore at 17-MAY-23

database mounted

contents of Memory Script:
{
   set newname for datafile  1 to 
 "/data1/oradata/testdb/SYSTEM01.DBF";
   set newname for datafile  3 to 
 "/data1/oradata/testdb/SYSAUX01.DBF";
   set newname for datafile  5 to 
 "/data1/oradata/testdb/UNDOTBS01.DBF";
   set newname for datafile  7 to 
 "/data1/oradata/testdb/USERS01.DBF";
   set newname for datafile  8 to 
 "/data1/oradata/testdb/ODSDATA01.DBF";
   set newname for datafile  9 to 
 "/data1/oradata/testdb/ODSDATA02.DBF";
   set newname for datafile  10 to 
 "/data1/oradata/testdb/ODSDATA03.DBF";
   set newname for datafile  11 to 
 "/data1/oradata/testdb/FLEXSCHE_DATA01.DBF";
   set newname for datafile  12 to 
 "/data1/oradata/testdb/WB_DISPATCHER01.DBF";
   set newname for datafile  13 to 
 "/data1/oradata/testdb/KETTLE_DATA01.DBF";
   set newname for datafile  14 to 
 "/data1/oradata/testdb/KETTLE_DATA02.DBF";
   set newname for datafile  15 to 
 "/data1/oradata/testdb/KETTLE_DATA03.DBF";
   set newname for datafile  16 to 
 "/data1/oradata/testdb/KETTLE_DATA04.DBF";
   set newname for datafile  17 to 
 "/data1/oradata/testdb/KETTLE_DATA05.DBF";
   set newname for datafile  18 to 
 "/data1/oradata/testdb/KETTLE_DATA06.DBF";
   set newname for datafile  19 to 
 "/data1/oradata/testdb/EISP_DATA01.DBF";
   set newname for datafile  20 to 
 "/data1/oradata/testdb/EISP_DATA02.DBF";
   set newname for datafile  21 to 
 "/data1/oradata/testdb/STORE_DATA01.DBF";
   set newname for datafile  22 to 
 "/data1/oradata/testdb/USERS02.DBF";
   set newname for datafile  23 to 
 "/data1/oradata/testdb/LLOT_DATA01.DBF";
   set newname for datafile  24 to 
 "/data1/oradata/testdb/KU_DATA01.DBF";
   set newname for datafile  25 to 
 "/data1/oradata/testdb/SPAS_DATA01.DBF";
   set newname for datafile  26 to 
 "/data1/oradata/testdb/USERS03.DBF";
   set newname for datafile  27 to 
 "/data1/oradata/testdb/USERS04.DBF";
   set newname for datafile  28 to 
 "/data1/oradata/testdb/TJP_DATA01.DBF";
   set newname for datafile  29 to 
 "/data1/oradata/testdb/SPAS_DATA02.DBF";
   set newname for datafile  30 to 
 "/data1/oradata/testdb/KETTLE_DATA07.DBF";
   set newname for datafile  31 to 
 "/data1/oradata/testdb/WB_DISPATCHER02.DBF";
   set newname for datafile  32 to 
 "/data1/oradata/testdb/KETTLE_DATA08.DBF";
   set newname for datafile  33 to 
 "/data1/oradata/testdb/KETTLE_DATA09.DBF";
   set newname for datafile  34 to 
 "/data1/oradata/testdb/ODSDATA04.DBF";
   set newname for datafile  35 to 
 "/data1/oradata/testdb/WB_DISPATCHER03.DBF";
   set newname for datafile  36 to 
 "/data1/oradata/testdb/KETTLE_DATA10.DBF";
   set newname for datafile  37 to 
 "/data1/oradata/testdb/KETTLE_DATA11.DBF";
   set newname for datafile  38 to 
 "/data1/oradata/testdb/KETTLE_DATA12.DBF";
   set newname for datafile  39 to 
 "/data1/oradata/testdb/ODSDATA05.DBF";
   set newname for datafile  40 to 
 "/data1/oradata/testdb/KETTLE_DATA13.DBF";
   restore
   from  nonsparse   from service 
 'testdb_35'   clone database
   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 17-MAY-23

channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00001 to /data1/oradata/testdb/SYSTEM01.DBF
channel aux1: restore complete, elapsed time: 00:00:45
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00003 to /data1/oradata/testdb/SYSAUX01.DBF
channel aux1: restore complete, elapsed time: 00:01:45
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00005 to /data1/oradata/testdb/UNDOTBS01.DBF
channel aux1: restore complete, elapsed time: 00:04:05
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00007 to /data1/oradata/testdb/USERS01.DBF
channel aux1: restore complete, elapsed time: 00:05:05
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00008 to /data1/oradata/testdb/ODSDATA01.DBF
channel aux1: restore complete, elapsed time: 00:04:35
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00009 to /data1/oradata/testdb/ODSDATA02.DBF
channel aux1: restore complete, elapsed time: 00:04:35
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00010 to /data1/oradata/testdb/ODSDATA03.DBF
channel aux1: restore complete, elapsed time: 00:04:35
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00011 to /data1/oradata/testdb/FLEXSCHE_DATA01.DBF
channel aux1: restore complete, elapsed time: 00:04:15
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00012 to /data1/oradata/testdb/WB_DISPATCHER01.DBF
channel aux1: restore complete, elapsed time: 00:02:35
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00013 to /data1/oradata/testdb/KETTLE_DATA01.DBF
channel aux1: restore complete, elapsed time: 00:05:05
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00014 to /data1/oradata/testdb/KETTLE_DATA02.DBF
channel aux1: restore complete, elapsed time: 00:05:05
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00015 to /data1/oradata/testdb/KETTLE_DATA03.DBF
channel aux1: restore complete, elapsed time: 00:05:06
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00016 to /data1/oradata/testdb/KETTLE_DATA04.DBF
channel aux1: restore complete, elapsed time: 00:05:05
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00017 to /data1/oradata/testdb/KETTLE_DATA05.DBF
channel aux1: restore complete, elapsed time: 00:05:05
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00018 to /data1/oradata/testdb/KETTLE_DATA06.DBF
channel aux1: restore complete, elapsed time: 00:05:05
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00019 to /data1/oradata/testdb/EISP_DATA01.DBF
channel aux1: restore complete, elapsed time: 00:04:25
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00020 to /data1/oradata/testdb/EISP_DATA02.DBF
channel aux1: restore complete, elapsed time: 00:04:15
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00021 to /data1/oradata/testdb/STORE_DATA01.DBF
channel aux1: restore complete, elapsed time: 00:01:35
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00022 to /data1/oradata/testdb/USERS02.DBF
channel aux1: restore complete, elapsed time: 00:03:45
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00023 to /data1/oradata/testdb/LLOT_DATA01.DBF
channel aux1: restore complete, elapsed time: 00:00:07
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35

channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00038 to /data1/oradata/testdb/KETTLE_DATA12.DBF
channel aux1: restore complete, elapsed time: 00:04:15
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00039 to /data1/oradata/testdb/ODSDATA05.DBF
channel aux1: restore complete, elapsed time: 00:02:15
channel aux1: starting datafile backup set restore
channel aux1: using network backup set from service testdb_35
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00040 to /data1/oradata/testdb/KETTLE_DATA13.DBF
channel aux1: restore complete, elapsed time: 00:04:25
Finished restore at 17-MAY-23

sql statement: alter system archive log current
current log archived

contents of Memory Script:
{
   restore clone force from service  'testdb_35' 
           archivelog from scn  12047103515113;
   switch clone datafile all;
}
executing Memory Script

Starting restore at 17-MAY-23

channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54935
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54936
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54937
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54938
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54939
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54940
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54941
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54942
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=54943
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination

channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=55019
channel aux1: restore complete, elapsed time: 00:00:15
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=55020
channel aux1: restore complete, elapsed time: 00:00:03
channel aux1: starting archived log restore to default destination
channel aux1: using network backup set from service testdb_35
channel aux1: restoring archived log
archived log thread=1 sequence=55021
channel aux1: restore complete, elapsed time: 00:00:01
Finished restore at 17-MAY-23

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1137075488 file name=/data1/oradata/testdb/SYSTEM01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1137075489 file name=/data1/oradata/testdb/SYSAUX01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=3 STAMP=1137075489 file name=/data1/oradata/testdb/UNDOTBS01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1137075489 file name=/data1/oradata/testdb/USERS01.DBF
datafile 8 switched to datafile copy
input datafile copy RECID=5 STAMP=1137075489 file name=/data1/oradata/testdb/ODSDATA01.DBF
datafile 9 switched to datafile copy
input datafile copy RECID=6 STAMP=1137075489 file name=/data1/oradata/testdb/ODSDATA02.DBF
datafile 10 switched to datafile copy
input datafile copy RECID=7 STAMP=1137075489 file name=/data1/oradata/testdb/ODSDATA03.DBF
datafile 11 switched to datafile copy
input datafile copy RECID=8 STAMP=1137075489 file name=/data1/oradata/testdb/FLEXSCHE_DATA01.DBF
datafile 12 switched to datafile copy
input datafile copy RECID=9 STAMP=1137075489 file name=/data1/oradata/testdb/WB_DISPATCHER01.DBF
datafile 13 switched to datafile copy
input datafile copy RECID=10 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA01.DBF
datafile 14 switched to datafile copy
input datafile copy RECID=11 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA02.DBF
datafile 15 switched to datafile copy
input datafile copy RECID=12 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA03.DBF
datafile 16 switched to datafile copy
input datafile copy RECID=13 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA04.DBF
datafile 17 switched to datafile copy
input datafile copy RECID=14 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA05.DBF
datafile 18 switched to datafile copy
input datafile copy RECID=15 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA06.DBF
datafile 19 switched to datafile copy
input datafile copy RECID=16 STAMP=1137075489 file name=/data1/oradata/testdb/EISP_DATA01.DBF
datafile 20 switched to datafile copy
input datafile copy RECID=17 STAMP=1137075489 file name=/data1/oradata/testdb/EISP_DATA02.DBF
datafile 21 switched to datafile copy
input datafile copy RECID=18 STAMP=1137075489 file name=/data1/oradata/testdb/STORE_DATA01.DBF
datafile 22 switched to datafile copy
input datafile copy RECID=19 STAMP=1137075489 file name=/data1/oradata/testdb/USERS02.DBF
datafile 23 switched to datafile copy
input datafile copy RECID=20 STAMP=1137075489 file name=/data1/oradata/testdb/LLOT_DATA01.DBF
datafile 24 switched to datafile copy
input datafile copy RECID=21 STAMP=1137075489 file name=/data1/oradata/testdb/KU_DATA01.DBF
datafile 25 switched to datafile copy
input datafile copy RECID=22 STAMP=1137075489 file name=/data1/oradata/testdb/SPAS_DATA01.DBF
datafile 26 switched to datafile copy
input datafile copy RECID=23 STAMP=1137075489 file name=/data1/oradata/testdb/USERS03.DBF
datafile 27 switched to datafile copy
input datafile copy RECID=24 STAMP=1137075489 file name=/data1/oradata/testdb/USERS04.DBF
datafile 28 switched to datafile copy
input datafile copy RECID=25 STAMP=1137075489 file name=/data1/oradata/testdb/TJP_DATA01.DBF
datafile 29 switched to datafile copy
input datafile copy RECID=26 STAMP=1137075489 file name=/data1/oradata/testdb/SPAS_DATA02.DBF
datafile 30 switched to datafile copy
input datafile copy RECID=27 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA07.DBF
datafile 31 switched to datafile copy
input datafile copy RECID=28 STAMP=1137075489 file name=/data1/oradata/testdb/WB_DISPATCHER02.DBF
datafile 32 switched to datafile copy
input datafile copy RECID=29 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA08.DBF
datafile 33 switched to datafile copy
input datafile copy RECID=30 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA09.DBF
datafile 34 switched to datafile copy
input datafile copy RECID=31 STAMP=1137075489 file name=/data1/oradata/testdb/ODSDATA04.DBF
datafile 35 switched to datafile copy
input datafile copy RECID=32 STAMP=1137075489 file name=/data1/oradata/testdb/WB_DISPATCHER03.DBF
datafile 36 switched to datafile copy
input datafile copy RECID=33 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA10.DBF
datafile 37 switched to datafile copy
input datafile copy RECID=34 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA11.DBF
datafile 38 switched to datafile copy
input datafile copy RECID=35 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA12.DBF
datafile 39 switched to datafile copy
input datafile copy RECID=36 STAMP=1137075489 file name=/data1/oradata/testdb/ODSDATA05.DBF
datafile 40 switched to datafile copy
input datafile copy RECID=37 STAMP=1137075489 file name=/data1/oradata/testdb/KETTLE_DATA13.DBF


contents of Memory Script:
{
   set until scn  12047105417348;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 17-MAY-23

starting media recovery

archived log for thread 1 with sequence 54935 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54935_1126704793.dbf
archived log for thread 1 with sequence 54936 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54936_1126704793.dbf
archived log for thread 1 with sequence 54937 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54937_1126704793.dbf
archived log for thread 1 with sequence 54938 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54938_1126704793.dbf
archived log for thread 1 with sequence 54939 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54939_1126704793.dbf
archived log for thread 1 with sequence 54940 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54940_1126704793.dbf
archived log for thread 1 with sequence 54941 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54941_1126704793.dbf
archived log for thread 1 with sequence 54942 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54942_1126704793.dbf
archived log for thread 1 with sequence 54943 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54943_1126704793.dbf
archived log for thread 1 with sequence 54944 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54944_1126704793.dbf
archived log for thread 1 with sequence 54945 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54945_1126704793.dbf
archived log for thread 1 with sequence 54946 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54946_1126704793.dbf
archived log for thread 1 with sequence 54947 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54947_1126704793.dbf
archived log for thread 1 with sequence 54948 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54948_1126704793.dbf
archived log for thread 1 with sequence 54949 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54949_1126704793.dbf
archived log for thread 1 with sequence 54950 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54950_1126704793.dbf
archived log for thread 1 with sequence 54951 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54951_1126704793.dbf
archived log for thread 1 with sequence 54952 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54952_1126704793.dbf
archived log for thread 1 with sequence 54953 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54953_1126704793.dbf
archived log for thread 1 with sequence 54954 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54954_1126704793.dbf
archived log for thread 1 with sequence 54955 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54955_1126704793.dbf
archived log for thread 1 with sequence 54956 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54956_1126704793.dbf
archived log for thread 1 with sequence 54957 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54957_1126704793.dbf
archived log for thread 1 with sequence 54958 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54958_1126704793.dbf
archived log for thread 1 with sequence 54959 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54959_1126704793.dbf
archived log for thread 1 with sequence 54960 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54960_1126704793.dbf
archived log for thread 1 with sequence 54961 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54961_1126704793.dbf
archived log for thread 1 with sequence 54962 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54962_1126704793.dbf
archived log for thread 1 with sequence 54963 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54963_1126704793.dbf
archived log for thread 1 with sequence 54964 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54964_1126704793.dbf
archived log for thread 1 with sequence 54965 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54965_1126704793.dbf
archived log for thread 1 with sequence 54966 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54966_1126704793.dbf
archived log for thread 1 with sequence 54967 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54967_1126704793.dbf
archived log for thread 1 with sequence 54968 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54968_1126704793.dbf
archived log for thread 1 with sequence 54969 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54969_1126704793.dbf
archived log for thread 1 with sequence 54970 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54970_1126704793.dbf
archived log for thread 1 with sequence 54971 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54971_1126704793.dbf
archived log for thread 1 with sequence 54972 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54972_1126704793.dbf
archived log for thread 1 with sequence 54973 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54973_1126704793.dbf
archived log for thread 1 with sequence 54974 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54974_1126704793.dbf
archived log for thread 1 with sequence 54975 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54975_1126704793.dbf
archived log for thread 1 with sequence 54976 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54976_1126704793.dbf
archived log for thread 1 with sequence 54977 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54977_1126704793.dbf
archived log for thread 1 with sequence 54978 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54978_1126704793.dbf
archived log for thread 1 with sequence 54979 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54979_1126704793.dbf
archived log for thread 1 with sequence 54980 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54980_1126704793.dbf
archived log for thread 1 with sequence 54981 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54981_1126704793.dbf
archived log for thread 1 with sequence 54982 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54982_1126704793.dbf
archived log for thread 1 with sequence 54983 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54983_1126704793.dbf
archived log for thread 1 with sequence 54984 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54984_1126704793.dbf
archived log for thread 1 with sequence 54985 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54985_1126704793.dbf
archived log for thread 1 with sequence 54986 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54986_1126704793.dbf
archived log for thread 1 with sequence 54987 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54987_1126704793.dbf
archived log for thread 1 with sequence 54988 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54988_1126704793.dbf
archived log for thread 1 with sequence 54989 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54989_1126704793.dbf
archived log for thread 1 with sequence 54990 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54990_1126704793.dbf
archived log for thread 1 with sequence 54991 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54991_1126704793.dbf
archived log for thread 1 with sequence 54992 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54992_1126704793.dbf
archived log for thread 1 with sequence 54993 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54993_1126704793.dbf
archived log for thread 1 with sequence 54994 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54994_1126704793.dbf
archived log for thread 1 with sequence 54995 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54995_1126704793.dbf
archived log for thread 1 with sequence 54996 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54996_1126704793.dbf
archived log for thread 1 with sequence 54997 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54997_1126704793.dbf
archived log for thread 1 with sequence 54998 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54998_1126704793.dbf
archived log for thread 1 with sequence 54999 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_54999_1126704793.dbf
archived log for thread 1 with sequence 55000 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55000_1126704793.dbf
archived log for thread 1 with sequence 55001 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55001_1126704793.dbf
archived log for thread 1 with sequence 55002 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55002_1126704793.dbf
archived log for thread 1 with sequence 55003 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55003_1126704793.dbf
archived log for thread 1 with sequence 55004 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55004_1126704793.dbf
archived log for thread 1 with sequence 55005 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55005_1126704793.dbf
archived log for thread 1 with sequence 55006 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55006_1126704793.dbf
archived log for thread 1 with sequence 55007 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55007_1126704793.dbf
archived log for thread 1 with sequence 55008 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55008_1126704793.dbf
archived log for thread 1 with sequence 55009 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55009_1126704793.dbf
archived log for thread 1 with sequence 55010 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55010_1126704793.dbf
archived log for thread 1 with sequence 55011 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55011_1126704793.dbf
archived log for thread 1 with sequence 55012 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55012_1126704793.dbf
archived log for thread 1 with sequence 55013 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55013_1126704793.dbf
archived log for thread 1 with sequence 55014 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55014_1126704793.dbf
archived log for thread 1 with sequence 55015 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55015_1126704793.dbf
archived log for thread 1 with sequence 55016 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55016_1126704793.dbf
archived log for thread 1 with sequence 55017 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55017_1126704793.dbf
archived log for thread 1 with sequence 55018 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55018_1126704793.dbf
archived log for thread 1 with sequence 55019 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55019_1126704793.dbf
archived log for thread 1 with sequence 55020 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55020_1126704793.dbf
archived log for thread 1 with sequence 55021 is already on disk as file /data1/oracle/product/12.2.0/db_1/dbs/arch1_55021_1126704793.dbf
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54935_1126704793.dbf thread=1 sequence=54935
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54936_1126704793.dbf thread=1 sequence=54936
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54937_1126704793.dbf thread=1 sequence=54937
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54938_1126704793.dbf thread=1 sequence=54938
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54939_1126704793.dbf thread=1 sequence=54939
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54940_1126704793.dbf thread=1 sequence=54940
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54941_1126704793.dbf thread=1 sequence=54941
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54942_1126704793.dbf thread=1 sequence=54942
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54943_1126704793.dbf thread=1 sequence=54943
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54944_1126704793.dbf thread=1 sequence=54944
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54945_1126704793.dbf thread=1 sequence=54945
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54946_1126704793.dbf thread=1 sequence=54946
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54947_1126704793.dbf thread=1 sequence=54947
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54948_1126704793.dbf thread=1 sequence=54948
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54949_1126704793.dbf thread=1 sequence=54949
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54950_1126704793.dbf thread=1 sequence=54950
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54951_1126704793.dbf thread=1 sequence=54951
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54952_1126704793.dbf thread=1 sequence=54952
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54953_1126704793.dbf thread=1 sequence=54953
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54954_1126704793.dbf thread=1 sequence=54954
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54955_1126704793.dbf thread=1 sequence=54955
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54956_1126704793.dbf thread=1 sequence=54956
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54957_1126704793.dbf thread=1 sequence=54957
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54958_1126704793.dbf thread=1 sequence=54958
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54959_1126704793.dbf thread=1 sequence=54959
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54960_1126704793.dbf thread=1 sequence=54960
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54961_1126704793.dbf thread=1 sequence=54961
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54962_1126704793.dbf thread=1 sequence=54962
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54963_1126704793.dbf thread=1 sequence=54963
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54964_1126704793.dbf thread=1 sequence=54964
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54965_1126704793.dbf thread=1 sequence=54965
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54966_1126704793.dbf thread=1 sequence=54966
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54967_1126704793.dbf thread=1 sequence=54967
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54968_1126704793.dbf thread=1 sequence=54968
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54969_1126704793.dbf thread=1 sequence=54969
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54970_1126704793.dbf thread=1 sequence=54970
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54971_1126704793.dbf thread=1 sequence=54971
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54972_1126704793.dbf thread=1 sequence=54972
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54973_1126704793.dbf thread=1 sequence=54973
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54974_1126704793.dbf thread=1 sequence=54974
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54975_1126704793.dbf thread=1 sequence=54975
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54976_1126704793.dbf thread=1 sequence=54976
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54977_1126704793.dbf thread=1 sequence=54977
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54978_1126704793.dbf thread=1 sequence=54978
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54979_1126704793.dbf thread=1 sequence=54979
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54980_1126704793.dbf thread=1 sequence=54980
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54981_1126704793.dbf thread=1 sequence=54981
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54982_1126704793.dbf thread=1 sequence=54982
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54983_1126704793.dbf thread=1 sequence=54983
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54984_1126704793.dbf thread=1 sequence=54984
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54985_1126704793.dbf thread=1 sequence=54985
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54986_1126704793.dbf thread=1 sequence=54986
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54987_1126704793.dbf thread=1 sequence=54987
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54988_1126704793.dbf thread=1 sequence=54988
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54989_1126704793.dbf thread=1 sequence=54989
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_54990_1126704793.dbf thread=1 sequence=54990
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_55016_1126704793.dbf thread=1 sequence=55016
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_55017_1126704793.dbf thread=1 sequence=55017
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_55018_1126704793.dbf thread=1 sequence=55018
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_55019_1126704793.dbf thread=1 sequence=55019
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_55020_1126704793.dbf thread=1 sequence=55020
archived log file name=/data1/oracle/product/12.2.0/db_1/dbs/arch1_55021_1126704793.dbf thread=1 sequence=55021
media recovery complete, elapsed time: 00:16:46
Finished recover at 17-MAY-23
released channel: ch1
released channel: ch2
released channel: aux1
released channel: aux2
Oracle instance started

Total System Global Area   25769803776 bytes

Fixed Size                     8635096 bytes
Variable Size               4697623848 bytes
Database Buffers           21005074432 bytes
Redo Buffers                  58470400 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''testdb'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
}
executing Memory Script

sql statement: alter system set  db_name =  ''testdb'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile
Oracle instance started

Total System Global Area   25769803776 bytes

Fixed Size                     8635096 bytes
Variable Size               4697623848 bytes
Database Buffers           21005074432 bytes
Redo Buffers                  58470400 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "testdb" RESETLOGS ARCHIVELOG 
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY     4674
 LOGFILE
  GROUP   1 ( '/data1/oradata/testdb/REDO01.LOG' ) SIZE 1 G  REUSE,
  GROUP   2 ( '/data1/oradata/testdb/REDO02.LOG' ) SIZE 1 G  REUSE,
  GROUP   3 ( '/data1/oradata/testdb/REDO03.LOG' ) SIZE 1 G  REUSE,
  GROUP   4 ( '/data1/oradata/testdb/REDO04.LOG' ) SIZE 1 G  REUSE,
  GROUP   5 ( '/data1/oradata/testdb/REDO05.LOG' ) SIZE 1 G  REUSE,
  GROUP   6 ( '/data1/oradata/testdb/REDO06.LOG' ) SIZE 1 G  REUSE,
  GROUP   7 ( '/data1/oradata/testdb/REDO07.LOG' ) SIZE 1 G  REUSE,
  GROUP   8 ( '/data1/oradata/testdb/REDO08.LOG' ) SIZE 1 G  REUSE,
  GROUP   9 ( '/data1/oradata/testdb/REDO09.LOG' ) SIZE 1 G  REUSE
 DATAFILE
  '/data1/oradata/testdb/SYSTEM01.DBF'
 CHARACTER SET AL32UTF8


contents of Memory Script:
{
   set newname for tempfile  1 to 
 "/data1/oradata/testdb/TEMP01.DBF";
   set newname for tempfile  2 to 
 "/data1/oradata/testdb/ODSDATA_TEMP01.DBF";
   set newname for tempfile  3 to 
 "/data1/oradata/testdb/FLEXSCHE_TEMP01.DBF";
   set newname for tempfile  4 to 
 "/data1/oradata/testdb/WB_DISPATCHER_TEMP01.DBF";
   set newname for tempfile  5 to 
 "/data1/oradata/testdb/KETTLE_TEMPP01.DBF";
   set newname for tempfile  6 to 
 "/data1/oradata/testdb/STORE_TEMP01.DBF";
   set newname for tempfile  7 to 
 "/data1/oradata/testdb/LLOT_TEMP01.DBF";
   set newname for tempfile  8 to 
 "/data1/oradata/testdb/KU_TEMP01.DBF";
   set newname for tempfile  9 to 
 "/data1/oradata/testdb/SPAS_TEMP01.DBF";
   set newname for tempfile  10 to 
 "/data1/oradata/testdb/TJP_TEMP01.DBF";
   switch clone tempfile all;
   catalog clone datafilecopy  "/data1/oradata/testdb/SYSAUX01.DBF", 
 "/data1/oradata/testdb/UNDOTBS01.DBF", 
 "/data1/oradata/testdb/USERS01.DBF", 
 "/data1/oradata/testdb/ODSDATA01.DBF", 
 "/data1/oradata/testdb/ODSDATA02.DBF", 
 "/data1/oradata/testdb/ODSDATA03.DBF", 
 "/data1/oradata/testdb/FLEXSCHE_DATA01.DBF", 
 "/data1/oradata/testdb/WB_DISPATCHER01.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA01.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA02.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA03.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA04.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA05.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA06.DBF", 
 "/data1/oradata/testdb/EISP_DATA01.DBF", 
 "/data1/oradata/testdb/EISP_DATA02.DBF", 
 "/data1/oradata/testdb/STORE_DATA01.DBF", 
 "/data1/oradata/testdb/USERS02.DBF", 
 "/data1/oradata/testdb/LLOT_DATA01.DBF", 
 "/data1/oradata/testdb/KU_DATA01.DBF", 
 "/data1/oradata/testdb/SPAS_DATA01.DBF", 
 "/data1/oradata/testdb/USERS03.DBF", 
 "/data1/oradata/testdb/USERS04.DBF", 
 "/data1/oradata/testdb/TJP_DATA01.DBF", 
 "/data1/oradata/testdb/SPAS_DATA02.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA07.DBF", 
 "/data1/oradata/testdb/WB_DISPATCHER02.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA08.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA09.DBF", 
 "/data1/oradata/testdb/ODSDATA04.DBF", 
 "/data1/oradata/testdb/WB_DISPATCHER03.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA10.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA11.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA12.DBF", 
 "/data1/oradata/testdb/ODSDATA05.DBF", 
 "/data1/oradata/testdb/KETTLE_DATA13.DBF";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /data1/oradata/testdb/TEMP01.DBF in control file
renamed tempfile 2 to /data1/oradata/testdb/ODSDATA_TEMP01.DBF in control file
renamed tempfile 3 to /data1/oradata/testdb/FLEXSCHE_TEMP01.DBF in control file
renamed tempfile 4 to /data1/oradata/testdb/WB_DISPATCHER_TEMP01.DBF in control file
renamed tempfile 5 to /data1/oradata/testdb/KETTLE_TEMPP01.DBF in control file
renamed tempfile 6 to /data1/oradata/testdb/STORE_TEMP01.DBF in control file
renamed tempfile 7 to /data1/oradata/testdb/LLOT_TEMP01.DBF in control file
renamed tempfile 8 to /data1/oradata/testdb/KU_TEMP01.DBF in control file
renamed tempfile 9 to /data1/oradata/testdb/SPAS_TEMP01.DBF in control file
renamed tempfile 10 to /data1/oradata/testdb/TJP_TEMP01.DBF in control file

cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/SYSAUX01.DBF RECID=1 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/UNDOTBS01.DBF RECID=2 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/USERS01.DBF RECID=3 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/ODSDATA01.DBF RECID=4 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/ODSDATA02.DBF RECID=5 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/USERS04.DBF RECID=23 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/TJP_DATA01.DBF RECID=24 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/SPAS_DATA02.DBF RECID=25 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/KETTLE_DATA07.DBF RECID=26 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/WB_DISPATCHER02.DBF RECID=27 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/KETTLE_DATA08.DBF RECID=28 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/KETTLE_DATA09.DBF RECID=29 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/ODSDATA04.DBF RECID=30 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/WB_DISPATCHER03.DBF RECID=31 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/KETTLE_DATA10.DBF RECID=32 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/KETTLE_DATA11.DBF RECID=33 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/KETTLE_DATA12.DBF RECID=34 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/ODSDATA05.DBF RECID=35 STAMP=1137076514
cataloged datafile copy
datafile copy file name=/data1/oradata/testdb/KETTLE_DATA13.DBF RECID=36 STAMP=1137076514

datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1137076514 file name=/data1/oradata/testdb/SYSAUX01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=2 STAMP=1137076514 file name=/data1/oradata/testdb/UNDOTBS01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=3 STAMP=1137076514 file name=/data1/oradata/testdb/USERS01.DBF
datafile 8 switched to datafile copy
input datafile copy RECID=4 STAMP=1137076514 file name=/data1/oradata/testdb/ODSDATA01.DBF
datafile 9 switched to datafile copy
input datafile copy RECID=5 STAMP=1137076514 file name=/data1/oradata/testdb/ODSDATA02.DBF
datafile 10 switched to datafile copy
input datafile copy RECID=6 STAMP=1137076514 file name=/data1/oradata/testdb/ODSDATA03.DBF
datafile 11 switched to datafile copy
input datafile copy RECID=7 STAMP=1137076514 file name=/data1/oradata/testdb/FLEXSCHE_DATA01.DBF
datafile 12 switched to datafile copy
input datafile copy RECID=8 STAMP=1137076514 file name=/data1/oradata/testdb/WB_DISPATCHER01.DBF
datafile 13 switched to datafile copy
input datafile copy RECID=9 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA01.DBF
datafile 14 switched to datafile copy
input datafile copy RECID=10 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA02.DBF
datafile 15 switched to datafile copy
input datafile copy RECID=11 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA03.DBF
datafile 16 switched to datafile copy
input datafile copy RECID=12 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA04.DBF
datafile 17 switched to datafile copy
input datafile copy RECID=13 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA05.DBF
datafile 18 switched to datafile copy
input datafile copy RECID=14 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA06.DBF
datafile 19 switched to datafile copy
input datafile copy RECID=15 STAMP=1137076514 file name=/data1/oradata/testdb/EISP_DATA01.DBF
datafile 20 switched to datafile copy
input datafile copy RECID=16 STAMP=1137076514 file name=/data1/oradata/testdb/EISP_DATA02.DBF
datafile 21 switched to datafile copy
input datafile copy RECID=17 STAMP=1137076514 file name=/data1/oradata/testdb/STORE_DATA01.DBF
datafile 22 switched to datafile copy
input datafile copy RECID=18 STAMP=1137076514 file name=/data1/oradata/testdb/USERS02.DBF
datafile 23 switched to datafile copy
input datafile copy RECID=19 STAMP=1137076514 file name=/data1/oradata/testdb/LLOT_DATA01.DBF
datafile 24 switched to datafile copy
input datafile copy RECID=20 STAMP=1137076514 file name=/data1/oradata/testdb/KU_DATA01.DBF
datafile 25 switched to datafile copy
input datafile copy RECID=21 STAMP=1137076514 file name=/data1/oradata/testdb/SPAS_DATA01.DBF
datafile 26 switched to datafile copy
input datafile copy RECID=22 STAMP=1137076514 file name=/data1/oradata/testdb/USERS03.DBF
datafile 27 switched to datafile copy
input datafile copy RECID=23 STAMP=1137076514 file name=/data1/oradata/testdb/USERS04.DBF
datafile 28 switched to datafile copy
input datafile copy RECID=24 STAMP=1137076514 file name=/data1/oradata/testdb/TJP_DATA01.DBF
datafile 29 switched to datafile copy
input datafile copy RECID=25 STAMP=1137076514 file name=/data1/oradata/testdb/SPAS_DATA02.DBF
datafile 30 switched to datafile copy
input datafile copy RECID=26 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA07.DBF
datafile 31 switched to datafile copy
input datafile copy RECID=27 STAMP=1137076514 file name=/data1/oradata/testdb/WB_DISPATCHER02.DBF
datafile 32 switched to datafile copy
input datafile copy RECID=28 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA08.DBF
datafile 33 switched to datafile copy
input datafile copy RECID=29 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA09.DBF
datafile 34 switched to datafile copy
input datafile copy RECID=30 STAMP=1137076514 file name=/data1/oradata/testdb/ODSDATA04.DBF
datafile 35 switched to datafile copy
input datafile copy RECID=31 STAMP=1137076514 file name=/data1/oradata/testdb/WB_DISPATCHER03.DBF
datafile 36 switched to datafile copy
input datafile copy RECID=32 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA10.DBF
datafile 37 switched to datafile copy
input datafile copy RECID=33 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA11.DBF
datafile 38 switched to datafile copy
input datafile copy RECID=34 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA12.DBF
datafile 39 switched to datafile copy
input datafile copy RECID=35 STAMP=1137076514 file name=/data1/oradata/testdb/ODSDATA05.DBF
datafile 40 switched to datafile copy
input datafile copy RECID=36 STAMP=1137076514 file name=/data1/oradata/testdb/KETTLE_DATA13.DBF

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 17-MAY-23

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 05/17/2023 14:36:14
RMAN-06012: channel: aux1 not allocated

RMAN> 

Recovery Manager complete.

7.测试环境一般关闭归档模式，避免空间占用：

[oracle@testdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed May 17 14:41:27 2023

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /data1/oracle/product/12.2.0/db_1/dbs/arch
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           1
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 2.5770E+10 bytes
Fixed Size                  8635096 bytes
Variable Size            4697623848 bytes
Database Buffers         2.1005E+10 bytes
Redo Buffers               58470400 bytes
Database mounted.
SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2.5770E+10 bytes
Fixed Size                  8635096 bytes
Variable Size            4697623848 bytes
Database Buffers         2.1005E+10 bytes
Redo Buffers               58470400 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /data1/oracle/product/12.2.0/db_1/dbs/arch
Oldest online log sequence     1
Current log sequence           1
墨力计划oracle 12c
最后修改时间：2023-05-17 15:59:53
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论