广告

扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >Oracle11g 和 Oracle12c rman克隆数据库
  • 735

0
分享到

Oracle11g 和 Oracle12c rman克隆数据库

2024-04-02 19:04:59 735人浏览 安东尼
摘要

 一、oracle12c rman克隆步骤1、生成环境信息查询1）实例状态信息2）数据文件信息3）日志文件信息4）参数文件信息2、测试环境准备：0）数据库软件安装和配置1）pfile参数文件 2）

 

一、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 Size                  3722144 bytes
Variable Size            2.6172E+10 bytes
Database Buffers         1.5569E+10 bytes
Redo Buffers             1204236288 bytes
Database mounted.
Database opened.

--查询实例信息
SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
PROD             OPEN

 

--查询数据文件信息
SQL> set pagesize 200
SQL> select file#,name from v$datafile;

     FILE# NAME
---------- ----------------------------------------
         1 /oradata/prod/proddata/system01.dbf
         2 /oradata/prod/proddata/system02.dbf
         3 /oradata/prod/proddata/system03.dbf
         4 /oradata/prod/proddata/system04.dbf
         5 /oradata/prod/proddata/system05.dbf
         6 /oradata/prod/proddata/ctxd01.dbf
         7 /oradata/prod/proddata/owad01.dbf
         8 /oradata/prod/proddata/a_queue02.dbf
         9 /oradata/prod/proddata/odm.dbf
        10 /oradata/prod/proddata/olap.dbf

        .....

       351 /oradata/prod/proddata/system07.dbf
       352 /oradata/prod/proddata/system09.dbf
       353 /oradata/prod/proddata/system08.dbf
       354 /oradata/prod/proddata/system11.dbf
       379 /oradata/prod/proddata/undo01.dbf
       392 /oradata/prod/proddata/a_txn_data01.dbf
       393 /oradata/prod/proddata/a_txn_ind01.dbf
       394 /oradata/prod/proddata/a_ref01.dbf
       395 /oradata/prod/proddata/a_int01.dbf
       396 /oradata/prod/proddata/a_summ01.dbf
       397 /oradata/prod/proddata/a_nolog01.dbf
       398 /oradata/prod/proddata/a_arcHive01.dbf
       399 /oradata/prod/proddata/a_queue01.dbf
       400 /oradata/prod/proddata/a_media01.dbf
       401 /oradata/prod/proddata/a_txn_data02.dbf
       402 /oradata/prod/proddata/a_txn_data03.dbf
       403 /oradata/prod/proddata/a_txn_ind02.dbf
       404 /oradata/prod/proddata/a_txn_ind03.dbf
       405 /oradata/prod/proddata/a_txn_ind04.dbf
       406 /oradata/prod/proddata/a_txn_ind05.dbf
       407 /oradata/prod/proddata/a_ref02.dbf

97 rows selected.

 

--查询日志文件信息
SQL> col member fORMat a40;
SQL>
SQL> select group#,member from v$logfile;

    GROUP# MEMBER
---------- ----------------------------------------
         2 /oradata/prod/proddata/log02a.dbf
         2 /oradata/prod/proddata/log02b.dbf
         1 /oradata/prod/proddata/log01a.dbf
         1 /oradata/prod/proddata/log01b.dbf
         3 /oradata/prod/proddata/log03a.dbf
         4 /oradata/prod/proddata/log04a.dbf
         5 /oradata/prod/proddata/log05a.dbf
         3 /oradata/prod/proddata/log03b.dbf
         4 /oradata/prod/proddata/log04b.dbf
         5 /oradata/prod/proddata/log05b.dbf

10 rows selected.


--查询重要参数信息
SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      PROD
db_unique_name                       string      PROD
global_names                         boolean     FALSE
instance_name                        string      PROD
lock_name_space                      string
log_file_name_convert                string
pdb_file_name_convert                string
processor_group_name                 string
service_names                        string      PROD, ebs_patch

 

--2、构建target测试库

主要步骤：

--1）pfile参数文件
--（source）
create pfile='/ora/prod/pfile/pf.ora' from spfile;
$ scp pfile/pf.ora  orapbz@192.168.1.9:/u01/oracle/ebs/db

--（target）
pf.ora中需要替换路径：
oracle_base:/ora/prod/ /u01/oracle/ebs/db/

oracle_datadir: /oradata/prod/  /u01/oracle/ebs/db/


修改参数：
cd /u01/oracle/ebs/db
vi pf.ora

%s#/ora/prod/#/u01/oracle/ebs/db/#g
%s#/oradata/prod/#/u01/oracle/ebs/db/#g
%s#/home/erp_db_rec/#/u01/oracle/ebs/db/#g
%s#/ora/prod/12.1.0/admin/PROD_erpdb#/u01/oracle/ebs/db/12.1.0/admin/PBZ_erptest#g
%s#PROD#PBZ#g
%s#/arch/prod/archive#/u01/oracle/ebs/db/archive#g
%s#erpdb#erptest#g

添加参数：
*.db_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')        ；如果源库和目标库在同

一台主机，需要配置文件存储路径转换参数
*.log_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')

修改后pf.ora
---------------------------------------------------------------------------
$ cat initPBZ.ora
*._b_tree_bitmap_plans=FALSE# Required 11i setting
*._fast_full_scan_enabled=FALSE
*._like_with_bind_as_equality=TRUE
*._optimizer_autostats_job=false# Turning off auto statistics
*._sort_elimination_cost_ratio=5
*._system_trig_enabled=TRUE
*._TRACE_FILES_PUBLIC=FALSE
*.aq_tm_processes=1
*.AUDIT_SYS_OPERATIONS=TRUE
*.compatible='12.1.0'
*.control_files='/u01/oracle/ebs/db/proddata/cntrl01.dbf','/u01/oracle/ebs/db/proddata/cntrl02.dbf','/ebs122/ER

