|
|
一、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> startup
Total System Global Area 4.2950E+10 bytes
Fixed>
Variable> 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> *.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:> Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an> 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>
Variable> 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;
> }
executing Memory Script
sql statement:>
sql statement:> Oracle instance shut down
Oracle instance started
Total System Global Area 12884901888 bytes
Fixed>
Variable> 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:
{
> }
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:> Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition> With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
PBZ OPEN
|
|
QQ群⑧：
窥视卡
雷达卡
发表于 2018-9-5 11:26:36
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