Liunx中Oracle 11g duplicate恢复至异机---实测
源端 ： liunx6 oracle 11.2.0.1.0
主机名： zwl1
IP： 192.168.43.191
目标端：liunx6 oracle 11.2.0.1.0
主机名： zwl2
IP： 192.168.43.192
Oracle11g duplicate相比于10g需要将备份文件拷贝至目标端进行恢复，11g duplicate可在源库开启状态进行恢复数据库至目标端，源库可不用进行备份，操作简单方便。适用于恢复测试库、主库异机恢复、搭建DG等.
以下在oracle用户下操作：
1.源端开启归档：
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/arch1
Oldest online log sequence 28
Next log sequence to archive 30
Current log sequence 30
如未配置归档，如下配置归档：
$sqlplus / as sysdba
SQL>startup mount
SQL>alter system set log_archive_dest_1='location=/home/oracle/arch1';
SQL>alter database archivelog;
SQL>alter database open;
2.配置监听源端和目标端：
源端tnsname.ora
PROD1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zwl1.us.oracle.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD1.US.ORACLE.COM)
)
)
PROD5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zwl2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD5.US.ORACLE.COM)
)
)
目标端tnsname.ora
PROD1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zwl1.us.oracle.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD1.us.oracle.com)
)
)
PROD5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zwl2.us.oracle.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD5.us.oracle.com)
)
)
目标端：listener.ora(需要配置静态监听，源端连接nomount状态目标端)
ADR_BASE_LSNR2 = /u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PROD4.us.oracle.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = PROD4)
)
(SID_DESC =
(GLOBAL_DBNAME = EMREP.us.oracle.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = EMREP)
)
(SID_DESC =
(GLOBAL_DBNAME = PROD5.us.oracle.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = PROD5)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zwl2.us.oracle.com)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
3.源端生成pfile文件及密码文件传至目标端，目标端修改参数文件配置路径并启动到nomount状态
源端操作：
$sqlplus / as sysdba
SQL>create pfile='/home/oracle/initPROD1.ora' from spfile;
目标端操作:
修改pfile文件
$vim $ORACLE_HOME/dbs/initPROD5.ora
PROD5.__db_cache_size=213909504
PROD5.__java_pool_size=4194304
PROD5.__large_pool_size=41943040
PROD5.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
PROD5.__pga_aggregate_target=213909504
PROD5.__sga_target=637534208
PROD5.__shared_io_pool_size=0
PROD5.__shared_pool_size=360710144
PROD5.__streams_pool_size=8388608
*.audit_file_dest='/u01/app/oracle/admin/PROD5/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl',
'/u01/app/oracle/flash_recovery_area/PROD5/controlfile/o1_mf_bpy15799_.ctl','/u0
1/app/oracle/oradata/PROD5/controlfile/control03.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata'
*.db_domain='US.ORACLE.COM'
*.db_name='PROD5'
*.db_recovery_file_dest='/home/oracle/flash'
*.db_recovery_file_dest_size=4294967296
*.diagnostic_dest='/u01/app/oracle/product/11.2.0/db_1'
*.dispatchers='(PROTOCOL=TCP)(DISPATCHERS=3)'
*.job_queue_processes=15
*.log_archive_dest_1='location=/home/oracle/arch1'
*.max_dispatchers=10
*.max_shared_servers=30
*.open_cursors=300
*.parallel_degree_policy='AUTO'
*.parallel_max_servers=100
*.parallel_min_servers=10
*.parallel_min_time_threshold='5'
*.pga_aggregate_target=211812352
*.processes=135
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=300
*.sga_target=635437056
*.star_transformation_enabled='TRUE'
*.undo_retention=5400
*.undo_tablespace='UNDOTBS1'
*.utl_file_dir='/home/oracle','/home/oracle/temp','/home/oracle/scripts'
审计目录
$mkdir /u01/app/oracle/admin/PROD5/adump -p
控制文件目录
$mkdir /u01/app/oracle/oradata/PROD5/controlfile/ -p
闪回缓冲区目录
$mkdir /u01/app/oracle/flash_recovery_area/PROD5/controlfile/ -p
闪回目录
$mkdir /home/oracle/flash -p
归档目录
$mkdir /home/oracle/arch1 -p
启动PROD5到nomount状态
$. oraenv
PROD5
$sqlplus / as sysdba
SQL>startup nomount;(如提示监听参数异常，暂时取消监听参数起到nomount）
如下为PROD5当前实例监听正确显示：
查看PROD5状态
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
PROD5 STARTED
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[[email protected] admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-JUN-2020 04:32:40
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zwl2.us.oracle.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 18-JUN-2020 01:07:20
Uptime 0 days 3 hr. 25 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/zwl2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zwl2.us.oracle.com)(PORT=1521)))
Services Summary...
Service "EMREP.us.oracle.com" has 1 instance(s).
Instance "EMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD4.us.oracle.com" has 1 instance(s).
Instance "PROD4", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD5.us.oracle.com" has 2 instance(s).
Instance "PROD5", status UNKNOWN, has 1 handler(s) for this service...
Instance "PROD5", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
[[email protected] admin]$
4.源端duplicate至目标端
源端操作：
连接rman进行duplicate PROD1---duplicate--PROD5
$rman target sys/[email protected] auxiliary sys/[email protected] nocatalog
rman>duplicate target database to PROD5 from active database nofilenamecheck
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=160 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=161 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=11 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=162 device type=DISK
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 188744680 bytes
Database Buffers 440401920 bytes
Redo Buffers 5615616 bytes
contents of Memory Script:
{
sql clone "alter system set control_files =
''/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl'', ''/u01/app/oracle/flash_recovery_area/PROD5/controlfile/o1_mf_bpy15799_.ctl'', ''/u01/app/oracle/oradata/PROD5/controlfile/control03.ctl'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''PROD1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''PROD5'' 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/PROD5/controlfile/o1_mf_bpy15704_.ctl';
restore clone controlfile to '/u01/app/oracle/flash_recovery_area/PROD5/controlfile/o1_mf_bpy15799_.ctl' from
'/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl';
restore clone controlfile to '/u01/app/oracle/oradata/PROD5/controlfile/control03.ctl' from
'/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl';
sql clone "alter system set control_files =
''/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl'', ''/u01/app/oracle/flash_recovery_area/PROD5/controlfile/o1_mf_bpy15799_.ctl'', ''/u01/app/oracle/oradata/PROD5/controlfile/control03.ctl'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set control_files = ''/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl'', ''/u01/app/oracle/flash_recovery_area/PROD5/controlfile/o1_mf_bpy15799_.ctl'', ''/u01/app/oracle/oradata/PROD5/controlfile/control03.ctl'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''PROD1'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''PROD5'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 188744680 bytes
Database Buffers 440401920 bytes
Redo Buffers 5615616 bytes
Starting backup at 18-JUN-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=167 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=169 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_PROD1.f tag=TAG20200618T033954 RECID=2 STAMP=1043379601
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:16
Finished backup at 18-JUN-20
Starting restore at 18-JUN-20
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=160 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=161 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=11 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=162 device type=DISK
channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_3: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_4: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 18-JUN-20
Starting restore at 18-JUN-20
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_3: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_4: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 18-JUN-20
sql statement: alter system set control_files = ''/u01/app/oracle/oradata/PROD5/controlfile/o1_mf_bpy15704_.ctl'', ''/u01/app/oracle/flash_recovery_area/PROD5/controlfile/o1_mf_bpy15799_.ctl'', ''/u01/app/oracle/oradata/PROD5/controlfile/control03.ctl'' comment= ''Set by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 188744680 bytes
Database Buffers 440401920 bytes
Redo Buffers 5615616 bytes
database mounted
contents of Memory Script:
{
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
backup as copy reuse
datafile 1 auxiliary format new
datafile 2 auxiliary format new
datafile 3 auxiliary format new
datafile 4 auxiliary format new
datafile 5 auxiliary format new
datafile 6 auxiliary format new
datafile 7 auxiliary format new
datafile 8 auxiliary format new
datafile 9 auxiliary format new
;
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
Starting backup at 18-JUN-20
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/datafile/o1_mf_system_bpy12gck_.dbf
channel ORA_DISK_2: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD1/datafile/o1_mf_sysaux_bpy12gfm_.dbf
channel ORA_DISK_3: starting datafile copy
input datafile file number=00006 name=/u01/app/oracle/oradata/PROD1/datafile/test1.dbf
channel ORA_DISK_4: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD1/datafile/o1_mf_undotbs1_bpy12ggz_.dbf
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_undotbs1_0cv31def_.dbf tag=TAG20200618T034101
channel ORA_DISK_4: datafile copy complete, elapsed time: 00:06:56
channel ORA_DISK_4: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/PROD1/datafile/o1_mf_example_bpy15nf0_.dbf
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_test_0bv31dee_.dbf tag=TAG20200618T034101
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:08:31
channel ORA_DISK_3: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/PROD1/datafile/indx1.dbf
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_example_0dv31drl_.dbf tag=TAG20200618T034101
channel ORA_DISK_4: datafile copy complete, elapsed time: 00:01:48
channel ORA_DISK_4: starting datafile copy
input datafile file number=00009 name=/u01/app/oracle/oradata/PROD1/datafile/oltp1.dbf
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_indx_0ev31duh_.dbf tag=TAG20200618T034101
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:29
channel ORA_DISK_3: starting datafile copy
input datafile file number=00008 name=/u01/app/oracle/oradata/PROD1/datafile/tools1.dbf
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_oltp_0fv31dv5_.dbf tag=TAG20200618T034101
channel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:22
channel ORA_DISK_4: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/PROD1/datafile/o1_mf_users_bpy12gjt_.dbf
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_tools_0gv31dvo_.dbf tag=TAG20200618T034101
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:18
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_users_0hv31e06_.dbf tag=TAG20200618T034101
channel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:08
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_sysaux_0av31dee_.dbf tag=TAG20200618T034101
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:09:45
output file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_system_09v31ded_.dbf tag=TAG20200618T034101
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:10:06
Finished backup at 18-JUN-20
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "/home/oracle/arch1/1_29_881415849.dbf" auxiliary format
"/home/oracle/arch1/1_29_881415849.dbf" ;
catalog clone archivelog "/home/oracle/arch1/1_29_881415849.dbf";
switch clone datafile all;
}
executing Memory Script
Starting backup at 18-JUN-20
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=29 RECID=23 STAMP=1043380274
output file name=/home/oracle/arch1/1_29_881415849.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
Finished backup at 18-JUN-20
cataloged archived log
archived log file name=/home/oracle/arch1/1_29_881415849.dbf RECID=23 STAMP=1043380281
datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_system_09v31ded_.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_sysaux_0av31dee_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_undotbs1_0cv31def_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_users_0hv31e06_.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=6 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_example_0dv31drl_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=7 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_test_0bv31dee_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=8 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_indx_0ev31duh_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=9 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_tools_0gv31dvo_.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=10 STAMP=1043380282 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_oltp_0fv31dv5_.dbf
contents of Memory Script:
{
set until scn 1153493;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 18-JUN-20
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=160 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=10 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=161 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=11 device type=DISK
starting media recovery
archived log for thread 1 with sequence 29 is already on disk as file /home/oracle/arch1/1_29_881415849.dbf
archived log file name=/home/oracle/arch1/1_29_881415849.dbf thread=1 sequence=29
media recovery complete, elapsed time: 00:00:02
Finished recover at 18-JUN-20
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
sql clone "alter system set db_name =
''PROD5'' 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
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 188744680 bytes
Database Buffers 440401920 bytes
Redo Buffers 5615616 bytes
sql statement: alter system set db_name = ''PROD5'' 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 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 188744680 bytes
Database Buffers 440401920 bytes
Redo Buffers 5615616 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PROD5" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 50 M ,
GROUP 2 SIZE 50 M ,
GROUP 3 SIZE 50 M
DATAFILE
'/u01/app/oracle/oradata/PROD5/datafile/o1_mf_system_09v31ded_.dbf'
CHARACTER SET AL32UTF8
contents of Memory Script:
{
set newname for clone tempfile 1 to new;
set newname for clone tempfile 2 to new;
set newname for clone tempfile 3 to new;
switch clone tempfile all;
catalog clone datafilecopy "/u01/app/oracle/oradata/PROD5/datafile/o1_mf_sysaux_0av31dee_.dbf",
"/u01/app/oracle/oradata/PROD5/datafile/o1_mf_undotbs1_0cv31def_.dbf",
"/u01/app/oracle/oradata/PROD5/datafile/o1_mf_users_0hv31e06_.dbf",
"/u01/app/oracle/oradata/PROD5/datafile/o1_mf_example_0dv31drl_.dbf",
"/u01/app/oracle/oradata/PROD5/datafile/o1_mf_test_0bv31dee_.dbf",
"/u01/app/oracle/oradata/PROD5/datafile/o1_mf_indx_0ev31duh_.dbf",
"/u01/app/oracle/oradata/PROD5/datafile/o1_mf_tools_0gv31dvo_.dbf",
"/u01/app/oracle/oradata/PROD5/datafile/o1_mf_oltp_0fv31dv5_.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/PROD5/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 2 to /u01/app/oracle/oradata/PROD5/datafile/o1_mf_temp1_%u_.tmp in control file
renamed tempfile 3 to /u01/app/oracle/oradata/PROD5/datafile/o1_mf_temp2_%u_.tmp in control file
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_sysaux_0av31dee_.dbf RECID=1 STAMP=1043380331
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_undotbs1_0cv31def_.dbf RECID=2 STAMP=1043380331
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_users_0hv31e06_.dbf RECID=3 STAMP=1043380331
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_example_0dv31drl_.dbf RECID=4 STAMP=1043380331
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_test_0bv31dee_.dbf RECID=5 STAMP=1043380331
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_indx_0ev31duh_.dbf RECID=6 STAMP=1043380331
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_tools_0gv31dvo_.dbf RECID=7 STAMP=1043380331
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_oltp_0fv31dv5_.dbf RECID=8 STAMP=1043380331
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_sysaux_0av31dee_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_undotbs1_0cv31def_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_users_0hv31e06_.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_example_0dv31drl_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_test_0bv31dee_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_indx_0ev31duh_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_tools_0gv31dvo_.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=1043380331 file name=/u01/app/oracle/oradata/PROD5/datafile/o1_mf_oltp_0fv31dv5_.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 18-JUN-20
RMAN>
5.目标库操作：检查目标库状态，检查告警日志有无异常
$sqlplus / as sysdba
SQL>select instance_name,status from v$instance;
duplicate完成