PPBZ/db/proddata/cntrl03.dbf'
*.cursor_sharing='EXACT'# Required 11i settting
*.db_block_checking='FALSE'
*.db_block_checksum='TRUE'
*.db_block_size=8192
*.db_files=512# Max. no. of database files
*.db_name='PBZ'
*.db_recovery_file_dest_size=214748364800
*.db_recovery_file_dest='/u01/oracle/ebs/db/db_recovery_dest'
*.diagnostic_dest='/u01/oracle/ebs/db/12.1.0/admin/PBZ_erptest'
*.dml_locks=10000
*.event='1652 trace name errorstack'
*.job_queue_processes=10
*.local_listener='PBZ_LOCAL'
*.log_archive_dest_1='LOCATION=/u01/oracle/ebs/db/archive'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=1048576000
*.log_checkpoint_interval=100000
*.log_checkpoint_timeout=1200# Checkpoint at least every 20 mins.
*.log_checkpoints_to_alert=TRUE
*.max_dump_file_size='20480'# trace file size
*.nls_comp='binary'# Required 11i setting
*.nls_date_format='DD-MON-RR'
*.nls_length_semantics='BYTE'# Required 11i setting 
*.nls_numeric_characters='.,'
*.nls_sort='binary'# Required 11i setting
*.nls_territory='america'
*.o7_dictionary_accessibility=FALSE#MP
*.olap_page_pool_size=4194304
*.open_cursors=600# Consumes process memory, unless using MTS.
*.optimizer_secure_view_merging=false
*.OS_AUTHENT_PREFIX=''
*.parallel_force_local=TRUE
*.parallel_max_servers=8
*.parallel_min_servers=0
*.pga_aggregate_limit=0
*.pga_aggregate_target=10G
*.plsql_code_type='INTERPRETED'# Default 11i setting
*.processes=1000# Max. no. of users x 2
*.recyclebin='off'
*.remote_login_passWordfile='EXCLUSIVE'
*.service_names='PBZ','ebs_patch'
*.session_cached_cursors=500
*.sessions=2000# 2 X processes 
*.sga_target=12G
*.SQL92_SECURITY=TRUE
*.temp_undo_enabled=true
*.undo_management='AUTO'# Required 11i setting
*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting
*.utl_file_dir='/usr/tmp','/tmp','/u01/oracle/ebs/db/12.1.0/appsutil/outbound/PBZ_erptest','/usr/tmp'
*.workarea_size_policy='AUTO'# Required 11i setting
#.db_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')
*.log_file_name_convert=('/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/')
---------------------------------------------------------------------------------

--2）密码文件
--方法一：从source库进行拷贝
cp orapwPROD  orapwPBZ
scp orapwPBZ  orapbz@192.168.1.93:/u01/oracle/ebs/db
mv /u01/oracle/ebs/db/orapwPBZ /u01/oracle/ebs/db/12.1.0/dbs/

--方法二：使用orapwd进行创建
or
orapwd file=/u01/oracle/ebs/db/12.1.0/dbs/orapwPBZ password=oraProd123 entries=5  format=12  force=y

在source端：
orapwd file=/ora/prod/12.1.0/dbs/orapwPROD password=oraProd123 entries=5  format=12  force=y

--3）建相关的目录
注：相关目录需与pfile文件中保存一致
 
--4）配置静态监听和TNS
cd /u01/oracle/ebs/db/12.1.0/network/admin/PBZ_erptest

--配置静态监听
$ vi listener.ora

#
# $Header: ad8ilsnr.ora 120.5 2010/07/29 11:08:44 upinjark ship $
#
# ###############################################################
#
# Do not edit settings in this file manually. They are managed
# automatically and will be overwritten when AutoConfig runs.
# For more information about AutoConfig, refer to the Oracle
# E-Business Suite Setup Guide.
#
# ###############################################################

#

#
# Net8 definition for Database listener
#

PBZ =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = tcp)(HOST = erptest.dbbo.com)(PORT = 1571))
    )
  )

SID_LIST_PBZ =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME= /u01/oracle/ebs/db/12.1.0)
      (SID_NAME = PBZ)
    )
  )

STARTUP_WaiT_TIME_PBZ = 0
CONNECT_TIMEOUT_PBZ = 10
TRACE_LEVEL_PBZ = OFF

LOG_DIRECTORY_PBZ = /u01/oracle/ebs/db/12.1.0/network/admin
LOG_FILE_PBZ = PBZ
TRACE_DIRECTORY_PBZ = /u01/oracle/ebs/db/12.1.0/network/admin
TRACE_FILE_PBZ = PBZ
ADMIN_RESTRICTIONS_PBZ = ON
SUBSCRIBE_FOR_node_DOWN_EVENT_PBZ = OFF
-----------------------------------------------------------


--配置tns
cat tnsnames.ora
PBZ=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=erptest.dbbo.com)(PORT=1571))
            (CONNECT_DATA=
                (SERVICE_NAME=PBZ)
                (INSTANCE_NAME=PBZ)
            )
        )

PROD=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.213)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME=PROD)
                (INSTANCE_NAME=PROD)
            )
        )
-------------------------------------------------------------- 

--测试tns
 
$ tnsping PROD

TNS Ping Utility for linux: Version 12.1.0.2.0 - Production on 25-APR-2018 14:39:00

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
/u01/oracle/ebs/db/12.1.0/network/admin/PBZ_erptest/sqlnet_ifile.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.213)(PORT=1521)) (CONNECT_DATA=

(SERVICE_NAME=PROD) (INSTANCE_NAME=PROD)))
OK (0 msec)


--5）启动中间件库到nomount
$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 15:03:43 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount  pfile='/u01/oracle/ebs/db/12.1.0/dbs/initPBZ.ora';
ORACLE instance started.

Total System Global Area 1.2885E+10 bytes
Fixed Size                  4511656 bytes
Variable Size            1811941464 bytes
Database Buffers         9965666304 bytes
Redo Buffers             1102782464 bytes


--6）验证用户密码
$ sqlplus sys/oraProd123@PROD as sysdba

$ sqlplus sys/oraProd123@PBZ as sysdba


--7）生成用spfile启动。
SQL> create spfile from pfile;

