Oracle11g到12g不支持的函数,Oracle11g 和 Oracle12c rman克隆数据库-CSDN博客

一、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

Connected to an idle instance.

SQL> startup

Total 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进行创建

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

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

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克隆

--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

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

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

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