一、oracle12c rman克隆步骤
1、生成环境信息查询
1）实例状态信息
2）数据文件信息
3）日志文件信息
4）参数文件信息
2、测试环境准备：
0）数据库软件安装和配置
1）pfile参数文件
2）密码文件
3）创建相关的目录
4）配置静态监听和TNS
5）启动中间件库到nomount
6）验证用户密码
7）生成用spfile启动。
8）rman克隆准备
9）执行rman克隆
二、rman克隆具体操作
--1、查询source库信息
[root@erpdb ~]# su - oraprod Last login: Fri Apr 20 16:56:02 CST 2018 on pts/4[oraprod@erpdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 09:55:20 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startupTotal System Global Area 4.2950E+10 bytes
Fixed Size 3722144 bytes
Variable Size 2.6172E+10 bytes
Database Buffers 1.5569E+10 bytes
Redo Buffers 1204236288 bytes
Database mounted.
Database opened.
--查询实例信息
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
PROD OPEN
--查询数据文件信息
SQL> set pagesize 200
SQL> select file#,name from v$datafile;
FILE# NAME
---------- ----------------------------------------
1 /oradata/prod/proddata/system01.dbf
2 /oradata/prod/proddata/system02.dbf
3 /oradata/prod/proddata/system03.dbf
4 /oradata/prod/proddata/system04.dbf
5 /oradata/prod/proddata/system05.dbf
6 /oradata/prod/proddata/ctxd01.dbf
7 /oradata/prod/proddata/owad01.dbf
8 /oradata/prod/proddata/a_queue02.dbf
9 /oradata/prod/proddata/odm.dbf
10 /oradata/prod/proddata/olap.dbf
.....
351 /oradata/prod/proddata/system07.dbf
352 /oradata/prod/proddata/system09.dbf
353 /oradata/prod/proddata/system08.dbf
354 /oradata/prod/proddata/system11.dbf
379 /oradata/prod/proddata/undo01.dbf
392 /oradata/prod/proddata/a_txn_data01.dbf
393 /oradata/prod/proddata/a_txn_ind01.dbf
394 /oradata/prod/proddata/a_ref01.dbf
395 /oradata/prod/proddata/a_int01.dbf
396 /oradata/prod/proddata/a_summ01.dbf
397 /oradata/prod/proddata/a_nolog01.dbf
398 /oradata/prod/proddata/a_archive01.dbf
399 /oradata/prod/proddata/a_queue01.dbf
400 /oradata/prod/proddata/a_media01.dbf
401 /oradata/prod/proddata/a_txn_data02.dbf
402 /oradata/prod/proddata/a_txn_data03.dbf
403 /oradata/prod/proddata/a_txn_ind02.dbf
404 /oradata/prod/proddata/a_txn_ind03.dbf
405 /oradata/prod/proddata/a_txn_ind04.dbf
406 /oradata/prod/proddata/a_txn_ind05.dbf
407 /oradata/prod/proddata/a_ref02.dbf
97 rows selected.
--查询日志文件信息
SQL> col member format a40;
SQL>
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- ----------------------------------------
2 /oradata/prod/proddata/log02a.dbf
2 /oradata/prod/proddata/log02b.dbf
1 /oradata/prod/proddata/log01a.dbf
1 /oradata/prod/proddata/log01b.dbf
3 /oradata/prod/proddata/log03a.dbf
4 /oradata/prod/proddata/log04a.dbf
5 /oradata/prod/proddata/log05a.dbf
3 /oradata/prod/proddata/log03b.dbf
4 /oradata/prod/proddata/log04b.dbf
5 /oradata/prod/proddata/log05b.dbf
10 rows selected.
--查询重要参数信息
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string PROD
db_unique_name string PROD
global_names boolean FALSE
instance_name string PROD
lock_name_space string
log_file_name_convert string
pdb_file_name_convert string
processor_group_name string
service_names string PROD, ebs_patch
--2、构建target测试库
主要步骤：
--1）pfile参数文件
--（source）
create pfile='/ora/prod/pfile/pf.ora' from spfile;
$ scp pfile/pf.ora orapbz@192.168.1.9:/u01/oracle/ebs/db
--（target）
pf.ora中需要替换路径：
oracle_base:/ora/prod/ /u01/oracle/ebs/db/
oracle_datadir: /oradata/prod/ /u01/oracle/ebs/db/
修改参数：
cd /u01/oracle/ebs/db
vi pf.ora
%s#/ora/prod/#/u01/oracle/ebs/db/#g
%s#/oradata/prod/#/u01/oracle/ebs/db/#g
%s#/home/erp_db_rec/#/u01/oracle/ebs/db/#g
%s#/ora/prod/12.1.0/admin/PROD_erpdb#/u01/oracle/ebs/db/12.1.0/admin/PBZ_erptest#g
%s#PROD#PBZ#g
%s#/arch/prod/archive#/u01/oracle/ebs/db/archive#g
%s#erpdb#erptest#g
添加参数：
*.db_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/') ；如果源库和目标库在同
一台主机，需要配置文件存储路径转换参数
*.log_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')
修改后pf.ora
---------------------------------------------------------------------------
$ cat initPBZ.ora
*._b_tree_bitmap_plans=FALSE# Required 11i setting
*._fast_full_scan_enabled=FALSE
*._like_with_bind_as_equality=TRUE
*._optimizer_autostats_job=false# Turning off auto statistics
*._sort_elimination_cost_ratio=5
*._system_trig_enabled=TRUE
*._TRACE_FILES_PUBLIC=FALSE
*.aq_tm_processes=1
*.AUDIT_SYS_OPERATIONS=TRUE
*.compatible='12.1.0'
*.control_files='/u01/oracle/ebs/db/proddata/cntrl01.dbf','/u01/oracle/ebs/db/proddata/cntrl02.dbf','/ebs122/ER
PPBZ/db/proddata/cntrl03.dbf'
*.cursor_sharing='EXACT'# Required 11i settting
*.db_block_checking='FALSE'
*.db_block_checksum='TRUE'
*.db_block_size=8192
*.db_files=512# Max. no. of database files
*.db_name='PBZ'
*.db_recovery_file_dest_size=214748364800
*.db_recovery_file_dest='/u01/oracle/ebs/db/db_recovery_dest'
*.diagnostic_dest='/u01/oracle/ebs/db/12.1.0/admin/PBZ_erptest'
*.dml_locks=10000
*.event='1652 trace name errorstack'
*.job_queue_processes=10
*.local_listener='PBZ_LOCAL'
*.log_archive_dest_1='LOCATION=/u01/oracle/ebs/db/archive'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=1048576000
*.log_checkpoint_interval=100000
*.log_checkpoint_timeout=1200# Checkpoint at least every 20 mins.
*.log_checkpoints_to_alert=TRUE
*.max_dump_file_size='20480'# trace file size
*.nls_comp='binary'# Required 11i setting
*.nls_date_format='DD-MON-RR'
*.nls_length_semantics='BYTE'# Required 11i setting
*.nls_numeric_characters='.,'
*.nls_sort='binary'# Required 11i setting
*.nls_territory='america'
*.o7_dictionary_accessibility=FALSE#MP
*.olap_page_pool_size=4194304
*.open_cursors=600# Consumes process memory, unless using MTS.
*.optimizer_secure_view_merging=false
*.OS_AUTHENT_PREFIX=''
*.parallel_force_local=TRUE
*.parallel_max_servers=8
*.parallel_min_servers=0
*.pga_aggregate_limit=0
*.pga_aggregate_target=10G
*.plsql_code_type='INTERPRETED'# Default 11i setting
*.processes=1000# Max. no. of users x 2
*.recyclebin='off'
*.remote_login_passwordfile='EXCLUSIVE'
*.service_names='PBZ','ebs_patch'
*.session_cached_cursors=500
*.sessions=2000# 2 X processes
*.sga_target=12G
*.SQL92_SECURITY=TRUE
*.temp_undo_enabled=true
*.undo_management='AUTO'# Required 11i setting
*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting
*.utl_file_dir='/usr/tmp','/tmp','/u01/oracle/ebs/db/12.1.0/appsutil/outbound/PBZ_erptest','/usr/tmp'
*.workarea_size_policy='AUTO'# Required 11i setting
#.db_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')
*.log_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')
---------------------------------------------------------------------------------
--2）密码文件
--方法一：从source库进行拷贝
cp orapwPROD orapwPBZ
scp orapwPBZ orapbz@192.168.1.93:/u01/oracle/ebs/db
mv /u01/oracle/ebs/db/orapwPBZ /u01/oracle/ebs/db/12.1.0/dbs/
--方法二：使用orapwd进行创建
or
orapwd file=/u01/oracle/ebs/db/12.1.0/dbs/orapwPBZ password=oraProd123 entries=5 format=12 force=y
在source端：
orapwd file=/ora/prod/12.1.0/dbs/orapwPROD password=oraProd123 entries=5 format=12 force=y
--3）建相关的目录
注：相关目录需与pfile文件中保存一致
--4）配置静态监听和TNS
cd /u01/oracle/ebs/db/12.1.0/network/admin/PBZ_erptest
--配置静态监听
$ vi listener.ora
#
# $Header: ad8ilsnr.ora 120.5 2010/07/29 11:08:44 upinjark ship $
#
# ###############################################################
#
# Do not edit settings in this file manually. They are managed
# automatically and will be overwritten when AutoConfig runs.
# For more information about AutoConfig, refer to the Oracle
# E-Business Suite Setup Guide.
#
# ###############################################################
#
#
# Net8 definition for Database listener
#
PBZ =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = erptest.dbbo.com)(PORT = 1571))
)
)
SID_LIST_PBZ =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u01/oracle/ebs/db/12.1.0)
(SID_NAME = PBZ)
)
)
STARTUP_WAIT_TIME_PBZ = 0
CONNECT_TIMEOUT_PBZ = 10
TRACE_LEVEL_PBZ = OFF
LOG_DIRECTORY_PBZ = /u01/oracle/ebs/db/12.1.0/network/admin
LOG_FILE_PBZ = PBZ
TRACE_DIRECTORY_PBZ = /u01/oracle/ebs/db/12.1.0/network/admin
TRACE_FILE_PBZ = PBZ
ADMIN_RESTRICTIONS_PBZ = ON
SUBSCRIBE_FOR_NODE_DOWN_EVENT_PBZ = OFF
-----------------------------------------------------------
--配置tns
cat tnsnames.ora
PBZ=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=erptest.dbbo.com)(PORT=1571))
(CONNECT_DATA=
(SERVICE_NAME=PBZ)
(INSTANCE_NAME=PBZ)
)
)
PROD=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.213)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=PROD)
(INSTANCE_NAME=PROD)
)
)
--------------------------------------------------------------
--测试tns
$ tnsping PROD
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 25-APR-2018 14:39:00
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u01/oracle/ebs/db/12.1.0/network/admin/PBZ_erptest/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.213)(PORT=1521)) (CONNECT_DATA=
(SERVICE_NAME=PROD) (INSTANCE_NAME=PROD)))
OK (0 msec)
--5）启动中间件库到nomount
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 15:03:43 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/u01/oracle/ebs/db/12.1.0/dbs/initPBZ.ora';
ORACLE instance started.
Total System Global Area 1.2885E+10 bytes
Fixed Size 4511656 bytes
Variable Size 1811941464 bytes
Database Buffers 9965666304 bytes
Redo Buffers 1102782464 bytes
--6）验证用户密码
$ sqlplus sys/oraProd123@PROD as sysdba
$ sqlplus sys/oraProd123@PBZ as sysdba
--7）生成用spfile启动。
SQL> create spfile from pfile;
--重新启动到nomount状态
shutdown immediate;
startup nomount;
SQL> show parameter spfile;
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
spfile string
/u01/oracle/ebs/db/12.1.0/dbs/s
pfilePBZ.ora
--配置RMAN克隆
--8）rman克隆准备
$rman target sys/oraProd123@PROD auxiliary sys/oraProd123@PBZ
--9）执行rman克隆
RMAN>
--Oracle 11g 数据库克隆脚本
duplicate target database to PBZ from active database nofilenamecheck;
--Oracle 12c 数据库克隆脚本
run{
allocate channel prm1 type disk;
allocate channel prm2 type disk;
allocate auxiliary channel uax1 type disk;
allocate auxiliary channel uax2 type disk;
duplicate target database to PBZ from active database using backupset
db_file_name_convert='/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/';
}
--10)rman克隆执行过程
RMAN> run{
2> allocate channel p1 type disk;
3> allocate channel p2 type disk;
4> allocate auxiliary channel uax1 type disk;
5> allocate auxiliary channel uax2 type disk;
6> duplicate target database to PBZ from active database using backupset
7> db_file_name_convert='/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/';
8> }
allocated channel: p1
channel p1: SID=1758 device type=DISK
allocated channel: p2
channel p2: SID=1506 device type=DISK
allocated channel: uax1
channel uax1: SID=1170 device type=DISK
allocated channel: uax2
channel uax2: SID=169 device type=DISK
Starting Duplicate Db at 25-APR-18
current log archived
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 =
''PBZ'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'PROD' primary controlfile;
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 = ''PBZ'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 12884901888 bytes
Fixed Size 4511656 bytes
Variable Size 1811941464 bytes
Database Buffers 9965666304 bytes
Redo Buffers 1102782464 bytes
allocated channel: uax1
channel uax1: SID=169 device type=DISK
allocated channel: uax2
channel uax2: SID=337 device type=DISK
Starting restore at 25-APR-18
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: restoring control file
channel uax1: restore complete, elapsed time: 00:00:04
output file name=/u01/oracle/ebs/db/proddata/cntrl01.dbf
output file name=/u01/oracle/ebs/db/proddata/cntrl02.dbf
output file name=/u01/oracle/ebs/db/proddata/cntrl03.dbf
Finished restore at 25-APR-18
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"/u01/oracle/ebs/db/proddata/system01.dbf";
set newname for datafile 2 to
"/u01/oracle/ebs/db/proddata/system02.dbf";
set newname for datafile 3 to
"/u01/oracle/ebs/db/proddata/system03.dbf";
set newname for datafile 4 to
"/u01/oracle/ebs/db/proddata/system04.dbf";
set newname for datafile 5 to
"/u01/oracle/ebs/db/proddata/system05.dbf";
set newname for datafile 6 to
"/u01/oracle/ebs/db/proddata/ctxd01.dbf";
set newname for datafile 7 to
"/u01/oracle/ebs/db/proddata/owad01.dbf";
set newname for datafile 8 to
"/u01/oracle/ebs/db/proddata/a_queue02.dbf";
set newname for datafile 9 to
"/u01/oracle/ebs/db/proddata/odm.dbf";
set newname for datafile 10 to
"/u01/oracle/ebs/db/proddata/olap.dbf";
set newname for datafile 11 to
"/u01/oracle/ebs/db/proddata/sysaux01.dbf";
set newname for datafile 12 to
"/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf";
set newname for datafile 13 to
"/u01/oracle/ebs/db/proddata/system12.dbf";
set newname for datafile 14 to
"/u01/oracle/ebs/db/proddata/a_txn_data04.dbf";
set newname for datafile 15 to
"/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf";
set newname for datafile 16 to
"/u01/oracle/ebs/db/proddata/a_ref03.dbf";
set newname for datafile 17 to
"/u01/oracle/ebs/db/proddata/a_int02.dbf";
set newname for datafile 18 to
"/u01/oracle/ebs/db/proddata/sysaux02.dbf";
set newname for datafile 19 to
"/u01/oracle/ebs/db/proddata/system13.dbf";
set newname for datafile 20 to
"/u01/oracle/ebs/db/proddata/system14.dbf";
set newname for datafile 21 to
"/u01/oracle/ebs/db/proddata/system15.dbf";
set newname for datafile 22 to
"/u01/oracle/ebs/db/proddata/system16.dbf";
set newname for datafile 23 to
"/u01/oracle/ebs/db/proddata/system17.dbf";
set newname for datafile 24 to
"/u01/oracle/ebs/db/proddata/system18.dbf";
set newname for datafile 25 to
"/u01/oracle/ebs/db/proddata/system19.dbf";
set newname for datafile 26 to
"/u01/oracle/ebs/db/proddata/system20.dbf";
set newname for datafile 27 to
"/u01/oracle/ebs/db/proddata/system21.dbf";
set newname for datafile 28 to
"/u01/oracle/ebs/db/proddata/system22.dbf";
set newname for datafile 29 to
"/u01/oracle/ebs/db/proddata/system23.dbf";
set newname for datafile 30 to
"/u01/oracle/ebs/db/proddata/system24.dbf";
set newname for datafile 31 to
"/u01/oracle/ebs/db/proddata/system25.dbf";
set newname for datafile 32 to
"/u01/oracle/ebs/db/proddata/a_ref04.dbf";
set newname for datafile 33 to
"/u01/oracle/ebs/db/proddata/a_ref05.dbf";
set newname for datafile 34 to
"/u01/oracle/ebs/db/proddata/a_ref06.dbf";
set newname for datafile 35 to
"/u01/oracle/ebs/db/proddata/undo02.dbf";
set newname for datafile 36 to
"/u01/oracle/ebs/db/proddata/cux_data01.dbf";
set newname for datafile 37 to
"/u01/oracle/ebs/db/proddata/cux_ind01.dbf";
set newname for datafile 38 to
"/u01/oracle/ebs/db/proddata/undo03.dbf";
set newname for datafile 39 to
"/u01/oracle/ebs/db/proddata/undo04.dbf";
set newname for datafile 40 to
"/u01/oracle/ebs/db/proddata/undo05.dbf";
set newname for datafile 41 to
"/u01/oracle/ebs/db/proddata/a_media02.dbf";
set newname for datafile 42 to
"/u01/oracle/ebs/db/proddata/a_media03.dbf";
set newname for datafile 43 to
"/u01/oracle/ebs/db/proddata/a_media04.dbf";
set newname for datafile 44 to
"/u01/oracle/ebs/db/proddata/sysaux03.dbf";
set newname for datafile 45 to
"/u01/oracle/ebs/db/proddata/a_media05.dbf";
set newname for datafile 46 to
"/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf";
set newname for datafile 47 to
"/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf";
set newname for datafile 48 to
"/u01/oracle/ebs/db/proddata/a_txn_data05.dbf";
set newname for datafile 49 to
"/u01/oracle/ebs/db/proddata/a_txn_data06.dbf";
set newname for datafile 50 to
"/u01/oracle/ebs/db/proddata/a_queue03.dbf";
set newname for datafile 51 to
"/u01/oracle/ebs/db/proddata/ctxd02";
set newname for datafile 52 to
"/u01/oracle/ebs/db/proddata/a_media06.dbf";
set newname for datafile 53 to
"/u01/oracle/ebs/db/proddata/a_media07.dbf";
set newname for datafile 54 to
"/u01/oracle/ebs/db/proddata/sysaux04.dbf";
set newname for datafile 55 to
"/u01/oracle/ebs/db/proddata/a_media08.dbf";
set newname for datafile 56 to
"/u01/oracle/ebs/db/proddata/a_media09.dbf";
set newname for datafile 57 to
"/u01/oracle/ebs/db/proddata/sysaux05.dbf";
set newname for datafile 58 to
"/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf";
set newname for datafile 59 to
"/u01/oracle/ebs/db/proddata/a_txn_data07.dbf";
set newname for datafile 60 to
"/u01/oracle/ebs/db/proddata/a_media10.dbf";
set newname for datafile 61 to
"/u01/oracle/ebs/db/proddata/a_media11.dbf";
set newname for datafile 62 to
"/u01/oracle/ebs/db/proddata/a_media12.dbf";
set newname for datafile 63 to
"/u01/oracle/ebs/db/proddata/a_media13.dbf";
set newname for datafile 64 to
"/u01/oracle/ebs/db/proddata/a_media14.dbf";
set newname for datafile 65 to
"/u01/oracle/ebs/db/proddata/a_media15.dbf";
set newname for datafile 66 to
"/u01/oracle/ebs/db/proddata/a_media16.dbf";
set newname for datafile 67 to
"/u01/oracle/ebs/db/proddata/a_media17.dbf";
set newname for datafile 68 to
"/u01/oracle/ebs/db/proddata/a_media18.dbf";
set newname for datafile 69 to
"/u01/oracle/ebs/db/proddata/a_queue04.dbf";
set newname for datafile 70 to
"/u01/oracle/ebs/db/proddata/a_media19.dbf";
set newname for datafile 71 to
"/u01/oracle/ebs/db/proddata/a_media20.dbf";
set newname for datafile 72 to
"/u01/oracle/ebs/db/proddata/a_media21.dbf";
set newname for datafile 73 to
"/u01/oracle/ebs/db/proddata/a_queue05.dbf";
set newname for datafile 288 to
"/u01/oracle/ebs/db/proddata/system10.dbf";
set newname for datafile 295 to
"/u01/oracle/ebs/db/proddata/system06.dbf";
set newname for datafile 314 to
"/u01/oracle/ebs/db/proddata/portal01.dbf";
set newname for datafile 351 to
"/u01/oracle/ebs/db/proddata/system07.dbf";
set newname for datafile 352 to
"/u01/oracle/ebs/db/proddata/system09.dbf";
set newname for datafile 353 to
"/u01/oracle/ebs/db/proddata/system08.dbf";
set newname for datafile 354 to
"/u01/oracle/ebs/db/proddata/system11.dbf";
set newname for datafile 379 to
"/u01/oracle/ebs/db/proddata/undo01.dbf";
set newname for datafile 392 to
"/u01/oracle/ebs/db/proddata/a_txn_data01.dbf";
set newname for datafile 393 to
"/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf";
set newname for datafile 394 to
"/u01/oracle/ebs/db/proddata/a_ref01.dbf";
set newname for datafile 395 to
"/u01/oracle/ebs/db/proddata/a_int01.dbf";
set newname for datafile 396 to
"/u01/oracle/ebs/db/proddata/a_summ01.dbf";
set newname for datafile 397 to
"/u01/oracle/ebs/db/proddata/a_nolog01.dbf";
set newname for datafile 398 to
"/u01/oracle/ebs/db/proddata/a_archive01.dbf";
set newname for datafile 399 to
"/u01/oracle/ebs/db/proddata/a_queue01.dbf";
set newname for datafile 400 to
"/u01/oracle/ebs/db/proddata/a_media01.dbf";
set newname for datafile 401 to
"/u01/oracle/ebs/db/proddata/a_txn_data02.dbf";
set newname for datafile 402 to
"/u01/oracle/ebs/db/proddata/a_txn_data03.dbf";
set newname for datafile 403 to
"/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf";
set newname for datafile 404 to
"/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf";
set newname for datafile 405 to
"/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf";
set newname for datafile 406 to
"/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf";
set newname for datafile 407 to
"/u01/oracle/ebs/db/proddata/a_ref02.dbf";
restore
from service 'PROD' 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
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
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 25-APR-18
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00001 to /u01/oracle/ebs/db/proddata/system01.dbf
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00002 to /u01/oracle/ebs/db/proddata/system02.dbf
channel uax1: restore complete, elapsed time: 00:00:26
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00003 to /u01/oracle/ebs/db/proddata/system03.dbf
channel uax2: restore complete, elapsed time: 00:00:26
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00004 to /u01/oracle/ebs/db/proddata/system04.dbf
channel uax1: restore complete, elapsed time: 00:00:26
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00005 to /u01/oracle/ebs/db/proddata/system05.dbf
channel uax2: restore complete, elapsed time: 00:00:25
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00006 to /u01/oracle/ebs/db/proddata/ctxd01.dbf
channel uax2: restore complete, elapsed time: 00:00:01
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00007 to /u01/oracle/ebs/db/proddata/owad01.dbf
channel uax2: restore complete, elapsed time: 00:00:01
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00008 to /u01/oracle/ebs/db/proddata/a_queue02.dbf
channel uax1: restore complete, elapsed time: 00:00:18
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00009 to /u01/oracle/ebs/db/proddata/odm.dbf
channel uax2: restore complete, elapsed time: 00:00:15
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00010 to /u01/oracle/ebs/db/proddata/olap.dbf
channel uax1: restore complete, elapsed time: 00:00:02
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00011 to /u01/oracle/ebs/db/proddata/sysaux01.dbf
channel uax2: restore complete, elapsed time: 00:00:02
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00012 to /u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf
set newname for tempfile 3 to
"/u01/oracle/ebs/db/proddata/temp12.dbf";
set newname for tempfile 4 to
"/u01/oracle/ebs/db/proddata/temp22.dbf";
set newname for tempfile 5 to
"/u01/oracle/ebs/db/proddata/temp32.dbf";
set newname for tempfile 6 to
"/u01/oracle/ebs/db/proddata/temp42.dbf";
set newname for tempfile 7 to
"/u01/oracle/ebs/db/proddata/temp13.dbf";
set newname for tempfile 8 to
"/u01/oracle/ebs/db/proddata/temp23.dbf";
set newname for tempfile 9 to
"/u01/oracle/ebs/db/proddata/temp33.dbf";
set newname for tempfile 10 to
"/u01/oracle/ebs/db/proddata/temp43.dbf";
set newname for tempfile 11 to
"/u01/oracle/ebs/db/proddata/temp31.dbf";
set newname for tempfile 12 to
"/u01/oracle/ebs/db/proddata/temp41.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/oracle/ebs/db/proddata/system02.dbf",
"/u01/oracle/ebs/db/proddata/system03.dbf",
"/u01/oracle/ebs/db/proddata/system04.dbf",
"/u01/oracle/ebs/db/proddata/system05.dbf",
"/u01/oracle/ebs/db/proddata/ctxd01.dbf",
"/u01/oracle/ebs/db/proddata/owad01.dbf",
"/u01/oracle/ebs/db/proddata/a_queue02.dbf",
"/u01/oracle/ebs/db/proddata/odm.dbf",
"/u01/oracle/ebs/db/proddata/olap.dbf",
"/u01/oracle/ebs/db/proddata/sysaux01.dbf",
"/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf",
"/u01/oracle/ebs/db/proddata/system12.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_data04.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf",
"/u01/oracle/ebs/db/proddata/a_ref03.dbf",
"/u01/oracle/ebs/db/proddata/a_int02.dbf",
"/u01/oracle/ebs/db/proddata/sysaux02.dbf",
"/u01/oracle/ebs/db/proddata/system13.dbf",
"/u01/oracle/ebs/db/proddata/system14.dbf",
"/u01/oracle/ebs/db/proddata/system15.dbf",
"/u01/oracle/ebs/db/proddata/system16.dbf",
"/u01/oracle/ebs/db/proddata/system17.dbf",
"/u01/oracle/ebs/db/proddata/system18.dbf",
"/u01/oracle/ebs/db/proddata/system19.dbf",
"/u01/oracle/ebs/db/proddata/system20.dbf",
"/u01/oracle/ebs/db/proddata/system21.dbf",
"/u01/oracle/ebs/db/proddata/system22.dbf",
"/u01/oracle/ebs/db/proddata/system23.dbf",
"/u01/oracle/ebs/db/proddata/system24.dbf",
"/u01/oracle/ebs/db/proddata/system25.dbf",
"/u01/oracle/ebs/db/proddata/a_ref04.dbf",
"/u01/oracle/ebs/db/proddata/a_ref05.dbf",
"/u01/oracle/ebs/db/proddata/a_ref06.dbf",
"/u01/oracle/ebs/db/proddata/undo02.dbf",
"/u01/oracle/ebs/db/proddata/cux_data01.dbf",
"/u01/oracle/ebs/db/proddata/cux_ind01.dbf",
"/u01/oracle/ebs/db/proddata/undo03.dbf",
"/u01/oracle/ebs/db/proddata/undo04.dbf",
"/u01/oracle/ebs/db/proddata/undo05.dbf",
"/u01/oracle/ebs/db/proddata/a_media02.dbf",
"/u01/oracle/ebs/db/proddata/a_media03.dbf",
"/u01/oracle/ebs/db/proddata/a_media04.dbf",
"/u01/oracle/ebs/db/proddata/sysaux03.dbf",
"/u01/oracle/ebs/db/proddata/a_media05.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_data05.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_data06.dbf",
"/u01/oracle/ebs/db/proddata/a_queue03.dbf",
"/u01/oracle/ebs/db/proddata/ctxd02",
"/u01/oracle/ebs/db/proddata/a_media06.dbf",
"/u01/oracle/ebs/db/proddata/a_media07.dbf",
"/u01/oracle/ebs/db/proddata/sysaux04.dbf",
"/u01/oracle/ebs/db/proddata/a_media08.dbf",
"/u01/oracle/ebs/db/proddata/a_media09.dbf",
"/u01/oracle/ebs/db/proddata/sysaux05.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_data07.dbf",
"/u01/oracle/ebs/db/proddata/a_media10.dbf",
"/u01/oracle/ebs/db/proddata/a_media11.dbf",
"/u01/oracle/ebs/db/proddata/a_media12.dbf",
"/u01/oracle/ebs/db/proddata/a_media13.dbf",
"/u01/oracle/ebs/db/proddata/a_media14.dbf",
"/u01/oracle/ebs/db/proddata/a_media15.dbf",
"/u01/oracle/ebs/db/proddata/a_media16.dbf",
"/u01/oracle/ebs/db/proddata/a_media17.dbf",
"/u01/oracle/ebs/db/proddata/a_media18.dbf",
"/u01/oracle/ebs/db/proddata/a_queue04.dbf",
"/u01/oracle/ebs/db/proddata/a_media19.dbf",
"/u01/oracle/ebs/db/proddata/a_media20.dbf",
"/u01/oracle/ebs/db/proddata/a_media21.dbf",
"/u01/oracle/ebs/db/proddata/a_queue05.dbf",
"/u01/oracle/ebs/db/proddata/system10.dbf",
"/u01/oracle/ebs/db/proddata/system06.dbf",
"/u01/oracle/ebs/db/proddata/portal01.dbf",
"/u01/oracle/ebs/db/proddata/system07.dbf",
"/u01/oracle/ebs/db/proddata/system09.dbf",
"/u01/oracle/ebs/db/proddata/system08.dbf",
"/u01/oracle/ebs/db/proddata/system11.dbf",
"/u01/oracle/ebs/db/proddata/undo01.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_data01.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf",
"/u01/oracle/ebs/db/proddata/a_ref01.dbf",
"/u01/oracle/ebs/db/proddata/a_int01.dbf",
"/u01/oracle/ebs/db/proddata/a_summ01.dbf",
"/u01/oracle/ebs/db/proddata/a_nolog01.dbf",
"/u01/oracle/ebs/db/proddata/a_archive01.dbf",
"/u01/oracle/ebs/db/proddata/a_queue01.dbf",
"/u01/oracle/ebs/db/proddata/a_media01.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_data02.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_data03.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf",
"/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf",
"/u01/oracle/ebs/db/proddata/a_ref02.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
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u01/oracle/ebs/db/proddata/temp11.dbf in control file
renamed tempfile 2 to /u01/oracle/ebs/db/proddata/temp21.dbf in control file
renamed tempfile 3 to /u01/oracle/ebs/db/proddata/temp12.dbf in control file
renamed tempfile 4 to /u01/oracle/ebs/db/proddata/temp22.dbf in control file
renamed tempfile 5 to /u01/oracle/ebs/db/proddata/temp32.dbf in control file
renamed tempfile 6 to /u01/oracle/ebs/db/proddata/temp42.dbf in control file
renamed tempfile 7 to /u01/oracle/ebs/db/proddata/temp13.dbf in control file
renamed tempfile 8 to /u01/oracle/ebs/db/proddata/temp23.dbf in control file
renamed tempfile 9 to /u01/oracle/ebs/db/proddata/temp33.dbf in control file
renamed tempfile 10 to /u01/oracle/ebs/db/proddata/temp43.dbf in control file
renamed tempfile 11 to /u01/oracle/ebs/db/proddata/temp31.dbf in control file
renamed tempfile 12 to /u01/oracle/ebs/db/proddata/temp41.dbf in control file
....
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system02.dbf RECID=1 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system03.dbf RECID=2 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system04.dbf RECID=3 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system05.dbf RECID=4 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/ctxd01.dbf RECID=5 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/owad01.dbf RECID=6 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue02.dbf RECID=7 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/odm.dbf RECID=8 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/olap.dbf RECID=9 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux01.dbf RECID=10 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf RECID=11 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system12.dbf RECID=12 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data04.dbf RECID=13 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf RECID=14 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref03.dbf RECID=15 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_int02.dbf RECID=16 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux02.dbf RECID=17 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system13.dbf RECID=18 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system14.dbf RECID=19 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system15.dbf RECID=20 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system16.dbf RECID=21 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system17.dbf RECID=22 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system18.dbf RECID=23 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system19.dbf RECID=24 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system20.dbf RECID=25 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system21.dbf RECID=26 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system22.dbf RECID=27 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system23.dbf RECID=28 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system24.dbf RECID=29 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system25.dbf RECID=30 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref04.dbf RECID=31 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref05.dbf RECID=32 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref06.dbf RECID=33 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo02.dbf RECID=34 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/cux_data01.dbf RECID=35 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/cux_ind01.dbf RECID=36 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo03.dbf RECID=37 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo04.dbf RECID=38 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo05.dbf RECID=39 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media02.dbf RECID=40 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media03.dbf RECID=41 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media04.dbf RECID=42 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux03.dbf RECID=43 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media05.dbf RECID=44 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf RECID=45 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf RECID=46 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data05.dbf RECID=47 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data06.dbf RECID=48 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue03.dbf RECID=49 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/ctxd02 RECID=50 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media06.dbf RECID=51 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media07.dbf RECID=52 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux04.dbf RECID=53 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media08.dbf RECID=54 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media09.dbf RECID=55 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux05.dbf RECID=56 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf RECID=57 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data07.dbf RECID=58 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media10.dbf RECID=59 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media11.dbf RECID=60 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media12.dbf RECID=61 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media13.dbf RECID=62 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media14.dbf RECID=63 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media15.dbf RECID=64 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media16.dbf RECID=65 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media17.dbf RECID=66 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media18.dbf RECID=67 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue04.dbf RECID=68 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media19.dbf RECID=69 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media20.dbf RECID=70 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media21.dbf RECID=71 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue05.dbf RECID=72 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system10.dbf RECID=73 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system06.dbf RECID=74 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/portal01.dbf RECID=75 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system07.dbf RECID=76 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system09.dbf RECID=77 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system08.dbf RECID=78 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system11.dbf RECID=79 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo01.dbf RECID=80 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data01.dbf RECID=81 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf RECID=82 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref01.dbf RECID=83 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_int01.dbf RECID=84 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_summ01.dbf RECID=85 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_nolog01.dbf RECID=86 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_archive01.dbf RECID=87 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue01.dbf RECID=88 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media01.dbf RECID=89 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data02.dbf RECID=90 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data03.dbf RECID=91 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf RECID=92 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf RECID=93 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf RECID=94 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf RECID=95 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref02.dbf RECID=96 STAMP=974394850
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system02.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system03.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system04.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system05.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/ctxd01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/owad01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_queue02.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/odm.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/olap.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/sysaux01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system12.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_txn_data04.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_ref03.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_int02.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/sysaux02.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system13.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system14.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system15.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system16.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system17.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system18.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system19.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system20.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system21.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system22.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system23.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system24.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system25.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_ref04.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_ref05.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=33 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_ref06.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=34 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo02.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=35 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/cux_data01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=36 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/cux_ind01.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=37 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo03.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=38 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo04.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=39 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo05.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=40 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media02.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=41 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media03.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=42 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media04.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=43 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux03.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=44 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media05.dbf
datafile 46 switched to datafile copy
input datafile copy RECID=45 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf
datafile 47 switched to datafile copy
input datafile copy RECID=46 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=47 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data05.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=48 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data06.dbf
datafile 50 switched to datafile copy
input datafile copy RECID=49 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue03.dbf
datafile 51 switched to datafile copy
input datafile copy RECID=50 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/ctxd02
datafile 52 switched to datafile copy
input datafile copy RECID=51 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media06.dbf
datafile 53 switched to datafile copy
input datafile copy RECID=52 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media07.dbf
datafile 54 switched to datafile copy
input datafile copy RECID=53 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux04.dbf
datafile 55 switched to datafile copy
input datafile copy RECID=54 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media08.dbf
datafile 56 switched to datafile copy
input datafile copy RECID=55 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media09.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=56 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux05.dbf
datafile 58 switched to datafile copy
input datafile copy RECID=57 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf
datafile 59 switched to datafile copy
input datafile copy RECID=58 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data07.dbf
datafile 60 switched to datafile copy
input datafile copy RECID=59 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media10.dbf
datafile 61 switched to datafile copy
input datafile copy RECID=60 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media11.dbf
datafile 62 switched to datafile copy
input datafile copy RECID=61 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media12.dbf
datafile 63 switched to datafile copy
input datafile copy RECID=62 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media13.dbf
datafile 64 switched to datafile copy
input datafile copy RECID=63 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media14.dbf
datafile 65 switched to datafile copy
input datafile copy RECID=64 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media15.dbf
datafile 66 switched to datafile copy
input datafile copy RECID=65 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media16.dbf
datafile 67 switched to datafile copy
input datafile copy RECID=66 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media17.dbf
datafile 68 switched to datafile copy
input datafile copy RECID=67 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media18.dbf
datafile 69 switched to datafile copy
input datafile copy RECID=68 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue04.dbf
datafile 70 switched to datafile copy
input datafile copy RECID=69 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media19.dbf
datafile 71 switched to datafile copy
input datafile copy RECID=70 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media20.dbf
datafile 72 switched to datafile copy
input datafile copy RECID=71 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media21.dbf
datafile 73 switched to datafile copy
input datafile copy RECID=72 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue05.dbf
datafile 288 switched to datafile copy
input datafile copy RECID=73 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system10.dbf
datafile 295 switched to datafile copy
input datafile copy RECID=74 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system06.dbf
datafile 314 switched to datafile copy
input datafile copy RECID=75 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/portal01.dbf
datafile 351 switched to datafile copy
input datafile copy RECID=76 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system07.dbf
datafile 352 switched to datafile copy
input datafile copy RECID=77 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system09.dbf
datafile 353 switched to datafile copy
input datafile copy RECID=78 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/system08.dbf
datafile 354 switched to datafile copy
input datafile copy RECID=79 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/system11.dbf
datafile 379 switched to datafile copy
input datafile copy RECID=80 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/undo01.dbf
datafile 392 switched to datafile copy
input datafile copy RECID=81 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data01.dbf
datafile 393 switched to datafile copy
input datafile copy RECID=82 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf
datafile 394 switched to datafile copy
input datafile copy RECID=83 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_ref01.dbf
datafile 395 switched to datafile copy
input datafile copy RECID=84 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_int01.dbf
datafile 396 switched to datafile copy
input datafile copy RECID=85 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_summ01.dbf
datafile 397 switched to datafile copy
input datafile copy RECID=86 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_nolog01.dbf
datafile 398 switched to datafile copy
input datafile copy RECID=87 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_archive01.dbf
datafile 399 switched to datafile copy
input datafile copy RECID=88 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_queue01.dbf
datafile 400 switched to datafile copy
input datafile copy RECID=89 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_media01.dbf
datafile 401 switched to datafile copy
input datafile copy RECID=90 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data02.dbf
datafile 402 switched to datafile copy
input datafile copy RECID=91 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data03.dbf
datafile 403 switched to datafile copy
input datafile copy RECID=92 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf
datafile 404 switched to datafile copy
input datafile copy RECID=93 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf
datafile 405 switched to datafile copy
input datafile copy RECID=94 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf
datafile 406 switched to datafile copy
input datafile copy RECID=95 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf
datafile 407 switched to datafile copy
input datafile copy RECID=96 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_ref02.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 25-APR-18
released channel: p1
released channel: p2
RMAN>
--查询克隆完成后的状态
[orapbz@erptest PBZ_erptest]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 17:37:05 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
PBZ OPEN