--重新启动到nomount状态
shutdown immediate;
startup nomount;

SQL> show parameter spfile;

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
spfile                               string
/u01/oracle/ebs/db/12.1.0/dbs/s
pfilePBZ.ora

--配置RMAN克隆

--8）rman克隆准备
$rman target sys/oraProd123@PROD auxiliary sys/oraProd123@PBZ

--9）执行rman克隆
RMAN>
--Oracle 11g 数据库克隆脚本
duplicate target database to PBZ from active database nofilenamecheck;

--Oracle 12c 数据库克隆脚本

run{
allocate channel prm1 type disk;
allocate channel prm2 type disk;
allocate auxiliary channel uax1 type disk;
allocate auxiliary channel uax2 type disk;
duplicate target database to PBZ from active database using backupset
db_file_name_convert='/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/';
}


--10)rman克隆执行过程
RMAN> run{
2> allocate channel p1 type disk;
3> allocate channel p2 type disk;
4> allocate auxiliary channel uax1 type disk;
5> allocate auxiliary channel uax2 type disk;
6> duplicate target database to PBZ from active database using backupset
7> db_file_name_convert='/oradata/prod/proddata/','/u01/oracle/ebs/db/proddata/';
8> }

allocated channel: p1
channel p1: SID=1758 device type=DISK

allocated channel: p2
channel p2: SID=1506 device type=DISK

allocated channel: uax1
channel uax1: SID=1170 device type=DISK

allocated channel: uax2
channel uax2: SID=169 device type=DISK

Starting Duplicate Db at 25-APR-18
current log archived

contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''PROD'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''PBZ'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone from service  'PROD' primary controlfile;
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''PBZ'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area   12884901888 bytes

Fixed Size                     4511656 bytes
Variable Size               1811941464 bytes
Database Buffers            9965666304 bytes
Redo Buffers                1102782464 bytes
allocated channel: uax1
channel uax1: SID=169 device type=DISK
allocated channel: uax2
channel uax2: SID=337 device type=DISK

Starting restore at 25-APR-18

channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: restoring control file
channel uax1: restore complete, elapsed time: 00:00:04
output file name=/u01/oracle/ebs/db/proddata/cntrl01.dbf
output file name=/u01/oracle/ebs/db/proddata/cntrl02.dbf
output file name=/u01/oracle/ebs/db/proddata/cntrl03.dbf
Finished restore at 25-APR-18

database mounted

