In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
I. oracle12c rman cloning steps
1. Generate environment information query
1) instance status information
2) data file information
3) Log file information
4) Parameter file information
2. Test environment preparation:
0) installation and configuration of database software
1) pfile parameter file
2) password file
3) create related directories
4) configure static monitoring and TNS
5) start the middleware library to nomount
6) verify the user's password
7) the generation is started with spfile.
8) rman clone preparation
9) perform rman cloning
2. Specific operation of rman cloning
-- 1. Query source library information
[root@erpdb] # su-oraprod Last login: Fri Apr 20 16:56:02 CST 2018 on pts/4 [oraprod@erpdb] $sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 09:55:20 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.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.
-- query instance information
SQL > select instance_name,status from v$instance
INSTANCE_NAME STATUS
--
PROD OPEN
-- query data file information
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.
-- query log file information
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.
-- query important parameter information
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. Build target test library
Main steps:
-- 1) pfile parameter file
-(source)
Create pfile='/ora/prod/pfile/pf.ora' from spfile
$scp pfile/pf.ora orapbz@192.168.1.9:/u01/oracle/ebs/db
-(target)
A replacement path is required in pf.ora:
Oracle_base:/ora/prod/ / u01/oracle/ebs/db/
Oracle_datadir: / oradata/prod/ / u01/oracle/ebs/db/
Modify the parameters:
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
Add parameters:
* .db_file_name_convert= ('/ oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/'); if the source and target databases are the same
A host that requires configuration files to store path conversion parameters
* .log_file_name_convert= ('/ oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')
Modified 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) password file
Method 1: copy from the source library
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/
Method 2: use orapwd to create
Or
Orapwd file=/u01/oracle/ebs/db/12.1.0/dbs/orapwPBZ password=oraProd123 entries=5 format=12 force=y
On the source side:
Orapwd file=/ora/prod/12.1.0/dbs/orapwPROD password=oraProd123 entries=5 format=12 force=y
-- 3) build related catalogs
Note: the relevant directories should be the same as those saved in the pfile file
-4) configure static snooping and TNS
Cd / u01/oracle/ebs/db/12.1.0/network/admin/PBZ_erptest
-- configure static snooping
$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
-- configure 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)
)
)
-- Test 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) start the middleware library to nomount
$sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 15:03:43 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL > startup nomount pfile='/u01/oracle/ebs/db/12.1.0/dbs/initPBZ.ora'
ORACLE instance started.
Total System Global Area 1.2885E+10 bytes
Fixed Size 4511656 bytes
Variable Size 1811941464 bytes
Database Buffers 9965666304 bytes
Redo Buffers 1102782464 bytes
-- 6) verify the user password
$sqlplus sys/oraProd123@PROD as sysdba
$sqlplus sys/oraProd123@PBZ as sysdba
-- 7) the generation is started with spfile.
SQL > create spfile from pfile
-- reboot to nomount state
Shutdown immediate
Startup nomount
SQL > show parameter spfile
NAME TYPE
VALUE
-
Spfile string
/ u01/oracle/ebs/db/12.1.0/dbs/s
PfilePBZ.ora
-- configure RMAN clones
-- 8) rman cloning preparation
$rman target sys/oraProd123@PROD auxiliary sys/oraProd123@PBZ
-- 9) perform rman cloning
RMAN >
-- Oracle 11g database clone script
Duplicate target database to PBZ from active database nofilenamecheck
-- Oracle 12c database clone script
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 clone execution process
RMAN > run {
2 > allocate channel p1 type disk
3 > allocate channel p2 type disk
4 > allocate auxiliary channel uax1 type disk
5 > allocate auxiliary channel uax2 type disk
6 > duplicate target database to PBZ from active database using backupset
7 > db_file_name_convert='/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/'
8 >}
Allocated channel: p1
Channel p1: SID=1758 device type=DISK
Allocated channel: p2
Channel p2: SID=1506 device type=DISK
Allocated channel: uax1
Channel uax1: SID=1170 device type=DISK
Allocated channel: uax2
Channel uax2: SID=169 device type=DISK
Starting Duplicate Db at 25-APR-18
Current log archived
Contents of Memory Script:
{
Sql clone "alter system set db_name =
'' PROD'' comment=
'' Modified by RMAN duplicate'' scope=spfile''
Sql clone "alter system set db_unique_name =
'' PBZ'' comment=
'' Modified by RMAN duplicate'' scope=spfile''
Shutdown clone immediate
Startup clone force nomount
Restore clone from service 'PROD' primary controlfile
Alter clone database mount
}
Executing Memory Script
Sql statement: alter system set db_name =''PROD'' comment=' 'Modified by RMAN duplicate'' scope=spfile
Sql statement: alter system set db_unique_name =''PBZ'' comment=' 'Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 12884901888 bytes
Fixed Size 4511656 bytes
Variable Size 1811941464 bytes
Database Buffers 9965666304 bytes
Redo Buffers 1102782464 bytes
Allocated channel: uax1
Channel uax1: SID=169 device type=DISK
Allocated channel: uax2
Channel uax2: SID=337 device type=DISK
Starting restore at 25-APR-18
Channel uax1: starting datafile backup set restore
Channel uax1: using network backup set from service PROD
Channel uax1: restoring control file
Channel uax1: restore complete, elapsed time: 00:00:04
Output file name=/u01/oracle/ebs/db/proddata/cntrl01.dbf
Output file name=/u01/oracle/ebs/db/proddata/cntrl02.dbf
Output file name=/u01/oracle/ebs/db/proddata/cntrl03.dbf
Finished restore at 25-APR-18
Database mounted
Contents of Memory Script:
{
Set newname for datafile 1 to
"/ u01/oracle/ebs/db/proddata/system01.dbf"
Set newname for datafile 2 to
"/ u01/oracle/ebs/db/proddata/system02.dbf"
Set newname for datafile 3 to
"/ u01/oracle/ebs/db/proddata/system03.dbf"
Set newname for datafile 4 to
"/ u01/oracle/ebs/db/proddata/system04.dbf"
Set newname for datafile 5 to
"/ u01/oracle/ebs/db/proddata/system05.dbf"
Set newname for datafile 6 to
"/ u01/oracle/ebs/db/proddata/ctxd01.dbf"
Set newname for datafile 7 to
"/ u01/oracle/ebs/db/proddata/owad01.dbf"
Set newname for datafile 8 to
"/ u01/oracle/ebs/db/proddata/a_queue02.dbf"
Set newname for datafile 9 to
"/ u01/oracle/ebs/db/proddata/odm.dbf"
Set newname for datafile 10 to
"/ u01/oracle/ebs/db/proddata/olap.dbf"
Set newname for datafile 11 to
"/ u01/oracle/ebs/db/proddata/sysaux01.dbf"
Set newname for datafile 12 to
"/ u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf"
Set newname for datafile 13 to
"/ u01/oracle/ebs/db/proddata/system12.dbf"
Set newname for datafile 14 to
"/ u01/oracle/ebs/db/proddata/a_txn_data04.dbf"
Set newname for datafile 15 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind06.dbf"
Set newname for datafile 16 to
"/ u01/oracle/ebs/db/proddata/a_ref03.dbf"
Set newname for datafile 17 to
"/ u01/oracle/ebs/db/proddata/a_int02.dbf"
Set newname for datafile 18 to
"/ u01/oracle/ebs/db/proddata/sysaux02.dbf"
Set newname for datafile 19 to
"/ u01/oracle/ebs/db/proddata/system13.dbf"
Set newname for datafile 20 to
"/ u01/oracle/ebs/db/proddata/system14.dbf"
Set newname for datafile 21 to
"/ u01/oracle/ebs/db/proddata/system15.dbf"
Set newname for datafile 22 to
"/ u01/oracle/ebs/db/proddata/system16.dbf"
Set newname for datafile 23 to
"/ u01/oracle/ebs/db/proddata/system17.dbf"
Set newname for datafile 24 to
"/ u01/oracle/ebs/db/proddata/system18.dbf"
Set newname for datafile 25 to
"/ u01/oracle/ebs/db/proddata/system19.dbf"
Set newname for datafile 26 to
"/ u01/oracle/ebs/db/proddata/system20.dbf"
Set newname for datafile 27 to
"/ u01/oracle/ebs/db/proddata/system21.dbf"
Set newname for datafile 28 to
"/ u01/oracle/ebs/db/proddata/system22.dbf"
Set newname for datafile 29 to
"/ u01/oracle/ebs/db/proddata/system23.dbf"
Set newname for datafile 30 to
"/ u01/oracle/ebs/db/proddata/system24.dbf"
Set newname for datafile 31 to
"/ u01/oracle/ebs/db/proddata/system25.dbf"
Set newname for datafile 32 to
"/ u01/oracle/ebs/db/proddata/a_ref04.dbf"
Set newname for datafile 33 to
"/ u01/oracle/ebs/db/proddata/a_ref05.dbf"
Set newname for datafile 34 to
"/ u01/oracle/ebs/db/proddata/a_ref06.dbf"
Set newname for datafile 35 to
"/ u01/oracle/ebs/db/proddata/undo02.dbf"
Set newname for datafile 36 to
"/ u01/oracle/ebs/db/proddata/cux_data01.dbf"
Set newname for datafile 37 to
"/ u01/oracle/ebs/db/proddata/cux_ind01.dbf"
Set newname for datafile 38 to
"/ u01/oracle/ebs/db/proddata/undo03.dbf"
Set newname for datafile 39 to
"/ u01/oracle/ebs/db/proddata/undo04.dbf"
Set newname for datafile 40 to
"/ u01/oracle/ebs/db/proddata/undo05.dbf"
Set newname for datafile 41 to
"/ u01/oracle/ebs/db/proddata/a_media02.dbf"
Set newname for datafile 42 to
"/ u01/oracle/ebs/db/proddata/a_media03.dbf"
Set newname for datafile 43 to
"/ u01/oracle/ebs/db/proddata/a_media04.dbf"
Set newname for datafile 44 to
"/ u01/oracle/ebs/db/proddata/sysaux03.dbf"
Set newname for datafile 45 to
"/ u01/oracle/ebs/db/proddata/a_media05.dbf"
Set newname for datafile 46 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind07.dbf"
Set newname for datafile 47 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind08.dbf"
Set newname for datafile 48 to
"/ u01/oracle/ebs/db/proddata/a_txn_data05.dbf"
Set newname for datafile 49 to
"/ u01/oracle/ebs/db/proddata/a_txn_data06.dbf"
Set newname for datafile 50 to
"/ u01/oracle/ebs/db/proddata/a_queue03.dbf"
Set newname for datafile 51 to
"/ u01/oracle/ebs/db/proddata/ctxd02"
Set newname for datafile 52 to
"/ u01/oracle/ebs/db/proddata/a_media06.dbf"
Set newname for datafile 53 to
"/ u01/oracle/ebs/db/proddata/a_media07.dbf"
Set newname for datafile 54 to
"/ u01/oracle/ebs/db/proddata/sysaux04.dbf"
Set newname for datafile 55 to
"/ u01/oracle/ebs/db/proddata/a_media08.dbf"
Set newname for datafile 56 to
"/ u01/oracle/ebs/db/proddata/a_media09.dbf"
Set newname for datafile 57 to
"/ u01/oracle/ebs/db/proddata/sysaux05.dbf"
Set newname for datafile 58 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind09.dbf"
Set newname for datafile 59 to
"/ u01/oracle/ebs/db/proddata/a_txn_data07.dbf"
Set newname for datafile 60 to
"/ u01/oracle/ebs/db/proddata/a_media10.dbf"
Set newname for datafile 61 to
"/ u01/oracle/ebs/db/proddata/a_media11.dbf"
Set newname for datafile 62 to
"/ u01/oracle/ebs/db/proddata/a_media12.dbf"
Set newname for datafile 63 to
"/ u01/oracle/ebs/db/proddata/a_media13.dbf"
Set newname for datafile 64 to
"/ u01/oracle/ebs/db/proddata/a_media14.dbf"
Set newname for datafile 65 to
"/ u01/oracle/ebs/db/proddata/a_media15.dbf"
Set newname for datafile 66 to
"/ u01/oracle/ebs/db/proddata/a_media16.dbf"
Set newname for datafile 67 to
"/ u01/oracle/ebs/db/proddata/a_media17.dbf"
Set newname for datafile 68 to
"/ u01/oracle/ebs/db/proddata/a_media18.dbf"
Set newname for datafile 69 to
"/ u01/oracle/ebs/db/proddata/a_queue04.dbf"
Set newname for datafile 70 to
"/ u01/oracle/ebs/db/proddata/a_media19.dbf"
Set newname for datafile 71 to
"/ u01/oracle/ebs/db/proddata/a_media20.dbf"
Set newname for datafile 72 to
"/ u01/oracle/ebs/db/proddata/a_media21.dbf"
Set newname for datafile 73 to
"/ u01/oracle/ebs/db/proddata/a_queue05.dbf"
Set newname for datafile 288 to
"/ u01/oracle/ebs/db/proddata/system10.dbf"
Set newname for datafile 295 to
"/ u01/oracle/ebs/db/proddata/system06.dbf"
Set newname for datafile 314 to
"/ u01/oracle/ebs/db/proddata/portal01.dbf"
Set newname for datafile 351 to
"/ u01/oracle/ebs/db/proddata/system07.dbf"
Set newname for datafile 352 to
"/ u01/oracle/ebs/db/proddata/system09.dbf"
Set newname for datafile 353 to
"/ u01/oracle/ebs/db/proddata/system08.dbf"
Set newname for datafile 354 to
"/ u01/oracle/ebs/db/proddata/system11.dbf"
Set newname for datafile 379 to
"/ u01/oracle/ebs/db/proddata/undo01.dbf"
Set newname for datafile 392 to
"/ u01/oracle/ebs/db/proddata/a_txn_data01.dbf"
Set newname for datafile 393 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind01.dbf"
Set newname for datafile 394 to
"/ u01/oracle/ebs/db/proddata/a_ref01.dbf"
Set newname for datafile 395 to
"/ u01/oracle/ebs/db/proddata/a_int01.dbf"
Set newname for datafile 396 to
"/ u01/oracle/ebs/db/proddata/a_summ01.dbf"
Set newname for datafile 397 to
"/ u01/oracle/ebs/db/proddata/a_nolog01.dbf"
Set newname for datafile 398 to
"/ u01/oracle/ebs/db/proddata/a_archive01.dbf"
Set newname for datafile 399 to
"/ u01/oracle/ebs/db/proddata/a_queue01.dbf"
Set newname for datafile 400 to
"/ u01/oracle/ebs/db/proddata/a_media01.dbf"
Set newname for datafile 401 to
"/ u01/oracle/ebs/db/proddata/a_txn_data02.dbf"
Set newname for datafile 402 to
"/ u01/oracle/ebs/db/proddata/a_txn_data03.dbf"
Set newname for datafile 403 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind02.dbf"
Set newname for datafile 404 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind03.dbf"
Set newname for datafile 405 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind04.dbf"
Set newname for datafile 406 to
"/ u01/oracle/ebs/db/proddata/a_txn_ind05.dbf"
Set newname for datafile 407 to
"/ u01/oracle/ebs/db/proddata/a_ref02.dbf"
Restore
From service 'PROD' clone database
Sql 'alter system archive log current'
}
Executing Memory Script
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Starting restore at 25-APR-18
Channel uax1: starting datafile backup set restore
Channel uax1: using network backup set from service PROD
Channel uax1: specifying datafile (s) to restore from backup set
Channel uax1: restoring datafile 00001 to / u01/oracle/ebs/db/proddata/system01.dbf
Channel uax2: starting datafile backup set restore
Channel uax2: using network backup set from service PROD
Channel uax2: specifying datafile (s) to restore from backup set
Channel uax2: restoring datafile 00002 to / u01/oracle/ebs/db/proddata/system02.dbf
Channel uax1: restore complete, elapsed time: 00:00:26
Channel uax1: starting datafile backup set restore
Channel uax1: using network backup set from service PROD
Channel uax1: specifying datafile (s) to restore from backup set
Channel uax1: restoring datafile 00003 to / u01/oracle/ebs/db/proddata/system03.dbf
Channel uax2: restore complete, elapsed time: 00:00:26
Channel uax2: starting datafile backup set restore
Channel uax2: using network backup set from service PROD
Channel uax2: specifying datafile (s) to restore from backup set
Channel uax2: restoring datafile 00004 to / u01/oracle/ebs/db/proddata/system04.dbf
Channel uax1: restore complete, elapsed time: 00:00:26
Channel uax1: starting datafile backup set restore
Channel uax1: using network backup set from service PROD
Channel uax1: specifying datafile (s) to restore from backup set
Channel uax1: restoring datafile 00005 to / u01/oracle/ebs/db/proddata/system05.dbf
Channel uax2: restore complete, elapsed time: 00:00:25
Channel uax2: starting datafile backup set restore
Channel uax2: using network backup set from service PROD
Channel uax2: specifying datafile (s) to restore from backup set
Channel uax2: restoring datafile 00006 to / u01/oracle/ebs/db/proddata/ctxd01.dbf
Channel uax2: restore complete, elapsed time: 00:00:01
Channel uax2: starting datafile backup set restore
Channel uax2: using network backup set from service PROD
Channel uax2: specifying datafile (s) to restore from backup set
Channel uax2: restoring datafile 00007 to / u01/oracle/ebs/db/proddata/owad01.dbf
Channel uax2: restore complete, elapsed time: 00:00:01
Channel uax2: starting datafile backup set restore
Channel uax2: using network backup set from service PROD
Channel uax2: specifying datafile (s) to restore from backup set
Channel uax2: restoring datafile 00008 to / u01/oracle/ebs/db/proddata/a_queue02.dbf
Channel uax1: restore complete, elapsed time: 00:00:18
Channel uax1: starting datafile backup set restore
Channel uax1: using network backup set from service PROD
Channel uax1: specifying datafile (s) to restore from backup set
Channel uax1: restoring datafile 00009 to / u01/oracle/ebs/db/proddata/odm.dbf
Channel uax2: restore complete, elapsed time: 00:00:15
Channel uax2: starting datafile backup set restore
Channel uax2: using network backup set from service PROD
Channel uax2: specifying datafile (s) to restore from backup set
Channel uax2: restoring datafile 00010 to / u01/oracle/ebs/db/proddata/olap.dbf
Channel uax1: restore complete, elapsed time: 00:00:02
Channel uax1: starting datafile backup set restore
Channel uax1: using network backup set from service PROD
Channel uax1: specifying datafile (s) to restore from backup set
Channel uax1: restoring datafile 00011 to / u01/oracle/ebs/db/proddata/sysaux01.dbf
Channel uax2: restore complete, elapsed time: 00:00:02
Channel uax2: starting datafile backup set restore
Channel uax2: using network backup set from service PROD
Channel uax2: specifying datafile (s) to restore from backup set
Channel uax2: restoring datafile 00012 to / u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf
Set newname for tempfile 3 to
"/ u01/oracle/ebs/db/proddata/temp12.dbf"
Set newname for tempfile 4 to
"/ u01/oracle/ebs/db/proddata/temp22.dbf"
Set newname for tempfile 5 to
"/ u01/oracle/ebs/db/proddata/temp32.dbf"
Set newname for tempfile 6 to
"/ u01/oracle/ebs/db/proddata/temp42.dbf"
Set newname for tempfile 7 to
"/ u01/oracle/ebs/db/proddata/temp13.dbf"
Set newname for tempfile 8 to
"/ u01/oracle/ebs/db/proddata/temp23.dbf"
Set newname for tempfile 9 to
"/ u01/oracle/ebs/db/proddata/temp33.dbf"
Set newname for tempfile 10 to
"/ u01/oracle/ebs/db/proddata/temp43.dbf"
Set newname for tempfile 11 to
"/ u01/oracle/ebs/db/proddata/temp31.dbf"
Set newname for tempfile 12 to
"/ u01/oracle/ebs/db/proddata/temp41.dbf"
Switch clone tempfile all
Catalog clone datafilecopy "/ u01/oracle/ebs/db/proddata/system02.dbf"
"/ u01/oracle/ebs/db/proddata/system03.dbf"
"/ u01/oracle/ebs/db/proddata/system04.dbf"
"/ u01/oracle/ebs/db/proddata/system05.dbf"
"/ u01/oracle/ebs/db/proddata/ctxd01.dbf"
"/ u01/oracle/ebs/db/proddata/owad01.dbf"
"/ u01/oracle/ebs/db/proddata/a_queue02.dbf"
"/ u01/oracle/ebs/db/proddata/odm.dbf"
"/ u01/oracle/ebs/db/proddata/olap.dbf"
"/ u01/oracle/ebs/db/proddata/sysaux01.dbf"
"/ u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf"
"/ u01/oracle/ebs/db/proddata/system12.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_data04.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind06.dbf"
"/ u01/oracle/ebs/db/proddata/a_ref03.dbf"
"/ u01/oracle/ebs/db/proddata/a_int02.dbf"
"/ u01/oracle/ebs/db/proddata/sysaux02.dbf"
"/ u01/oracle/ebs/db/proddata/system13.dbf"
"/ u01/oracle/ebs/db/proddata/system14.dbf"
"/ u01/oracle/ebs/db/proddata/system15.dbf"
"/ u01/oracle/ebs/db/proddata/system16.dbf"
"/ u01/oracle/ebs/db/proddata/system17.dbf"
"/ u01/oracle/ebs/db/proddata/system18.dbf"
"/ u01/oracle/ebs/db/proddata/system19.dbf"
"/ u01/oracle/ebs/db/proddata/system20.dbf"
"/ u01/oracle/ebs/db/proddata/system21.dbf"
"/ u01/oracle/ebs/db/proddata/system22.dbf"
"/ u01/oracle/ebs/db/proddata/system23.dbf"
"/ u01/oracle/ebs/db/proddata/system24.dbf"
"/ u01/oracle/ebs/db/proddata/system25.dbf"
"/ u01/oracle/ebs/db/proddata/a_ref04.dbf"
"/ u01/oracle/ebs/db/proddata/a_ref05.dbf"
"/ u01/oracle/ebs/db/proddata/a_ref06.dbf"
"/ u01/oracle/ebs/db/proddata/undo02.dbf"
"/ u01/oracle/ebs/db/proddata/cux_data01.dbf"
"/ u01/oracle/ebs/db/proddata/cux_ind01.dbf"
"/ u01/oracle/ebs/db/proddata/undo03.dbf"
"/ u01/oracle/ebs/db/proddata/undo04.dbf"
"/ u01/oracle/ebs/db/proddata/undo05.dbf"
"/ u01/oracle/ebs/db/proddata/a_media02.dbf"
"/ u01/oracle/ebs/db/proddata/a_media03.dbf"
"/ u01/oracle/ebs/db/proddata/a_media04.dbf"
"/ u01/oracle/ebs/db/proddata/sysaux03.dbf"
"/ u01/oracle/ebs/db/proddata/a_media05.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind07.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind08.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_data05.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_data06.dbf"
"/ u01/oracle/ebs/db/proddata/a_queue03.dbf"
"/ u01/oracle/ebs/db/proddata/ctxd02"
"/ u01/oracle/ebs/db/proddata/a_media06.dbf"
"/ u01/oracle/ebs/db/proddata/a_media07.dbf"
"/ u01/oracle/ebs/db/proddata/sysaux04.dbf"
"/ u01/oracle/ebs/db/proddata/a_media08.dbf"
"/ u01/oracle/ebs/db/proddata/a_media09.dbf"
"/ u01/oracle/ebs/db/proddata/sysaux05.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind09.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_data07.dbf"
"/ u01/oracle/ebs/db/proddata/a_media10.dbf"
"/ u01/oracle/ebs/db/proddata/a_media11.dbf"
"/ u01/oracle/ebs/db/proddata/a_media12.dbf"
"/ u01/oracle/ebs/db/proddata/a_media13.dbf"
"/ u01/oracle/ebs/db/proddata/a_media14.dbf"
"/ u01/oracle/ebs/db/proddata/a_media15.dbf"
"/ u01/oracle/ebs/db/proddata/a_media16.dbf"
"/ u01/oracle/ebs/db/proddata/a_media17.dbf"
"/ u01/oracle/ebs/db/proddata/a_media18.dbf"
"/ u01/oracle/ebs/db/proddata/a_queue04.dbf"
"/ u01/oracle/ebs/db/proddata/a_media19.dbf"
"/ u01/oracle/ebs/db/proddata/a_media20.dbf"
"/ u01/oracle/ebs/db/proddata/a_media21.dbf"
"/ u01/oracle/ebs/db/proddata/a_queue05.dbf"
"/ u01/oracle/ebs/db/proddata/system10.dbf"
"/ u01/oracle/ebs/db/proddata/system06.dbf"
"/ u01/oracle/ebs/db/proddata/portal01.dbf"
"/ u01/oracle/ebs/db/proddata/system07.dbf"
"/ u01/oracle/ebs/db/proddata/system09.dbf"
"/ u01/oracle/ebs/db/proddata/system08.dbf"
"/ u01/oracle/ebs/db/proddata/system11.dbf"
"/ u01/oracle/ebs/db/proddata/undo01.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_data01.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind01.dbf"
"/ u01/oracle/ebs/db/proddata/a_ref01.dbf"
"/ u01/oracle/ebs/db/proddata/a_int01.dbf"
"/ u01/oracle/ebs/db/proddata/a_summ01.dbf"
"/ u01/oracle/ebs/db/proddata/a_nolog01.dbf"
"/ u01/oracle/ebs/db/proddata/a_archive01.dbf"
"/ u01/oracle/ebs/db/proddata/a_queue01.dbf"
"/ u01/oracle/ebs/db/proddata/a_media01.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_data02.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_data03.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind02.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind03.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind04.dbf"
"/ u01/oracle/ebs/db/proddata/a_txn_ind05.dbf"
"/ u01/oracle/ebs/db/proddata/a_ref02.dbf"
Switch clone datafile all
}
Executing Memory Script
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Renamed tempfile 1 to / u01/oracle/ebs/db/proddata/temp11.dbf in control file
Renamed tempfile 2 to / u01/oracle/ebs/db/proddata/temp21.dbf in control file
Renamed tempfile 3 to / u01/oracle/ebs/db/proddata/temp12.dbf in control file
Renamed tempfile 4 to / u01/oracle/ebs/db/proddata/temp22.dbf in control file
Renamed tempfile 5 to / u01/oracle/ebs/db/proddata/temp32.dbf in control file
Renamed tempfile 6 to / u01/oracle/ebs/db/proddata/temp42.dbf in control file
Renamed tempfile 7 to / u01/oracle/ebs/db/proddata/temp13.dbf in control file
Renamed tempfile 8 to / u01/oracle/ebs/db/proddata/temp23.dbf in control file
Renamed tempfile 9 to / u01/oracle/ebs/db/proddata/temp33.dbf in control file
Renamed tempfile 10 to / u01/oracle/ebs/db/proddata/temp43.dbf in control file
Renamed tempfile 11 to / u01/oracle/ebs/db/proddata/temp31.dbf in control file
Renamed tempfile 12 to / u01/oracle/ebs/db/proddata/temp41.dbf in control file
....
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system02.dbf RECID=1 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system03.dbf RECID=2 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system04.dbf RECID=3 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system05.dbf RECID=4 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/ctxd01.dbf RECID=5 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/owad01.dbf RECID=6 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue02.dbf RECID=7 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/odm.dbf RECID=8 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/olap.dbf RECID=9 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux01.dbf RECID=10 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf RECID=11 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system12.dbf RECID=12 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data04.dbf RECID=13 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf RECID=14 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref03.dbf RECID=15 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_int02.dbf RECID=16 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux02.dbf RECID=17 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system13.dbf RECID=18 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system14.dbf RECID=19 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system15.dbf RECID=20 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system16.dbf RECID=21 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system17.dbf RECID=22 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system18.dbf RECID=23 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system19.dbf RECID=24 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system20.dbf RECID=25 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system21.dbf RECID=26 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system22.dbf RECID=27 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system23.dbf RECID=28 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system24.dbf RECID=29 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system25.dbf RECID=30 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref04.dbf RECID=31 STAMP=974394848
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref05.dbf RECID=32 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref06.dbf RECID=33 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/undo02.dbf RECID=34 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/cux_data01.dbf RECID=35 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/cux_ind01.dbf RECID=36 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/undo03.dbf RECID=37 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/undo04.dbf RECID=38 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/undo05.dbf RECID=39 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media02.dbf RECID=40 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media03.dbf RECID=41 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media04.dbf RECID=42 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux03.dbf RECID=43 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media05.dbf RECID=44 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf RECID=45 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf RECID=46 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data05.dbf RECID=47 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data06.dbf RECID=48 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue03.dbf RECID=49 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/ctxd02 RECID=50 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media06.dbf RECID=51 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media07.dbf RECID=52 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux04.dbf RECID=53 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media08.dbf RECID=54 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media09.dbf RECID=55 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux05.dbf RECID=56 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf RECID=57 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data07.dbf RECID=58 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media10.dbf RECID=59 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media11.dbf RECID=60 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media12.dbf RECID=61 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media13.dbf RECID=62 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media14.dbf RECID=63 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media15.dbf RECID=64 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media16.dbf RECID=65 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media17.dbf RECID=66 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media18.dbf RECID=67 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue04.dbf RECID=68 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media19.dbf RECID=69 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media20.dbf RECID=70 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media21.dbf RECID=71 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue05.dbf RECID=72 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system10.dbf RECID=73 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system06.dbf RECID=74 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/portal01.dbf RECID=75 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system07.dbf RECID=76 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system09.dbf RECID=77 STAMP=974394849
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system08.dbf RECID=78 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/system11.dbf RECID=79 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/undo01.dbf RECID=80 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data01.dbf RECID=81 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf RECID=82 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref01.dbf RECID=83 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_int01.dbf RECID=84 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_summ01.dbf RECID=85 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_nolog01.dbf RECID=86 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_archive01.dbf RECID=87 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue01.dbf RECID=88 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_media01.dbf RECID=89 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data02.dbf RECID=90 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data03.dbf RECID=91 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf RECID=92 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf RECID=93 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf RECID=94 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf RECID=95 STAMP=974394850
Cataloged datafile copy
Datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref02.dbf RECID=96 STAMP=974394850
Datafile 2 switched to datafile copy
Input datafile copy RECID=1 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system02.dbf
Datafile 3 switched to datafile copy
Input datafile copy RECID=2 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system03.dbf
Datafile 4 switched to datafile copy
Input datafile copy RECID=3 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system04.dbf
Datafile 5 switched to datafile copy
Input datafile copy RECID=4 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system05.dbf
Datafile 6 switched to datafile copy
Input datafile copy RECID=5 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/ctxd01.dbf
Datafile 7 switched to datafile copy
Input datafile copy RECID=6 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/owad01.dbf
Datafile 8 switched to datafile copy
Input datafile copy RECID=7 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_queue02.dbf
Datafile 9 switched to datafile copy
Input datafile copy RECID=8 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/odm.dbf
Datafile 10 switched to datafile copy
Input datafile copy RECID=9 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/olap.dbf
Datafile 11 switched to datafile copy
Input datafile copy RECID=10 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/sysaux01.dbf
Datafile 12 switched to datafile copy
Input datafile copy RECID=11 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf
Datafile 13 switched to datafile copy
Input datafile copy RECID=12 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system12.dbf
Datafile 14 switched to datafile copy
Input datafile copy RECID=13 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_txn_data04.dbf
Datafile 15 switched to datafile copy
Input datafile copy RECID=14 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf
Datafile 16 switched to datafile copy
Input datafile copy RECID=15 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_ref03.dbf
Datafile 17 switched to datafile copy
Input datafile copy RECID=16 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_int02.dbf
Datafile 18 switched to datafile copy
Input datafile copy RECID=17 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/sysaux02.dbf
Datafile 19 switched to datafile copy
Input datafile copy RECID=18 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system13.dbf
Datafile 20 switched to datafile copy
Input datafile copy RECID=19 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system14.dbf
Datafile 21 switched to datafile copy
Input datafile copy RECID=20 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system15.dbf
Datafile 22 switched to datafile copy
Input datafile copy RECID=21 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system16.dbf
Datafile 23 switched to datafile copy
Input datafile copy RECID=22 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system17.dbf
Datafile 24 switched to datafile copy
Input datafile copy RECID=23 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system18.dbf
Datafile 25 switched to datafile copy
Input datafile copy RECID=24 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system19.dbf
Datafile 26 switched to datafile copy
Input datafile copy RECID=25 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system20.dbf
Datafile 27 switched to datafile copy
Input datafile copy RECID=26 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system21.dbf
Datafile 28 switched to datafile copy
Input datafile copy RECID=27 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system22.dbf
Datafile 29 switched to datafile copy
Input datafile copy RECID=28 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system23.dbf
Datafile 30 switched to datafile copy
Input datafile copy RECID=29 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system24.dbf
Datafile 31 switched to datafile copy
Input datafile copy RECID=30 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system25.dbf
Datafile 32 switched to datafile copy
Input datafile copy RECID=31 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_ref04.dbf
Datafile 33 switched to datafile copy
Input datafile copy RECID=32 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_ref05.dbf
Datafile 34 switched to datafile copy
Input datafile copy RECID=33 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_ref06.dbf
Datafile 35 switched to datafile copy
Input datafile copy RECID=34 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo02.dbf
Datafile 36 switched to datafile copy
Input datafile copy RECID=35 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/cux_data01.dbf
Datafile 37 switched to datafile copy
Input datafile copy RECID=36 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/cux_ind01.dbf
Datafile 38 switched to datafile copy
Input datafile copy RECID=37 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo03.dbf
Datafile 39 switched to datafile copy
Input datafile copy RECID=38 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo04.dbf
Datafile 40 switched to datafile copy
Input datafile copy RECID=39 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo05.dbf
Datafile 41 switched to datafile copy
Input datafile copy RECID=40 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media02.dbf
Datafile 42 switched to datafile copy
Input datafile copy RECID=41 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media03.dbf
Datafile 43 switched to datafile copy
Input datafile copy RECID=42 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media04.dbf
Datafile 44 switched to datafile copy
Input datafile copy RECID=43 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux03.dbf
Datafile 45 switched to datafile copy
Input datafile copy RECID=44 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media05.dbf
Datafile 46 switched to datafile copy
Input datafile copy RECID=45 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf
Datafile 47 switched to datafile copy
Input datafile copy RECID=46 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf
Datafile 48 switched to datafile copy
Input datafile copy RECID=47 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data05.dbf
Datafile 49 switched to datafile copy
Input datafile copy RECID=48 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data06.dbf
Datafile 50 switched to datafile copy
Input datafile copy RECID=49 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue03.dbf
Datafile 51 switched to datafile copy
Input datafile copy RECID=50 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/ctxd02
Datafile 52 switched to datafile copy
Input datafile copy RECID=51 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media06.dbf
Datafile 53 switched to datafile copy
Input datafile copy RECID=52 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media07.dbf
Datafile 54 switched to datafile copy
Input datafile copy RECID=53 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux04.dbf
Datafile 55 switched to datafile copy
Input datafile copy RECID=54 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media08.dbf
Datafile 56 switched to datafile copy
Input datafile copy RECID=55 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media09.dbf
Datafile 57 switched to datafile copy
Input datafile copy RECID=56 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux05.dbf
Datafile 58 switched to datafile copy
Input datafile copy RECID=57 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf
Datafile 59 switched to datafile copy
Input datafile copy RECID=58 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data07.dbf
Datafile 60 switched to datafile copy
Input datafile copy RECID=59 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media10.dbf
Datafile 61 switched to datafile copy
Input datafile copy RECID=60 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media11.dbf
Datafile 62 switched to datafile copy
Input datafile copy RECID=61 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media12.dbf
Datafile 63 switched to datafile copy
Input datafile copy RECID=62 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media13.dbf
Datafile 64 switched to datafile copy
Input datafile copy RECID=63 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media14.dbf
Datafile 65 switched to datafile copy
Input datafile copy RECID=64 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media15.dbf
Datafile 66 switched to datafile copy
Input datafile copy RECID=65 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media16.dbf
Datafile 67 switched to datafile copy
Input datafile copy RECID=66 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media17.dbf
Datafile 68 switched to datafile copy
Input datafile copy RECID=67 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media18.dbf
Datafile 69 switched to datafile copy
Input datafile copy RECID=68 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue04.dbf
Datafile 70 switched to datafile copy
Input datafile copy RECID=69 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media19.dbf
Datafile 71 switched to datafile copy
Input datafile copy RECID=70 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media20.dbf
Datafile 72 switched to datafile copy
Input datafile copy RECID=71 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media21.dbf
Datafile 73 switched to datafile copy
Input datafile copy RECID=72 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue05.dbf
Datafile 288 switched to datafile copy
Input datafile copy RECID=73 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system10.dbf
Datafile 295 switched to datafile copy
Input datafile copy RECID=74 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system06.dbf
Datafile 314 switched to datafile copy
Input datafile copy RECID=75 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/portal01.dbf
Datafile 351 switched to datafile copy
Input datafile copy RECID=76 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system07.dbf
Datafile 352 switched to datafile copy
Input datafile copy RECID=77 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system09.dbf
Datafile 353 switched to datafile copy
Input datafile copy RECID=78 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/system08.dbf
Datafile 354 switched to datafile copy
Input datafile copy RECID=79 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/system11.dbf
Datafile 379 switched to datafile copy
Input datafile copy RECID=80 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/undo01.dbf
Datafile 392 switched to datafile copy
Input datafile copy RECID=81 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data01.dbf
Datafile 393 switched to datafile copy
Input datafile copy RECID=82 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf
Datafile 394 switched to datafile copy
Input datafile copy RECID=83 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_ref01.dbf
Datafile 395 switched to datafile copy
Input datafile copy RECID=84 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_int01.dbf
Datafile 396 switched to datafile copy
Input datafile copy RECID=85 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_summ01.dbf
Datafile 397 switched to datafile copy
Input datafile copy RECID=86 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_nolog01.dbf
Datafile 398 switched to datafile copy
Input datafile copy RECID=87 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_archive01.dbf
Datafile 399 switched to datafile copy
Input datafile copy RECID=88 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_queue01.dbf
Datafile 400 switched to datafile copy
Input datafile copy RECID=89 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_media01.dbf
Datafile 401 switched to datafile copy
Input datafile copy RECID=90 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data02.dbf
Datafile 402 switched to datafile copy
Input datafile copy RECID=91 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data03.dbf
Datafile 403 switched to datafile copy
Input datafile copy RECID=92 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf
Datafile 404 switched to datafile copy
Input datafile copy RECID=93 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf
Datafile 405 switched to datafile copy
Input datafile copy RECID=94 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf
Datafile 406 switched to datafile copy
Input datafile copy RECID=95 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf
Datafile 407 switched to datafile copy
Input datafile copy RECID=96 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_ref02.dbf
Contents of Memory Script:
{
Alter clone database open resetlogs
}
Executing Memory Script
Database opened
Finished Duplicate Db at 25-APR-18
Released channel: p1
Released channel: p2
RMAN >
-- query the status after the clone is completed
[orapbz@erptest PBZ_erptest] $sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 17:37:05 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL > select instance_name,status from v$instance
INSTANCE_NAME STATUS
--
PBZ OPEN
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.
12
Report
