背景：oracle rac11g一套下面我们来进行完整的RAC to Single Instance的Active Database Duplicate操作。 以rac节点1来举例，已配置静态监听。
[oracle@rac1:/home/oracle]$cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #public ip ent1 10.8.98.103 rac1 10.8.98.104 rac2 #priv ip ent2 192.168.1.103 rac1-priv 192.168.1.104 rac2-priv #vip ip 10.8.98.105 rac1-vip 10.8.98.106 rac2-vip #scan ip 10.8.98.107 cluster-scan #dg 10.8.98.102 racdg [oracle@rac1:/home/oracle]$ 单机测试duplicate是 10.8.98.150
[grid@rac1:/home/grid]$lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 26-JAN-2022 15:07:07 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 26-JAN-2022 14:21:23 Uptime 0 days 0 hr. 45 min. 43 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.8.98.103)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.8.98.105)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "prod" has 2 instance(s). Instance "prod1", status UNKNOWN, has 1 handler(s) for this service... Instance "prod1", status READY, has 1 handler(s) for this service... Service "prodXDB" has 1 instance(s). Instance "prod1", status READY, has 1 handler(s) for this service... The command completed successfully [grid@rac1:/home/grid]$cat /u01/app/11.2.0/grid/network/admin/listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = prod) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) (SID_NAME = prod1)) ) LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent [grid@rac1:/home/grid]$
[oracle@rac1:/u01/app/oracle/product/11.2.0/db_1/network/admin]$cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. PROD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cluster-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prod) ) ) tns_primary = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.105)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prod) ) ) tns_150 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.150)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prod) ) )
现在需要duplicate 到一个单节点 单节点配置如下单节点服务器只安装了数据库，起了监听， 没有dbca建库 1、 备库修改为静态监听，并配置tnsnames.ora
[oracle@dbserver admin]$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = prod) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = prod)) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = /u01/app/oracle [oracle@dbserver admin]$ cat tnsnames.ora tns_103 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.103)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prod) ) ) tns_150 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.150)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prod) ) ) tns_primary = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.105)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prod) ) ) [oracle@dbserver admin]$
2、备库创建 参数文件和密码文件
[oracle@dbserver dbs]$ cat initprod.ora prod.__db_cache_size=2868903936 prod.__java_pool_size=16777216 prod.__large_pool_size=33554432 prod.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment prod.__pga_aggregate_target=2415919104 prod.__sga_target=3623878656 prod.__shared_io_pool_size=0 prod.__shared_pool_size=654311424 prod.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/prod/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/u01/app/oracle/oradata/prod/control01.ctl','/u01/app/oracle/oradata/prod/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='prod' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)' *.memory_target=3030360576 *.open_cursors=300 *.processes=500 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=555 *.undo_tablespace='UNDOTBS1' *.db_file_name_convert='+DATADG01/','/u01/app/oracle/oradata/','+DATADG02/','/u01/app/oracle/oradata/' *.log_file_name_convert='+DATADG01/','/u01/app/oracle/oradata/','+DATADG02/','/u01/app/oracle/oradata/' [oracle@dbserver dbs]$ [oracle@dbserver dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwprod password=oracle entries=10 [oracle@dbserver dbs]$ ls hc_prod.dat initprod.ora lkPROD orapwprod
并在备库上创建相应的目录
[oracle@dbserver dbs]$ mkdir -p /u01/app/oracle/admin/prod/adump [oracle@dbserver dbs]$ mkdir -p /u01/app/oracle/oradata/prod/
*.db_file_name_convert='+DATADG01/','/u01/app/oracle/oradata/','+DATADG02/','/u01/app/oracle/oradata/' *.log_file_name_convert='+DATADG01/','/u01/app/oracle/oradata/','+DATADG02/','/u01/app/oracle/oradata/'rac和单机路径不一样，我配置了自动转化。 3、备库启动到nomount状态创建spfile，再关闭实例，重新通过spfile启动到nomount状态
[oracle@dbserver dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 26 15:47:44 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Total System Global Area 3023110144 bytes Fixed Size 2257072 bytes Variable Size 1845497680 bytes Database Buffers 1157627904 bytes Redo Buffers 17727488 bytes SQL> create spfile from pfile; File created. SQL> shutdown abort; ORACLE instance shut down. SQL> startup nomount; ORACLE instance started. Total System Global Area 3023110144 bytes Fixed Size 2257072 bytes Variable Size 1845497680 bytes Database Buffers 1157627904 bytes Redo Buffers 17727488 bytes SQL>
4、重启监听，并在rac1 和 单实例节点tnsping测试都要ok
接下来就是在单节点上恢复数据库了
中间出现了两次报错
input datafile file number=00001 name=+DATADG01/prod/datafile/system.256.1083328327 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/26/2022 15:53:20 ORA-17628: Oracle error 19505 returned by remote Oracle server continuing other job steps, job failed will not be re-run 原因是单节点上不存在对应的目录 /u01/app/oracle/oradata/prod/datafile/
创建相应的目录
[oracle@dbserver dbs]$ mkdir -p /u01/app/oracle/oradata/prod/datafile/ [oracle@dbserver dbs]$ mkdir -p /u01/app/oracle/oradata/prod/onlinelog/
重新开始
[oracle@dbserver dbs]$ rman target sys/oracle@tns_primary auxiliary sys/oracle@tns_150
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jan 26 15:58:01 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=495166741)
connected to auxiliary database: PROD (not mounted)
RMAN> duplicate target database to prod from active database nofilenamecheck;
Starting Duplicate Db at 2022-01-26 15:58:20
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=197 device type=DISK
contents of Memory Script:
{
sql clone "alter system set db_name =
''PROD'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''PROD'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format '/u01/app/oracle/oradata/prod/control01.ctl';
restore clone controlfile to '/u01/app/oracle/oradata/prod/control02.ctl' from
'/u01/app/oracle/oradata/prod/control01.ctl';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 3023110144 bytes
Fixed Size 2257072 bytes
Variable Size 1845497680 bytes
Database Buffers 1157627904 bytes
Redo Buffers 17727488 bytes
Starting backup at 2022-01-26 15:58:29
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 instance=prod1 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_prod1.f tag=TAG20220126T155332 RECID=9 STAMP=1095004413
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2022-01-26 15:58:32
Starting restore at 2022-01-26 15:58:32
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=197 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 2022-01-26 15:58:33
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"/u01/app/oracle/oradata/prod/datafile/system.256.1083328327";
set newname for datafile 2 to
"/u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327";
set newname for datafile 3 to
"/u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327";
set newname for datafile 4 to
"/u01/app/oracle/oradata/prod/datafile/users.259.1083328327";
set newname for datafile 5 to
"/u01/app/oracle/oradata/prod/datafile/example.264.1083328433";
set newname for datafile 6 to
"/u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627";
set newname for datafile 7 to
"/u01/app/oracle/oradata/prod/datafile/gac.277.1084032029";
set newname for datafile 8 to
"/u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067";
set newname for datafile 9 to
"/u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817";
set newname for datafile 10 to
"/u01/app/oracle/oradata/prod/datafile/test.278.1084036129";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/system.256.1083328327" datafile
2 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327" datafile
3 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327" datafile
4 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/users.259.1083328327" datafile
5 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/example.264.1083328433" datafile
6 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627" datafile
7 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/gac.277.1084032029" datafile
8 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067" datafile
9 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817" datafile
10 auxiliary format
"/u01/app/oracle/oradata/prod/datafile/test.278.1084036129" ;
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
Starting backup at 2022-01-26 15:58:38
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATADG01/prod/datafile/system.256.1083328327
output file name=/u01/app/oracle/oradata/prod/datafile/system.256.1083328327 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+DATADG01/prod/datafile/sysaux.257.1083328327
output file name=/u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+DATADG01/prod/datafile/example.264.1083328433
output file name=/u01/app/oracle/oradata/prod/datafile/example.264.1083328433 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=+DATADG01/prod/datafile/gac.277.1084032029
output file name=/u01/app/oracle/oradata/prod/datafile/gac.277.1084032029 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=+DATADG02/prod/datafile/haifeng.269.1084032067
output file name=/u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=+DATADG02/prod/datafile/shaot.270.1084035817
output file name=/u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=+DATADG01/prod/datafile/test.278.1084036129
output file name=/u01/app/oracle/oradata/prod/datafile/test.278.1084036129 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+DATADG01/prod/datafile/undotbs1.258.1083328327
output file name=/u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=+DATADG01/prod/datafile/undotbs2.265.1083328627
output file name=/u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATADG01/prod/datafile/users.259.1083328327
output file name=/u01/app/oracle/oradata/prod/datafile/users.259.1083328327 tag=TAG20220126T155341
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2022-01-26 16:00:04
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "+ARCHDG01/prod/archivelog/2022_01_26/thread_1_seq_65.361.1095004507" auxiliary format
"/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_65_1083328407.dbf" archivelog like
"+ARCHDG01/prod/archivelog/2022_01_26/thread_2_seq_47.360.1095000677" auxiliary format
"/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_47_1083328407.dbf" archivelog like
"+ARCHDG01/prod/archivelog/2022_01_26/thread_2_seq_48.362.1095004509" auxiliary format
"/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_48_1083328407.dbf" ;
catalog clone archivelog "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_65_1083328407.dbf";
catalog clone archivelog "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_47_1083328407.dbf";
catalog clone archivelog "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_48_1083328407.dbf";
switch clone datafile all;
}
executing Memory Script
Starting backup at 2022-01-26 16:00:08
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=65 RECID=184 STAMP=1095004507
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_65_1083328407.dbf 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=2 sequence=47 RECID=183 STAMP=1095000677
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_47_1083328407.dbf 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=2 sequence=48 RECID=185 STAMP=1095004508
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_48_1083328407.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 2022-01-26 16:00:11
cataloged archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_65_1083328407.dbf RECID=184 STAMP=1095004811
cataloged archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_47_1083328407.dbf RECID=185 STAMP=1095004812
cataloged archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_48_1083328407.dbf RECID=186 STAMP=1095004812
datafile 1 switched to datafile copy
input datafile copy RECID=9 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/system.256.1083328327
datafile 2 switched to datafile copy
input datafile copy RECID=10 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327
datafile 3 switched to datafile copy
input datafile copy RECID=11 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327
datafile 4 switched to datafile copy
input datafile copy RECID=12 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/users.259.1083328327
datafile 5 switched to datafile copy
input datafile copy RECID=13 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/example.264.1083328433
datafile 6 switched to datafile copy
input datafile copy RECID=14 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627
datafile 7 switched to datafile copy
input datafile copy RECID=15 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/gac.277.1084032029
datafile 8 switched to datafile copy
input datafile copy RECID=16 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067
datafile 9 switched to datafile copy
input datafile copy RECID=17 STAMP=1095004812 file name=/u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817
datafile 10 switched to datafile copy
input datafile copy RECID=18 STAMP=1095004813 file name=/u01/app/oracle/oradata/prod/datafile/test.278.1084036129
contents of Memory Script:
{
set until scn 1426311;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 2022-01-26 16:00:14
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 65 is already on disk as file /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_65_1083328407.dbf
archived log for thread 2 with sequence 48 is already on disk as file /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_48_1083328407.dbf
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_65_1083328407.dbf thread=1 sequence=65
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_48_1083328407.dbf thread=2 sequence=48
media recovery complete, elapsed time: 00:00:01
Finished recover at 2022-01-26 16:00:16
Oracle instance started
Total System Global Area 3023110144 bytes
Fixed Size 2257072 bytes
Variable Size 1845497680 bytes
Database Buffers 1157627904 bytes
Redo Buffers 17727488 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''PROD'' 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 Script
sql statement: alter system set db_name = ''PROD'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 3023110144 bytes
Fixed Size 2257072 bytes
Variable Size 1845497680 bytes
Database Buffers 1157627904 bytes
Redo Buffers 17727488 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PROD" RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/u01/app/oracle/oradata/prod/onlinelog/group_1.261.1083328407', '/u01/app/oracle/oradata/prod/onlinelog/group_1.257.1083328407' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/app/oracle/oradata/prod/onlinelog/group_2.258.1083328409', '/u01/app/oracle/oradata/prod/onlinelog/group_2.262.1083328407' ) SIZE 50 M REUSE,
GROUP 5 ( '/u01/app/oracle/oradata/prod/onlinelog/group_5.269.1084028089', '/u01/app/oracle/oradata/prod/onlinelog/group_5.261.1084028089' ) SIZE 50 M REUSE
DATAFILE
'/u01/app/oracle/oradata/prod/datafile/system.256.1083328327'
CHARACTER SET ZHS16GBK
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP 3 ( '/u01/app/oracle/oradata/prod/onlinelog/group_3.266.1083328693', '/u01/app/oracle/oradata/prod/onlinelog/group_3.259.1083328693' ) SIZE 50 M REUSE,
GROUP 4 ( '/u01/app/oracle/oradata/prod/onlinelog/group_4.267.1083328693', '/u01/app/oracle/oradata/prod/onlinelog/group_4.260.1083328693' ) SIZE 50 M REUSE,
GROUP 6 ( '/u01/app/oracle/oradata/prod/onlinelog/group_6.262.1084028105', '/u01/app/oracle/oradata/prod/onlinelog/group_6.270.1084028105' ) SIZE 50 M REUSE
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/prod/tempfile/temp.263.1083328429";
switch clone tempfile all;
catalog clone datafilecopy "/u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327",
"/u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327",
"/u01/app/oracle/oradata/prod/datafile/users.259.1083328327",
"/u01/app/oracle/oradata/prod/datafile/example.264.1083328433",
"/u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627",
"/u01/app/oracle/oradata/prod/datafile/gac.277.1084032029",
"/u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067",
"/u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817",
"/u01/app/oracle/oradata/prod/datafile/test.278.1084036129";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/prod/tempfile/temp.263.1083328429 in control file
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327 RECID=1 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327 RECID=2 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/users.259.1083328327 RECID=3 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/example.264.1083328433 RECID=4 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627 RECID=5 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/gac.277.1084032029 RECID=6 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067 RECID=7 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817 RECID=8 STAMP=1095004835
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/prod/datafile/test.278.1084036129 RECID=9 STAMP=1095004836
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/users.259.1083328327
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/example.264.1083328433
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/gac.277.1084032029
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=1095004835 file name=/u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=1095004836 file name=/u01/app/oracle/oradata/prod/datafile/test.278.1084036129
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 2022-01-26 16:00:47
RMAN>
恢复完成，且数据库文件目录已经自动转换
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/prod/datafile/system.256.1083328327 /u01/app/oracle/oradata/prod/datafile/sysaux.257.1083328327 /u01/app/oracle/oradata/prod/datafile/undotbs1.258.1083328327 /u01/app/oracle/oradata/prod/datafile/users.259.1083328327 /u01/app/oracle/oradata/prod/datafile/example.264.1083328433 /u01/app/oracle/oradata/prod/datafile/undotbs2.265.1083328627 /u01/app/oracle/oradata/prod/datafile/haifeng.269.1084032067 /u01/app/oracle/oradata/prod/datafile/shaot.270.1084035817 /u01/app/oracle/oradata/prod/datafile/test.278.1084036129 10 rows selected.