contents of Memory Script:
{
   set newname for datafile  1 to
 "/u01/oracle/ebs/db/proddata/system01.dbf";
   set newname for datafile  2 to
 "/u01/oracle/ebs/db/proddata/system02.dbf";
   set newname for datafile  3 to
 "/u01/oracle/ebs/db/proddata/system03.dbf";
   set newname for datafile  4 to
 "/u01/oracle/ebs/db/proddata/system04.dbf";
   set newname for datafile  5 to
 "/u01/oracle/ebs/db/proddata/system05.dbf";
   set newname for datafile  6 to
 "/u01/oracle/ebs/db/proddata/ctxd01.dbf";
   set newname for datafile  7 to
 "/u01/oracle/ebs/db/proddata/owad01.dbf";
   set newname for datafile  8 to
 "/u01/oracle/ebs/db/proddata/a_queue02.dbf";
   set newname for datafile  9 to
 "/u01/oracle/ebs/db/proddata/odm.dbf";
   set newname for datafile  10 to
 "/u01/oracle/ebs/db/proddata/olap.dbf";
   set newname for datafile  11 to
 "/u01/oracle/ebs/db/proddata/sysaux01.dbf";
   set newname for datafile  12 to
 "/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf";
   set newname for datafile  13 to
 "/u01/oracle/ebs/db/proddata/system12.dbf";
   set newname for datafile  14 to
 "/u01/oracle/ebs/db/proddata/a_txn_data04.dbf";
   set newname for datafile  15 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf";
   set newname for datafile  16 to
 "/u01/oracle/ebs/db/proddata/a_ref03.dbf";
   set newname for datafile  17 to
 "/u01/oracle/ebs/db/proddata/a_int02.dbf";
   set newname for datafile  18 to
 "/u01/oracle/ebs/db/proddata/sysaux02.dbf";
   set newname for datafile  19 to
 "/u01/oracle/ebs/db/proddata/system13.dbf";
   set newname for datafile  20 to
 "/u01/oracle/ebs/db/proddata/system14.dbf";
   set newname for datafile  21 to
 "/u01/oracle/ebs/db/proddata/system15.dbf";
   set newname for datafile  22 to
 "/u01/oracle/ebs/db/proddata/system16.dbf";
   set newname for datafile  23 to
 "/u01/oracle/ebs/db/proddata/system17.dbf";
   set newname for datafile  24 to
 "/u01/oracle/ebs/db/proddata/system18.dbf";
   set newname for datafile  25 to
 "/u01/oracle/ebs/db/proddata/system19.dbf";
   set newname for datafile  26 to
 "/u01/oracle/ebs/db/proddata/system20.dbf";
   set newname for datafile  27 to
 "/u01/oracle/ebs/db/proddata/system21.dbf";
   set newname for datafile  28 to
 "/u01/oracle/ebs/db/proddata/system22.dbf";
   set newname for datafile  29 to
 "/u01/oracle/ebs/db/proddata/system23.dbf";
   set newname for datafile  30 to
 "/u01/oracle/ebs/db/proddata/system24.dbf";
   set newname for datafile  31 to
 "/u01/oracle/ebs/db/proddata/system25.dbf";
   set newname for datafile  32 to
 "/u01/oracle/ebs/db/proddata/a_ref04.dbf";
   set newname for datafile  33 to
 "/u01/oracle/ebs/db/proddata/a_ref05.dbf";
   set newname for datafile  34 to
 "/u01/oracle/ebs/db/proddata/a_ref06.dbf";
   set newname for datafile  35 to
 "/u01/oracle/ebs/db/proddata/undo02.dbf";
   set newname for datafile  36 to
 "/u01/oracle/ebs/db/proddata/cux_data01.dbf";
   set newname for datafile  37 to
 "/u01/oracle/ebs/db/proddata/cux_ind01.dbf";
   set newname for datafile  38 to
 "/u01/oracle/ebs/db/proddata/undo03.dbf";
   set newname for datafile  39 to
 "/u01/oracle/ebs/db/proddata/undo04.dbf";
   set newname for datafile  40 to
 "/u01/oracle/ebs/db/proddata/undo05.dbf";
   set newname for datafile  41 to
 "/u01/oracle/ebs/db/proddata/a_media02.dbf";
   set newname for datafile  42 to
 "/u01/oracle/ebs/db/proddata/a_media03.dbf";
   set newname for datafile  43 to
 "/u01/oracle/ebs/db/proddata/a_media04.dbf";
   set newname for datafile  44 to
 "/u01/oracle/ebs/db/proddata/sysaux03.dbf";
   set newname for datafile  45 to
 "/u01/oracle/ebs/db/proddata/a_media05.dbf";
   set newname for datafile  46 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf";
   set newname for datafile  47 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf";
   set newname for datafile  48 to
 "/u01/oracle/ebs/db/proddata/a_txn_data05.dbf";
   set newname for datafile  49 to
 "/u01/oracle/ebs/db/proddata/a_txn_data06.dbf";
   set newname for datafile  50 to
 "/u01/oracle/ebs/db/proddata/a_queue03.dbf";
   set newname for datafile  51 to
 "/u01/oracle/ebs/db/proddata/ctxd02";
   set newname for datafile  52 to
 "/u01/oracle/ebs/db/proddata/a_media06.dbf";
   set newname for datafile  53 to
 "/u01/oracle/ebs/db/proddata/a_media07.dbf";
   set newname for datafile  54 to
 "/u01/oracle/ebs/db/proddata/sysaux04.dbf";
   set newname for datafile  55 to
 "/u01/oracle/ebs/db/proddata/a_media08.dbf";
   set newname for datafile  56 to
 "/u01/oracle/ebs/db/proddata/a_media09.dbf";
   set newname for datafile  57 to
 "/u01/oracle/ebs/db/proddata/sysaux05.dbf";
   set newname for datafile  58 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf";
   set newname for datafile  59 to
 "/u01/oracle/ebs/db/proddata/a_txn_data07.dbf";
   set newname for datafile  60 to
 "/u01/oracle/ebs/db/proddata/a_media10.dbf";
   set newname for datafile  61 to
 "/u01/oracle/ebs/db/proddata/a_media11.dbf";
   set newname for datafile  62 to
 "/u01/oracle/ebs/db/proddata/a_media12.dbf";
   set newname for datafile  63 to
 "/u01/oracle/ebs/db/proddata/a_media13.dbf";
   set newname for datafile  64 to
 "/u01/oracle/ebs/db/proddata/a_media14.dbf";
   set newname for datafile  65 to
 "/u01/oracle/ebs/db/proddata/a_media15.dbf";
   set newname for datafile  66 to
 "/u01/oracle/ebs/db/proddata/a_media16.dbf";
   set newname for datafile  67 to
 "/u01/oracle/ebs/db/proddata/a_media17.dbf";
   set newname for datafile  68 to
 "/u01/oracle/ebs/db/proddata/a_media18.dbf";
   set newname for datafile  69 to
 "/u01/oracle/ebs/db/proddata/a_queue04.dbf";
   set newname for datafile  70 to
 "/u01/oracle/ebs/db/proddata/a_media19.dbf";
   set newname for datafile  71 to
 "/u01/oracle/ebs/db/proddata/a_media20.dbf";
   set newname for datafile  72 to
 "/u01/oracle/ebs/db/proddata/a_media21.dbf";
   set newname for datafile  73 to
 "/u01/oracle/ebs/db/proddata/a_queue05.dbf";
   set newname for datafile  288 to
 "/u01/oracle/ebs/db/proddata/system10.dbf";
   set newname for datafile  295 to
 "/u01/oracle/ebs/db/proddata/system06.dbf";
   set newname for datafile  314 to
 "/u01/oracle/ebs/db/proddata/portal01.dbf";
   set newname for datafile  351 to
 "/u01/oracle/ebs/db/proddata/system07.dbf";
   set newname for datafile  352 to
 "/u01/oracle/ebs/db/proddata/system09.dbf";
   set newname for datafile  353 to
 "/u01/oracle/ebs/db/proddata/system08.dbf";
   set newname for datafile  354 to
 "/u01/oracle/ebs/db/proddata/system11.dbf";
   set newname for datafile  379 to
 "/u01/oracle/ebs/db/proddata/undo01.dbf";
   set newname for datafile  392 to
 "/u01/oracle/ebs/db/proddata/a_txn_data01.dbf";
   set newname for datafile  393 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf";
   set newname for datafile  394 to
 "/u01/oracle/ebs/db/proddata/a_ref01.dbf";
   set newname for datafile  395 to
 "/u01/oracle/ebs/db/proddata/a_int01.dbf";
   set newname for datafile  396 to
 "/u01/oracle/ebs/db/proddata/a_summ01.dbf";
   set newname for datafile  397 to
 "/u01/oracle/ebs/db/proddata/a_nolog01.dbf";
   set newname for datafile  398 to
 "/u01/oracle/ebs/db/proddata/a_archive01.dbf";
   set newname for datafile  399 to
 "/u01/oracle/ebs/db/proddata/a_queue01.dbf";
   set newname for datafile  400 to
 "/u01/oracle/ebs/db/proddata/a_media01.dbf";
   set newname for datafile  401 to
 "/u01/oracle/ebs/db/proddata/a_txn_data02.dbf";
   set newname for datafile  402 to
 "/u01/oracle/ebs/db/proddata/a_txn_data03.dbf";
   set newname for datafile  403 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf";
   set newname for datafile  404 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf";
   set newname for datafile  405 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf";
   set newname for datafile  406 to
 "/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf";
   set newname for datafile  407 to
 "/u01/oracle/ebs/db/proddata/a_ref02.dbf";
   restore
   from service  'PROD'   clone database
   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 25-APR-18

channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00001 to /u01/oracle/ebs/db/proddata/system01.dbf
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00002 to /u01/oracle/ebs/db/proddata/system02.dbf
channel uax1: restore complete, elapsed time: 00:00:26
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00003 to /u01/oracle/ebs/db/proddata/system03.dbf
channel uax2: restore complete, elapsed time: 00:00:26
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00004 to /u01/oracle/ebs/db/proddata/system04.dbf
channel uax1: restore complete, elapsed time: 00:00:26
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00005 to /u01/oracle/ebs/db/proddata/system05.dbf
channel uax2: restore complete, elapsed time: 00:00:25
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00006 to /u01/oracle/ebs/db/proddata/ctxd01.dbf
channel uax2: restore complete, elapsed time: 00:00:01
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00007 to /u01/oracle/ebs/db/proddata/owad01.dbf
channel uax2: restore complete, elapsed time: 00:00:01
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00008 to /u01/oracle/ebs/db/proddata/a_queue02.dbf
channel uax1: restore complete, elapsed time: 00:00:18
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00009 to /u01/oracle/ebs/db/proddata/odm.dbf
channel uax2: restore complete, elapsed time: 00:00:15
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00010 to /u01/oracle/ebs/db/proddata/olap.dbf
channel uax1: restore complete, elapsed time: 00:00:02
channel uax1: starting datafile backup set restore
channel uax1: using network backup set from service PROD
channel uax1: specifying datafile(s) to restore from backup set
channel uax1: restoring datafile 00011 to /u01/oracle/ebs/db/proddata/sysaux01.dbf
channel uax2: restore complete, elapsed time: 00:00:02
channel uax2: starting datafile backup set restore
channel uax2: using network backup set from service PROD
channel uax2: specifying datafile(s) to restore from backup set
channel uax2: restoring datafile 00012 to /u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf
set newname for tempfile  3 to
 "/u01/oracle/ebs/db/proddata/temp12.dbf";
   set newname for tempfile  4 to
 "/u01/oracle/ebs/db/proddata/temp22.dbf";
   set newname for tempfile  5 to
 "/u01/oracle/ebs/db/proddata/temp32.dbf";
   set newname for tempfile  6 to
 "/u01/oracle/ebs/db/proddata/temp42.dbf";
   set newname for tempfile  7 to
 "/u01/oracle/ebs/db/proddata/temp13.dbf";
   set newname for tempfile  8 to
 "/u01/oracle/ebs/db/proddata/temp23.dbf";
   set newname for tempfile  9 to
 "/u01/oracle/ebs/db/proddata/temp33.dbf";
   set newname for tempfile  10 to
 "/u01/oracle/ebs/db/proddata/temp43.dbf";
   set newname for tempfile  11 to
 "/u01/oracle/ebs/db/proddata/temp31.dbf";
   set newname for tempfile  12 to
 "/u01/oracle/ebs/db/proddata/temp41.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "/u01/oracle/ebs/db/proddata/system02.dbf",
 "/u01/oracle/ebs/db/proddata/system03.dbf",
 "/u01/oracle/ebs/db/proddata/system04.dbf",
 "/u01/oracle/ebs/db/proddata/system05.dbf",
 "/u01/oracle/ebs/db/proddata/ctxd01.dbf",
 "/u01/oracle/ebs/db/proddata/owad01.dbf",
 "/u01/oracle/ebs/db/proddata/a_queue02.dbf",
 "/u01/oracle/ebs/db/proddata/odm.dbf",
 "/u01/oracle/ebs/db/proddata/olap.dbf",
 "/u01/oracle/ebs/db/proddata/sysaux01.dbf",
 "/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf",
 "/u01/oracle/ebs/db/proddata/system12.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_data04.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf",
 "/u01/oracle/ebs/db/proddata/a_ref03.dbf",
 "/u01/oracle/ebs/db/proddata/a_int02.dbf",
 "/u01/oracle/ebs/db/proddata/sysaux02.dbf",
 "/u01/oracle/ebs/db/proddata/system13.dbf",
 "/u01/oracle/ebs/db/proddata/system14.dbf",
 "/u01/oracle/ebs/db/proddata/system15.dbf",
 "/u01/oracle/ebs/db/proddata/system16.dbf",
 "/u01/oracle/ebs/db/proddata/system17.dbf",
 "/u01/oracle/ebs/db/proddata/system18.dbf",
 "/u01/oracle/ebs/db/proddata/system19.dbf",
 "/u01/oracle/ebs/db/proddata/system20.dbf",
 "/u01/oracle/ebs/db/proddata/system21.dbf",
 "/u01/oracle/ebs/db/proddata/system22.dbf",
 "/u01/oracle/ebs/db/proddata/system23.dbf",
 "/u01/oracle/ebs/db/proddata/system24.dbf",
 "/u01/oracle/ebs/db/proddata/system25.dbf",
 "/u01/oracle/ebs/db/proddata/a_ref04.dbf",
 "/u01/oracle/ebs/db/proddata/a_ref05.dbf",
 "/u01/oracle/ebs/db/proddata/a_ref06.dbf",
 "/u01/oracle/ebs/db/proddata/undo02.dbf",
 "/u01/oracle/ebs/db/proddata/cux_data01.dbf",
 "/u01/oracle/ebs/db/proddata/cux_ind01.dbf",
 "/u01/oracle/ebs/db/proddata/undo03.dbf",
 "/u01/oracle/ebs/db/proddata/undo04.dbf",
 "/u01/oracle/ebs/db/proddata/undo05.dbf",
 "/u01/oracle/ebs/db/proddata/a_media02.dbf",
 "/u01/oracle/ebs/db/proddata/a_media03.dbf",
 "/u01/oracle/ebs/db/proddata/a_media04.dbf",
 "/u01/oracle/ebs/db/proddata/sysaux03.dbf",
 "/u01/oracle/ebs/db/proddata/a_media05.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_data05.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_data06.dbf",
 "/u01/oracle/ebs/db/proddata/a_queue03.dbf",
 "/u01/oracle/ebs/db/proddata/ctxd02",
 "/u01/oracle/ebs/db/proddata/a_media06.dbf",
 "/u01/oracle/ebs/db/proddata/a_media07.dbf",
 "/u01/oracle/ebs/db/proddata/sysaux04.dbf",
 "/u01/oracle/ebs/db/proddata/a_media08.dbf",
 "/u01/oracle/ebs/db/proddata/a_media09.dbf",
 "/u01/oracle/ebs/db/proddata/sysaux05.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_data07.dbf",
 "/u01/oracle/ebs/db/proddata/a_media10.dbf",
 "/u01/oracle/ebs/db/proddata/a_media11.dbf",
 "/u01/oracle/ebs/db/proddata/a_media12.dbf",
 "/u01/oracle/ebs/db/proddata/a_media13.dbf",
 "/u01/oracle/ebs/db/proddata/a_media14.dbf",
 "/u01/oracle/ebs/db/proddata/a_media15.dbf",
 "/u01/oracle/ebs/db/proddata/a_media16.dbf",
 "/u01/oracle/ebs/db/proddata/a_media17.dbf",
 "/u01/oracle/ebs/db/proddata/a_media18.dbf",
 "/u01/oracle/ebs/db/proddata/a_queue04.dbf",
 "/u01/oracle/ebs/db/proddata/a_media19.dbf",
 "/u01/oracle/ebs/db/proddata/a_media20.dbf",
 "/u01/oracle/ebs/db/proddata/a_media21.dbf",
 "/u01/oracle/ebs/db/proddata/a_queue05.dbf",
 "/u01/oracle/ebs/db/proddata/system10.dbf",
 "/u01/oracle/ebs/db/proddata/system06.dbf",
 "/u01/oracle/ebs/db/proddata/portal01.dbf",
 "/u01/oracle/ebs/db/proddata/system07.dbf",
 "/u01/oracle/ebs/db/proddata/system09.dbf",
 "/u01/oracle/ebs/db/proddata/system08.dbf",
 "/u01/oracle/ebs/db/proddata/system11.dbf",
 "/u01/oracle/ebs/db/proddata/undo01.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_data01.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf",
 "/u01/oracle/ebs/db/proddata/a_ref01.dbf",
 "/u01/oracle/ebs/db/proddata/a_int01.dbf",
 "/u01/oracle/ebs/db/proddata/a_summ01.dbf",
 "/u01/oracle/ebs/db/proddata/a_nolog01.dbf",
 "/u01/oracle/ebs/db/proddata/a_archive01.dbf",
 "/u01/oracle/ebs/db/proddata/a_queue01.dbf",
 "/u01/oracle/ebs/db/proddata/a_media01.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_data02.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_data03.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf",
 "/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf",
 "/u01/oracle/ebs/db/proddata/a_ref02.dbf";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /u01/oracle/ebs/db/proddata/temp11.dbf in control file
renamed tempfile 2 to /u01/oracle/ebs/db/proddata/temp21.dbf in control file
renamed tempfile 3 to /u01/oracle/ebs/db/proddata/temp12.dbf in control file
renamed tempfile 4 to /u01/oracle/ebs/db/proddata/temp22.dbf in control file
renamed tempfile 5 to /u01/oracle/ebs/db/proddata/temp32.dbf in control file
renamed tempfile 6 to /u01/oracle/ebs/db/proddata/temp42.dbf in control file
renamed tempfile 7 to /u01/oracle/ebs/db/proddata/temp13.dbf in control file
renamed tempfile 8 to /u01/oracle/ebs/db/proddata/temp23.dbf in control file
renamed tempfile 9 to /u01/oracle/ebs/db/proddata/temp33.dbf in control file
renamed tempfile 10 to /u01/oracle/ebs/db/proddata/temp43.dbf in control file
renamed tempfile 11 to /u01/oracle/ebs/db/proddata/temp31.dbf in control file
renamed tempfile 12 to /u01/oracle/ebs/db/proddata/temp41.dbf in control file

....

cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system02.dbf RECID=1 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system03.dbf RECID=2 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system04.dbf RECID=3 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system05.dbf RECID=4 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/ctxd01.dbf RECID=5 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/owad01.dbf RECID=6 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue02.dbf RECID=7 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/odm.dbf RECID=8 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/olap.dbf RECID=9 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux01.dbf RECID=10 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf RECID=11 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system12.dbf RECID=12 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data04.dbf RECID=13 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf RECID=14 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref03.dbf RECID=15 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_int02.dbf RECID=16 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux02.dbf RECID=17 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system13.dbf RECID=18 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system14.dbf RECID=19 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system15.dbf RECID=20 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system16.dbf RECID=21 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system17.dbf RECID=22 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system18.dbf RECID=23 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system19.dbf RECID=24 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system20.dbf RECID=25 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system21.dbf RECID=26 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system22.dbf RECID=27 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system23.dbf RECID=28 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system24.dbf RECID=29 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system25.dbf RECID=30 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref04.dbf RECID=31 STAMP=974394848
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref05.dbf RECID=32 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref06.dbf RECID=33 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo02.dbf RECID=34 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/cux_data01.dbf RECID=35 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/cux_ind01.dbf RECID=36 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo03.dbf RECID=37 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo04.dbf RECID=38 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo05.dbf RECID=39 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media02.dbf RECID=40 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media03.dbf RECID=41 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media04.dbf RECID=42 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux03.dbf RECID=43 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media05.dbf RECID=44 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf RECID=45 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf RECID=46 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data05.dbf RECID=47 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data06.dbf RECID=48 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue03.dbf RECID=49 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/ctxd02 RECID=50 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media06.dbf RECID=51 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media07.dbf RECID=52 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux04.dbf RECID=53 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media08.dbf RECID=54 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media09.dbf RECID=55 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/sysaux05.dbf RECID=56 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf RECID=57 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data07.dbf RECID=58 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media10.dbf RECID=59 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media11.dbf RECID=60 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media12.dbf RECID=61 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media13.dbf RECID=62 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media14.dbf RECID=63 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media15.dbf RECID=64 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media16.dbf RECID=65 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media17.dbf RECID=66 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media18.dbf RECID=67 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue04.dbf RECID=68 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media19.dbf RECID=69 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media20.dbf RECID=70 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media21.dbf RECID=71 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue05.dbf RECID=72 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system10.dbf RECID=73 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system06.dbf RECID=74 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/portal01.dbf RECID=75 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system07.dbf RECID=76 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system09.dbf RECID=77 STAMP=974394849
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system08.dbf RECID=78 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/system11.dbf RECID=79 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/undo01.dbf RECID=80 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data01.dbf RECID=81 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf RECID=82 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref01.dbf RECID=83 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_int01.dbf RECID=84 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_summ01.dbf RECID=85 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_nolog01.dbf RECID=86 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_archive01.dbf RECID=87 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_queue01.dbf RECID=88 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_media01.dbf RECID=89 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data02.dbf RECID=90 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_data03.dbf RECID=91 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf RECID=92 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf RECID=93 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf RECID=94 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf RECID=95 STAMP=974394850
cataloged datafile copy
datafile copy file name=/u01/oracle/ebs/db/proddata/a_ref02.dbf RECID=96 STAMP=974394850

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system02.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system03.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system04.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system05.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/ctxd01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/owad01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_queue02.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/odm.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/olap.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/sysaux01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/apps_ts_tools01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system12.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_txn_data04.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_txn_ind06.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_ref03.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_int02.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/sysaux02.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system13.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system14.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system15.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system16.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system17.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system18.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system19.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system20.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system21.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system22.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system23.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system24.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/system25.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=974394848 file name=/u01/oracle/ebs/db/proddata/a_ref04.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_ref05.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=33 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_ref06.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=34 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo02.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=35 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/cux_data01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=36 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/cux_ind01.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=37 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo03.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=38 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo04.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=39 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/undo05.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=40 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media02.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=41 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media03.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=42 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media04.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=43 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux03.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=44 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media05.dbf
datafile 46 switched to datafile copy
input datafile copy RECID=45 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind07.dbf
datafile 47 switched to datafile copy
input datafile copy RECID=46 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind08.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=47 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data05.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=48 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data06.dbf
datafile 50 switched to datafile copy
input datafile copy RECID=49 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue03.dbf
datafile 51 switched to datafile copy
input datafile copy RECID=50 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/ctxd02
datafile 52 switched to datafile copy
input datafile copy RECID=51 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media06.dbf
datafile 53 switched to datafile copy
input datafile copy RECID=52 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media07.dbf
datafile 54 switched to datafile copy
input datafile copy RECID=53 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux04.dbf
datafile 55 switched to datafile copy
input datafile copy RECID=54 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media08.dbf
datafile 56 switched to datafile copy
input datafile copy RECID=55 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media09.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=56 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/sysaux05.dbf
datafile 58 switched to datafile copy
input datafile copy RECID=57 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_ind09.dbf
datafile 59 switched to datafile copy
input datafile copy RECID=58 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_txn_data07.dbf
datafile 60 switched to datafile copy
input datafile copy RECID=59 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media10.dbf
datafile 61 switched to datafile copy
input datafile copy RECID=60 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media11.dbf
datafile 62 switched to datafile copy
input datafile copy RECID=61 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media12.dbf
datafile 63 switched to datafile copy
input datafile copy RECID=62 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media13.dbf
datafile 64 switched to datafile copy
input datafile copy RECID=63 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media14.dbf
datafile 65 switched to datafile copy
input datafile copy RECID=64 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media15.dbf
datafile 66 switched to datafile copy
input datafile copy RECID=65 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media16.dbf
datafile 67 switched to datafile copy
input datafile copy RECID=66 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media17.dbf
datafile 68 switched to datafile copy
input datafile copy RECID=67 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media18.dbf
datafile 69 switched to datafile copy
input datafile copy RECID=68 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue04.dbf
datafile 70 switched to datafile copy
input datafile copy RECID=69 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media19.dbf
datafile 71 switched to datafile copy
input datafile copy RECID=70 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media20.dbf
datafile 72 switched to datafile copy
input datafile copy RECID=71 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_media21.dbf
datafile 73 switched to datafile copy
input datafile copy RECID=72 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/a_queue05.dbf
datafile 288 switched to datafile copy
input datafile copy RECID=73 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system10.dbf
datafile 295 switched to datafile copy
input datafile copy RECID=74 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system06.dbf
datafile 314 switched to datafile copy
input datafile copy RECID=75 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/portal01.dbf
datafile 351 switched to datafile copy
input datafile copy RECID=76 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system07.dbf
datafile 352 switched to datafile copy
input datafile copy RECID=77 STAMP=974394849 file name=/u01/oracle/ebs/db/proddata/system09.dbf
datafile 353 switched to datafile copy
input datafile copy RECID=78 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/system08.dbf
datafile 354 switched to datafile copy
input datafile copy RECID=79 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/system11.dbf
datafile 379 switched to datafile copy
input datafile copy RECID=80 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/undo01.dbf
datafile 392 switched to datafile copy
input datafile copy RECID=81 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data01.dbf
datafile 393 switched to datafile copy
input datafile copy RECID=82 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind01.dbf
datafile 394 switched to datafile copy
input datafile copy RECID=83 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_ref01.dbf
datafile 395 switched to datafile copy
input datafile copy RECID=84 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_int01.dbf
datafile 396 switched to datafile copy
input datafile copy RECID=85 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_summ01.dbf
datafile 397 switched to datafile copy
input datafile copy RECID=86 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_nolog01.dbf
datafile 398 switched to datafile copy
input datafile copy RECID=87 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_archive01.dbf
datafile 399 switched to datafile copy
input datafile copy RECID=88 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_queue01.dbf
datafile 400 switched to datafile copy
input datafile copy RECID=89 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_media01.dbf
datafile 401 switched to datafile copy
input datafile copy RECID=90 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data02.dbf
datafile 402 switched to datafile copy
input datafile copy RECID=91 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_data03.dbf
datafile 403 switched to datafile copy
input datafile copy RECID=92 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind02.dbf
datafile 404 switched to datafile copy
input datafile copy RECID=93 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind03.dbf
datafile 405 switched to datafile copy
input datafile copy RECID=94 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind04.dbf
datafile 406 switched to datafile copy
input datafile copy RECID=95 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_txn_ind05.dbf
datafile 407 switched to datafile copy
input datafile copy RECID=96 STAMP=974394850 file name=/u01/oracle/ebs/db/proddata/a_ref02.dbf

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 25-APR-18
released channel: p1
released channel: p2

RMAN>


--查询克隆完成后的状态
[orapbz@erptest PBZ_erptest]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 25 17:37:05 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
PBZ              OPEN

 

您可能感兴趣的文档:
点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: Oracle11g 和 Oracle12c rman克隆数据库

本文链接: https://www.lsjlt.com/news/39837.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档
去做题
猜你喜欢
  • Oracle11g 和 Oracle12c rman克隆数据库
     一、oracle12c rman克隆步骤1、生成环境信息查询1）实例状态信息2）数据文件信息3）日志文件信息4）参数文件信息2、测试环境准备：0）数据库软件安装和配置1）pfile参数文件 2）...
    99+
    2022-10-18
  • oracle数据库克隆
    oracle on linux安装多台服务器时可以采用一次安装副本多台克隆即可，简单快速. ***********************************************...
    99+
    2022-10-18
  • 【RMAN】Oracle11g使用rman迁移升级数据库（win_to_linux）
    前言：在迁移Oracle数据库的过程中，我们会遇到很多种情况，例如32位操作系统下的数据库迁移到64位，不同操作系统平台之间的迁移，那么怎么选择迁移工具呢，首先我们需要确认迁移源端和目标端的环境，再次停...
    99+
    2022-10-18
  • 如何备份克隆数据库
    这篇文章主要介绍如何备份克隆数据库，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！ ---基于备份克隆1、创建pfile  create pfi...
    99+
    2022-10-19
  • 如何使用navicat克隆数据库
    小编给大家分享一下如何使用navicat克隆数据库，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！工作中经常要使用到navicat...
    99+
    2022-10-18
  • ORACLE中怎么克隆非CDB数据库
    本篇内容主要讲解“ORACLE中怎么克隆非CDB数据库”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“ORACLE中怎么克隆非CDB数据库”吧!可以使用3种方法通...
    99+
    2022-10-18
  • Oracle11g数据库迁移到Oracle12C的PDB（使用impdp/expdp）
    Oracle11g数据库迁移到Oracle12C的PDB（使用impdp/expdp）alter pluggable database hrdb close immediate;DROP PLUGG...
    99+
    2022-10-18
  • ORACLE11G RMAN备份如何恢复到异机数据库
    这期内容当中小编将会给大家带来有关ORACLE11G RMAN备份如何恢复到异机数据库，文章内容丰富且以专业的角度为大家分析和叙述，阅读完这篇文章希望大家可以有所收获。 scp /u01/prb/rman...
    99+
    2022-10-19
  • MySQL数据克隆的定位和使用场景
    这篇文章主要讲解了“MySQL数据克隆的定位和使用场景”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MySQL数据克隆的定位和使用场景”吧！1.产品定位：数...
    99+
    2022-10-18
  • 如何通过克隆方式安装Oracle数据库软件
    这篇文章给大家分享的是有关如何通过克隆方式安装Oracle数据库软件的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。一、准备工作有时候，如果几个机器的配置相似，就不需要一遍又一遍地...
    99+
    2022-10-18
  • MySQL 数据库 增删查改、克隆、外键 等操作总结
    目录SQL 字段数据类型查看数据库信息语句SQL 语句创建、删除 数据库 数据表向表中添加、删除 记录、查询记录修改表名，添加、修改、删除 字段，添加唯一约束查看、删除、添加 表中的...
    99+
    2022-11-13
  • Linux克隆安装Oracle数据库软件的方法是什么
    本篇内容介绍了“Linux克隆安装Oracle数据库软件的方法是什么”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学...
    99+
    2022-10-18
  • 【沫沫金原创】Oracle克隆空库 新建一模一样的数据库不带数据
    背景由于平台数据发展带来的数据量，拖慢平台响应时间。技术组决定启用数据库分区功能！目标按日期月为单位分区，实现后期数据自动按月分区功能，解决数据累计带来的系统响应拖沓问题。方案1、增加分区功能的Sql2、现...
    99+
    2022-10-18
  • ProxmoxVE 之 安装oracle12C 数据库（CDB和PDB）
      上面左边是我的个人微信，如需进一步沟通，请加微信。  右边是我的公众号“Openstack私有云”，如有兴趣，请关注。    前两天在PVE环境上搭建了...
    99+
    2022-10-18
  • Oracle数据库克隆后temp文件因路径变化无法找到问题怎么办
    小编给大家分享一下Oracle数据库克隆后temp文件因路径变化无法找到问题怎么办，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！...
    99+
    2022-10-19
  • MySQL数据库高级操作实战(克隆表、清空表、创建临时表及约束)
    目录一、案例扩展二、克隆表1、方法一2、方法二三、清空表四、创建临时表五、创建外键约束，保证数据的完整性和一致性。六、mysql中6种常见的约束总结一、案例扩展 use kgc; create table if not ...
    99+
    2023-06-16
    mysql高级操作 MySQL数据库教程 mysql高级查询
  • 如何使用RMAN还原和恢复数据库
    这篇文章主要介绍“如何使用RMAN还原和恢复数据库”，在日常操作中，相信很多人在如何使用RMAN还原和恢复数据库问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”如何使用RMAN...
    99+
    2022-10-18
软考高级职称资格查询
软考职称历年真题下载
软考职称资料下载
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作