What Happens During DB Creation.

Starting Oracle Instance by exporting  ORACLE_HOME and INITIAL parameters

Starting Sequence of Back Ground Process

PMON background process Started

PSP0 background process started

VKTM background process started

GEN0 background process started

DIAG background process started

DBRM background process started

DIA0 background process started

MMAN background process started

DBW0 background process started

LGWR background process started

CKPT background process started

SMON background process started

RECO background process started

MMON background process started

MMNL background process started

Starting 1 Dispatcher for Network Address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'

Starting 1 Shared Server

Creation of Control File

Starting ASMB background process

Starting RBAL background process

Starting MARK background process

MARK load ASM lib and mount the diskgroups

Database mounted in Exclusive mode

Lost write protection disabled

Successful MOUNT

onlinelog 1 - created and open

SMON enables cache recovery

SYSTEM – created and set to default

SYSAUX - created and set to default

UNDO - created and set to default

TEMP - created and set to default

SMON enabling Txion Recovery

SMCO started

QMNC started

Create Database completed

USERS – Created and set to default

onlinelog 2 - created and open

onlinelog 3 - created and open

Set db_securefile = ‘PERMITTED’  à LOBs are allowed to be created as SecureFiles.

Shutting down instance (immediate)

Stopping background process SMCO

Shutting down instance: further logons disabled

Stopping background process CJQ0

Stopping background process QMNC

Stopping background process MMNL

Stopping background process MMON

All dispatchers and shared servers shutdown

ALTER DATABASE CLOSE NORMAL

SMON: disabling tx recovery

SMON: disabling cache recovery

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Deferred communication with ASM instance

Completed: ALTER DATABASE CLOSE NORMAL

ALTER DATABASE DISMOUNT

Shutting down archive processes

ARCH: Archival disabled due to shutdown: 1089

Stopping background process VKTM

Shutting down MARK background process

Instance shutdown complete

Oracle will start the instance and open the database.

SQL>

Total 7 log switches are happening during Database creation

To Check the Background process from Data Dictionary View.

select NAME, DESCRIPTION

  from V$BGPROCESS

 where PADDR <> '00' order by 1;

NAME  DESCRIPTION

----- -----------------------------------

ASMB  ASM Background

CJQ0  Job Queue Coordinator

CKPT  checkpoint

DBRM  DataBase Resource Manager

DBW0  db writer process 0

DIA0  diagnosibility process 0

DIAG  diagnosibility process

GEN0  generic0

LGWR  Redo etc.

MARK  mark AU for resync coordinator

MMAN  Memory Manager

MMNL  Manageability Monitor Process 2

MMON  Manageability Monitor Process

PMON  process cleanup

PSP0  process spawner 0

QMNC  AQ Coordinator

RBAL  ASM Rebalance master

RECO  distributed recovery

SMCO  Space Manager Process

SMON  System Monitor Process

VKTM  Virtual Keeper of TiMe process

DB Clone using RMAN duplicate database command

Set the Required Mandatory Parameters

Source DB   -- db_name  = VIS

Clone DB    -- db_name  = VIS1

Source DB   -- control_files = /u02/VIS/visdata/cntrl01.dbf,/u02/VIS/visdata/cntrl02.dbf,/u02/VIS/visdata/cntrl03.dbf

Clone DB    -- control_files = /VIS1/visdata/cntrl01.dbf,/VIS1/visdata/cntrl02.dbf,/VIS1/visdata/cntrl03.dbf

Source DB   -- diagnostic_dest  = /u02/VIS/visdb/11.2.0.3/admin/VIS_ebs11i

Clone DB    -- diagnostic_dest  = /VIS1/visdb/11.2.0.3/admin/VIS1_ebs11i

Source DB   -- core_dump_dest   = /u02/VIS/visdb/11.2.0.3/admin/VIS_ebs11i/cdump

Clone DB    -- core_dump_dest   = /VIS1/visdb/11.2.0.3/admin/VIS1_ebs11i/cdump

#Add New entries to Clone DB pfile.

Clone DB    -- db_file_name_convert  = '/u02/VIS/visdata/','/VIS1/visdata/'

Clone DB    -- log_file_name_convert = '/u02/VIS/visdata/','/VIS1/visdata/'

Set the ORACLE_SID and ORACLE_HOME parameters

[oracle@ebs11i ~]$ export ORACLE_SID=VIS1

[oracle@ebs11i ~]$ export ORACLE_HOME=/VIS1/visdb/11.2.0.3

Connect to Instance

[oracle@ebs11i ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 4 05:13:20 2013

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

Connected to an idle instance.

Bring up the Instance to No Mount with Pfile

SQL> startup nomount pfile='/VIS1/visdb/11.2.0.3/dbs/initVIS1.ora';

Total System Global Area  640323584 bytes

Fixed Size                  1346728 bytes

Variable Size             461374296 bytes

Database Buffers          163577856 bytes

Redo Buffers               14024704 bytes

SQL>

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Connect to RMAN Auxiliary instance

[oracle@ebs11i ~]$ rman auxiliary /

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Dec 4 05:14:41 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: VIS1 (not mounted)

Issue Duplicate Database command to Clone the Database

RMAN> duplicate database to VIS1 backup location '/u03/Backup_new/' NOFILENAMECHECK;

Starting Duplicate Db at 04-DEC-13

contents of Memory Script:

{

   sql clone "create spfile from memory";

}

executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:

{

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area     640323584 bytes

Fixed Size                     1346728 bytes

Variable Size                461374296 bytes

Database Buffers             163577856 bytes

Redo Buffers                  14024704 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''VIS'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name =

 ''VIS1'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   restore clone primary controlfile from  '/u03/Backup_new/06oqiltp_1_1.bkp';

   alter clone database mount;

}

executing Memory Script

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

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

Oracle instance shut down

Oracle instance started

Total System Global Area     640323584 bytes

Fixed Size                     1346728 bytes

Variable Size                461374296 bytes

Database Buffers             163577856 bytes

Redo Buffers                  14024704 bytes

Starting restore at 04-DEC-13

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=301 device type=DISK

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07

output file name=/VIS1/visdata/cntrl01.dbf

output file name=/VIS1/visdata/cntrl02.dbf

output file name=/VIS1/visdata/cntrl03.dbf

Finished restore at 04-DEC-13

database mounted

released channel: ORA_AUX_DISK_1

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=301 device type=DISK

contents of Memory Script:

{

   set until scn  8173891933524;

   set newname for datafile  1 to

 "/VIS1/visdata/sys1.dbf";

   set newname for datafile  2 to

 "/VIS1/visdata/sys2.dbf";

   set newname for datafile  3 to

 "/VIS1/visdata/sys3.dbf";

   set newname for datafile  4 to

 "/VIS1/visdata/sys4.dbf";

   set newname for datafile  5 to

 "/VIS1/visdata/sys5.dbf";

   set newname for datafile  6 to

 "/VIS1/visdata/sys6.dbf";

   set newname for datafile  7 to

 "/VIS1/visdata/sys7.dbf";

   set newname for datafile  8 to

 "/VIS1/visdata/undo01.dbf";

   set newname for datafile  9 to

 "/VIS1/visdata/undo02.dbf";

   set newname for datafile  10 to

 "/VIS1/visdata/undo03.dbf";

   set newname for datafile  11 to

 "/VIS1/visdata/undo04.dbf";

   set newname for datafile  12 to

 "/VIS1/visdata/archive1.dbf";

   set newname for datafile  13 to

 "/VIS1/visdata/archive2.dbf";

   set newname for datafile  14 to

 "/VIS1/visdata/media1.dbf";

   set newname for datafile  15 to

 "/VIS1/visdata/media2.dbf";

   set newname for datafile  16 to

 "/VIS1/visdata/media3.dbf";

   set newname for datafile  17 to

 "/VIS1/visdata/nologging1.dbf";

   set newname for datafile  18 to

 "/VIS1/visdata/queues1.dbf";

   set newname for datafile  19 to

 "/VIS1/visdata/queues2.dbf";

   set newname for datafile  20 to

 "/VIS1/visdata/reference1.dbf";

   set newname for datafile  21 to

 "/VIS1/visdata/reference2.dbf";

   set newname for datafile  22 to

 "/VIS1/visdata/summary1.dbf";

   set newname for datafile  23 to

 "/VIS1/visdata/summary2.dbf";

   set newname for datafile  24 to

 "/VIS1/visdata/summary3.dbf";

   set newname for datafile  25 to

 "/VIS1/visdata/summary4.dbf";

   set newname for datafile  26 to

 "/VIS1/visdata/summary5.dbf";

   set newname for datafile  27 to

 "/VIS1/visdata/tx_data1.dbf";

   set newname for datafile  28 to

 "/VIS1/visdata/tx_data2.dbf";

   set newname for datafile  29 to

 "/VIS1/visdata/tx_data3.dbf";

   set newname for datafile  30 to

 "/VIS1/visdata/tx_data4.dbf";

   set newname for datafile  31 to

 "/VIS1/visdata/tx_data5.dbf";

   set newname for datafile  32 to

 "/VIS1/visdata/tx_data6.dbf";

   set newname for datafile  33 to

 "/VIS1/visdata/tx_data7.dbf";

   set newname for datafile  34 to

 "/VIS1/visdata/tx_data8.dbf";

   set newname for datafile  35 to

 "/VIS1/visdata/tx_data9.dbf";

   set newname for datafile  36 to

 "/VIS1/visdata/tx_data10.dbf";

   set newname for datafile  37 to

 "/VIS1/visdata/tx_data11.dbf";

   set newname for datafile  38 to

 "/VIS1/visdata/tx_idx1.dbf";

   set newname for datafile  39 to

 "/VIS1/visdata/tx_idx2.dbf";

   set newname for datafile  40 to

 "/VIS1/visdata/tx_idx3.dbf";

   set newname for datafile  41 to

 "/VIS1/visdata/tx_idx4.dbf";

   set newname for datafile  42 to

 "/VIS1/visdata/tx_idx5.dbf";

   set newname for datafile  43 to

 "/VIS1/visdata/tx_idx6.dbf";

   set newname for datafile  44 to

 "/VIS1/visdata/tx_idx7.dbf";

   set newname for datafile  45 to

 "/VIS1/visdata/tx_idx8.dbf";

   set newname for datafile  46 to

 "/VIS1/visdata/tx_idx9.dbf";

   set newname for datafile  47 to

 "/VIS1/visdata/tx_idx10.dbf";

   set newname for datafile  48 to

 "/VIS1/visdata/tx_idx11.dbf";

   set newname for datafile  49 to

 "/VIS1/visdata/apps_ts_tx_interface.dbf";

   set newname for datafile  50 to

 "/VIS1/visdata/ctx1.dbf";

   set newname for datafile  51 to

 "/VIS1/visdata/sysaux01.dbf";

   set newname for datafile  52 to

 "/VIS1/visdata/aadev.dbf";

   set newname for datafile  53 to

 "/VIS1/visdata/odm.dbf";

   set newname for datafile  55 to

 "/VIS1/visdata/olap.dbf";

   set newname for datafile  56 to

 "/VIS1/visdata/owa1.dbf";

   set newname for datafile  57 to

 "/VIS1/visdata/portal.dbf";

   set newname for datafile  58 to

 "/VIS1/visdata/mobile01.dbf";

   restore

   clone database

   ;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

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 04-DEC-13

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /VIS1/visdata/sys1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00002 to /VIS1/visdata/sys2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00005 to /VIS1/visdata/sys5.dbf

channel ORA_AUX_DISK_1: restoring datafile 00007 to /VIS1/visdata/sys7.dbf

channel ORA_AUX_DISK_1: restoring datafile 00010 to /VIS1/visdata/undo03.dbf

channel ORA_AUX_DISK_1: restoring datafile 00014 to /VIS1/visdata/media1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00018 to /VIS1/visdata/queues1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00023 to /VIS1/visdata/summary2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00027 to /VIS1/visdata/tx_data1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00033 to /VIS1/visdata/tx_data7.dbf

channel ORA_AUX_DISK_1: restoring datafile 00036 to /VIS1/visdata/tx_data10.dbf

channel ORA_AUX_DISK_1: restoring datafile 00038 to /VIS1/visdata/tx_idx1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00039 to /VIS1/visdata/tx_idx2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00042 to /VIS1/visdata/tx_idx5.dbf

channel ORA_AUX_DISK_1: restoring datafile 00044 to /VIS1/visdata/tx_idx7.dbf

channel ORA_AUX_DISK_1: restoring datafile 00045 to /VIS1/visdata/tx_idx8.dbf

channel ORA_AUX_DISK_1: restoring datafile 00051 to /VIS1/visdata/sysaux01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00056 to /VIS1/visdata/owa1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00057 to /VIS1/visdata/portal.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u03/Backup_new/06oqiltp_1_1.bkp

channel ORA_AUX_DISK_1: piece handle=/u03/Backup_new/06oqiltp_1_1.bkp tag=TAG20131203T072024

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 01:10:19

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00003 to /VIS1/visdata/sys3.dbf

channel ORA_AUX_DISK_1: restoring datafile 00006 to /VIS1/visdata/sys6.dbf

channel ORA_AUX_DISK_1: restoring datafile 00008 to /VIS1/visdata/undo01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00011 to /VIS1/visdata/undo04.dbf

channel ORA_AUX_DISK_1: restoring datafile 00015 to /VIS1/visdata/media2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00017 to /VIS1/visdata/nologging1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00019 to /VIS1/visdata/queues2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00020 to /VIS1/visdata/reference1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00026 to /VIS1/visdata/summary5.dbf

channel ORA_AUX_DISK_1: restoring datafile 00028 to /VIS1/visdata/tx_data2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00030 to /VIS1/visdata/tx_data4.dbf

channel ORA_AUX_DISK_1: restoring datafile 00032 to /VIS1/visdata/tx_data6.dbf

channel ORA_AUX_DISK_1: restoring datafile 00034 to /VIS1/visdata/tx_data8.dbf

channel ORA_AUX_DISK_1: restoring datafile 00037 to /VIS1/visdata/tx_data11.dbf

channel ORA_AUX_DISK_1: restoring datafile 00040 to /VIS1/visdata/tx_idx3.dbf

channel ORA_AUX_DISK_1: restoring datafile 00043 to /VIS1/visdata/tx_idx6.dbf

channel ORA_AUX_DISK_1: restoring datafile 00047 to /VIS1/visdata/tx_idx10.dbf

channel ORA_AUX_DISK_1: restoring datafile 00052 to /VIS1/visdata/aadev.dbf

channel ORA_AUX_DISK_1: restoring datafile 00055 to /VIS1/visdata/olap.dbf

channel ORA_AUX_DISK_1: restoring datafile 00058 to /VIS1/visdata/mobile01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u03/Backup_new/08oqiltp_1_1.bkp

channel ORA_AUX_DISK_1: piece handle=/u03/Backup_new/08oqiltp_1_1.bkp tag=TAG20131203T072024

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 01:18:37

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00004 to /VIS1/visdata/sys4.dbf

channel ORA_AUX_DISK_1: restoring datafile 00009 to /VIS1/visdata/undo02.dbf

channel ORA_AUX_DISK_1: restoring datafile 00012 to /VIS1/visdata/archive1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00013 to /VIS1/visdata/archive2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00016 to /VIS1/visdata/media3.dbf

channel ORA_AUX_DISK_1: restoring datafile 00021 to /VIS1/visdata/reference2.dbf

channel ORA_AUX_DISK_1: restoring datafile 00022 to /VIS1/visdata/summary1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00024 to /VIS1/visdata/summary3.dbf

channel ORA_AUX_DISK_1: restoring datafile 00025 to /VIS1/visdata/summary4.dbf

channel ORA_AUX_DISK_1: restoring datafile 00029 to /VIS1/visdata/tx_data3.dbf

channel ORA_AUX_DISK_1: restoring datafile 00031 to /VIS1/visdata/tx_data5.dbf

channel ORA_AUX_DISK_1: restoring datafile 00035 to /VIS1/visdata/tx_data9.dbf

channel ORA_AUX_DISK_1: restoring datafile 00041 to /VIS1/visdata/tx_idx4.dbf

channel ORA_AUX_DISK_1: restoring datafile 00046 to /VIS1/visdata/tx_idx9.dbf

channel ORA_AUX_DISK_1: restoring datafile 00048 to /VIS1/visdata/tx_idx11.dbf

channel ORA_AUX_DISK_1: restoring datafile 00049 to /VIS1/visdata/apps_ts_tx_interface.dbf

channel ORA_AUX_DISK_1: restoring datafile 00050 to /VIS1/visdata/ctx1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00053 to /VIS1/visdata/odm.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u03/Backup_new/07oqiltp_1_1.bkp

channel ORA_AUX_DISK_1: piece handle=/u03/Backup_new/07oqiltp_1_1.bkp tag=TAG20131203T072024

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 01:28:19

Finished restore at 04-DEC-13

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=58 STAMP=833274832 file name=/VIS1/visdata/sys1.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=59 STAMP=833274832 file name=/VIS1/visdata/sys2.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=60 STAMP=833274832 file name=/VIS1/visdata/sys3.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=61 STAMP=833274833 file name=/VIS1/visdata/sys4.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=62 STAMP=833274833 file name=/VIS1/visdata/sys5.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=63 STAMP=833274833 file name=/VIS1/visdata/sys6.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=64 STAMP=833274833 file name=/VIS1/visdata/sys7.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=65 STAMP=833274833 file name=/VIS1/visdata/undo01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=66 STAMP=833274833 file name=/VIS1/visdata/undo02.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=67 STAMP=833274833 file name=/VIS1/visdata/undo03.dbf

datafile 11 switched to datafile copy

input datafile copy RECID=68 STAMP=833274833 file name=/VIS1/visdata/undo04.dbf

datafile 12 switched to datafile copy

input datafile copy RECID=69 STAMP=833274833 file name=/VIS1/visdata/archive1.dbf

datafile 13 switched to datafile copy

input datafile copy RECID=70 STAMP=833274833 file name=/VIS1/visdata/archive2.dbf

datafile 14 switched to datafile copy

input datafile copy RECID=71 STAMP=833274833 file name=/VIS1/visdata/media1.dbf

datafile 15 switched to datafile copy

input datafile copy RECID=72 STAMP=833274833 file name=/VIS1/visdata/media2.dbf

datafile 16 switched to datafile copy

input datafile copy RECID=73 STAMP=833274833 file name=/VIS1/visdata/media3.dbf

datafile 17 switched to datafile copy

input datafile copy RECID=74 STAMP=833274833 file name=/VIS1/visdata/nologging1.dbf

datafile 18 switched to datafile copy

input datafile copy RECID=75 STAMP=833274833 file name=/VIS1/visdata/queues1.dbf

datafile 19 switched to datafile copy

input datafile copy RECID=76 STAMP=833274833 file name=/VIS1/visdata/queues2.dbf

datafile 20 switched to datafile copy

input datafile copy RECID=77 STAMP=833274833 file name=/VIS1/visdata/reference1.dbf

datafile 21 switched to datafile copy

input datafile copy RECID=78 STAMP=833274833 file name=/VIS1/visdata/reference2.dbf

datafile 22 switched to datafile copy

input datafile copy RECID=79 STAMP=833274833 file name=/VIS1/visdata/summary1.dbf

datafile 23 switched to datafile copy

input datafile copy RECID=80 STAMP=833274833 file name=/VIS1/visdata/summary2.dbf

datafile 24 switched to datafile copy

input datafile copy RECID=81 STAMP=833274833 file name=/VIS1/visdata/summary3.dbf

datafile 25 switched to datafile copy

input datafile copy RECID=82 STAMP=833274834 file name=/VIS1/visdata/summary4.dbf

datafile 26 switched to datafile copy

input datafile copy RECID=83 STAMP=833274834 file name=/VIS1/visdata/summary5.dbf

datafile 27 switched to datafile copy

input datafile copy RECID=84 STAMP=833274834 file name=/VIS1/visdata/tx_data1.dbf

datafile 28 switched to datafile copy

input datafile copy RECID=85 STAMP=833274834 file name=/VIS1/visdata/tx_data2.dbf

datafile 29 switched to datafile copy

input datafile copy RECID=86 STAMP=833274834 file name=/VIS1/visdata/tx_data3.dbf

datafile 30 switched to datafile copy

input datafile copy RECID=87 STAMP=833274834 file name=/VIS1/visdata/tx_data4.dbf

datafile 31 switched to datafile copy

input datafile copy RECID=88 STAMP=833274834 file name=/VIS1/visdata/tx_data5.dbf

datafile 32 switched to datafile copy

input datafile copy RECID=89 STAMP=833274834 file name=/VIS1/visdata/tx_data6.dbf

datafile 33 switched to datafile copy

input datafile copy RECID=90 STAMP=833274834 file name=/VIS1/visdata/tx_data7.dbf

datafile 34 switched to datafile copy

input datafile copy RECID=91 STAMP=833274834 file name=/VIS1/visdata/tx_data8.dbf

datafile 35 switched to datafile copy

input datafile copy RECID=92 STAMP=833274834 file name=/VIS1/visdata/tx_data9.dbf

datafile 36 switched to datafile copy

input datafile copy RECID=93 STAMP=833274834 file name=/VIS1/visdata/tx_data10.dbf

datafile 37 switched to datafile copy

input datafile copy RECID=94 STAMP=833274834 file name=/VIS1/visdata/tx_data11.dbf

datafile 38 switched to datafile copy

input datafile copy RECID=95 STAMP=833274834 file name=/VIS1/visdata/tx_idx1.dbf

datafile 39 switched to datafile copy

input datafile copy RECID=96 STAMP=833274834 file name=/VIS1/visdata/tx_idx2.dbf

datafile 40 switched to datafile copy

input datafile copy RECID=97 STAMP=833274834 file name=/VIS1/visdata/tx_idx3.dbf

datafile 41 switched to datafile copy

input datafile copy RECID=98 STAMP=833274834 file name=/VIS1/visdata/tx_idx4.dbf

datafile 42 switched to datafile copy

input datafile copy RECID=99 STAMP=833274834 file name=/VIS1/visdata/tx_idx5.dbf

datafile 43 switched to datafile copy

input datafile copy RECID=100 STAMP=833274834 file name=/VIS1/visdata/tx_idx6.dbf

datafile 44 switched to datafile copy

input datafile copy RECID=101 STAMP=833274834 file name=/VIS1/visdata/tx_idx7.dbf

datafile 45 switched to datafile copy

input datafile copy RECID=102 STAMP=833274834 file name=/VIS1/visdata/tx_idx8.dbf

datafile 46 switched to datafile copy

input datafile copy RECID=103 STAMP=833274835 file name=/VIS1/visdata/tx_idx9.dbf

datafile 47 switched to datafile copy

input datafile copy RECID=104 STAMP=833274835 file name=/VIS1/visdata/tx_idx10.dbf

datafile 48 switched to datafile copy

input datafile copy RECID=105 STAMP=833274835 file name=/VIS1/visdata/tx_idx11.dbf

datafile 49 switched to datafile copy

input datafile copy RECID=106 STAMP=833274835 file name=/VIS1/visdata/apps_ts_tx_interface.dbf

datafile 50 switched to datafile copy

input datafile copy RECID=107 STAMP=833274835 file name=/VIS1/visdata/ctx1.dbf

datafile 51 switched to datafile copy

input datafile copy RECID=108 STAMP=833274835 file name=/VIS1/visdata/sysaux01.dbf

datafile 52 switched to datafile copy

input datafile copy RECID=109 STAMP=833274835 file name=/VIS1/visdata/aadev.dbf

datafile 53 switched to datafile copy

input datafile copy RECID=110 STAMP=833274835 file name=/VIS1/visdata/odm.dbf

datafile 55 switched to datafile copy

input datafile copy RECID=111 STAMP=833274835 file name=/VIS1/visdata/olap.dbf

datafile 56 switched to datafile copy

input datafile copy RECID=112 STAMP=833274835 file name=/VIS1/visdata/owa1.dbf

datafile 57 switched to datafile copy

input datafile copy RECID=113 STAMP=833274835 file name=/VIS1/visdata/portal.dbf

datafile 58 switched to datafile copy

input datafile copy RECID=114 STAMP=833274835 file name=/VIS1/visdata/mobile01.dbf

contents of Memory Script:

{

   set until scn  8173891933524;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

executing command: SET until clause

Starting recover at 04-DEC-13

using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=949

channel ORA_AUX_DISK_1: reading from backup piece /u03/Backup_new/09oqir1k_1_1.bkp

channel ORA_AUX_DISK_1: piece handle=/u03/Backup_new/09oqir1k_1_1.bkp tag=TAG20131203T084748

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/VIS1/visdb/11.2.0.3/dbs/arch1_949_831836307.dbf thread=1 sequence=949

channel clone_default: deleting archived log(s)

archived log file name=/VIS1/visdb/11.2.0.3/dbs/arch1_949_831836307.dbf RECID=1 STAMP=833274841

media recovery complete, elapsed time: 00:00:06

Finished recover at 04-DEC-13

Oracle instance started

Total System Global Area     640323584 bytes

Fixed Size                     1346728 bytes

Variable Size                461374296 bytes

Database Buffers             163577856 bytes

Redo Buffers                  14024704 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''VIS1'' comment=

 ''Reset to original value by RMAN'' scope=spfile";

   sql clone "alter system reset  db_unique_name scope=spfile";

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''VIS1'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area     640323584 bytes

Fixed Size                     1346728 bytes

Variable Size                461374296 bytes

Database Buffers             163577856 bytes

Redo Buffers                  14024704 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "VIS1" RESETLOGS ARCHIVELOG

  MAXLOGFILES     32

  MAXLOGMEMBERS      5

  MAXDATAFILES      512

  MAXINSTANCES     8

  MAXLOGHISTORY     3630

 LOGFILE

  GROUP   1 ( '/VIS1/visdata/log3.dbf' ) SIZE 50 M  REUSE,

  GROUP   2 ( '/VIS1/visdata/log2.dbf' ) SIZE 50 M  REUSE,

  GROUP   3 ( '/VIS1/visdata/log1.dbf' ) SIZE 50 M  REUSE

 DATAFILE

  '/VIS1/visdata/sys1.dbf'

 CHARACTER SET UTF8

contents of Memory Script:

{

   set newname for tempfile  1 to

 "/VIS1/visdata/tmp1.dbf";

   switch clone tempfile all;

   catalog clone datafilecopy  "/VIS1/visdata/sys2.dbf",

 "/VIS1/visdata/sys3.dbf",

 "/VIS1/visdata/sys4.dbf",

 "/VIS1/visdata/sys5.dbf",

 "/VIS1/visdata/sys6.dbf",

 "/VIS1/visdata/sys7.dbf",

 "/VIS1/visdata/undo01.dbf",

 "/VIS1/visdata/undo02.dbf",

 "/VIS1/visdata/undo03.dbf",

 "/VIS1/visdata/undo04.dbf",

 "/VIS1/visdata/archive1.dbf",

 "/VIS1/visdata/archive2.dbf",

 "/VIS1/visdata/media1.dbf",

 "/VIS1/visdata/media2.dbf",

 "/VIS1/visdata/media3.dbf",

 "/VIS1/visdata/nologging1.dbf",

 "/VIS1/visdata/queues1.dbf",

 "/VIS1/visdata/queues2.dbf",

 "/VIS1/visdata/reference1.dbf",

 "/VIS1/visdata/reference2.dbf",

 "/VIS1/visdata/summary1.dbf",

 "/VIS1/visdata/summary2.dbf",

 "/VIS1/visdata/summary3.dbf",

 "/VIS1/visdata/summary4.dbf",

 "/VIS1/visdata/summary5.dbf",

 "/VIS1/visdata/tx_data1.dbf",

 "/VIS1/visdata/tx_data2.dbf",

 "/VIS1/visdata/tx_data3.dbf",

 "/VIS1/visdata/tx_data4.dbf",

 "/VIS1/visdata/tx_data5.dbf",

 "/VIS1/visdata/tx_data6.dbf",

 "/VIS1/visdata/tx_data7.dbf",

 "/VIS1/visdata/tx_data8.dbf",

 "/VIS1/visdata/tx_data9.dbf",

 "/VIS1/visdata/tx_data10.dbf",

 "/VIS1/visdata/tx_data11.dbf",

 "/VIS1/visdata/tx_idx1.dbf",

 "/VIS1/visdata/tx_idx2.dbf",

 "/VIS1/visdata/tx_idx3.dbf",

 "/VIS1/visdata/tx_idx4.dbf",

 "/VIS1/visdata/tx_idx5.dbf",

 "/VIS1/visdata/tx_idx6.dbf",

 "/VIS1/visdata/tx_idx7.dbf",

 "/VIS1/visdata/tx_idx8.dbf",

 "/VIS1/visdata/tx_idx9.dbf",

 "/VIS1/visdata/tx_idx10.dbf",

 "/VIS1/visdata/tx_idx11.dbf",

 "/VIS1/visdata/apps_ts_tx_interface.dbf",

 "/VIS1/visdata/ctx1.dbf",

 "/VIS1/visdata/sysaux01.dbf",

 "/VIS1/visdata/aadev.dbf",

 "/VIS1/visdata/odm.dbf",

 "/VIS1/visdata/olap.dbf",

 "/VIS1/visdata/owa1.dbf",

 "/VIS1/visdata/portal.dbf",

 "/VIS1/visdata/mobile01.dbf";

   switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /VIS1/visdata/tmp1.dbf in control file

cataloged datafile copy

datafile copy file name=/VIS1/visdata/sys2.dbf RECID=1 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/sys3.dbf RECID=2 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/sys4.dbf RECID=3 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/sys5.dbf RECID=4 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/sys6.dbf RECID=5 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/sys7.dbf RECID=6 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/undo01.dbf RECID=7 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/undo02.dbf RECID=8 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/undo03.dbf RECID=9 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/undo04.dbf RECID=10 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/archive1.dbf RECID=11 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/archive2.dbf RECID=12 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/media1.dbf RECID=13 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/media2.dbf RECID=14 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/media3.dbf RECID=15 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/nologging1.dbf RECID=16 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/queues1.dbf RECID=17 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/queues2.dbf RECID=18 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/reference1.dbf RECID=19 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/reference2.dbf RECID=20 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/summary1.dbf RECID=21 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/summary2.dbf RECID=22 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/summary3.dbf RECID=23 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/summary4.dbf RECID=24 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/summary5.dbf RECID=25 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data1.dbf RECID=26 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data2.dbf RECID=27 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data3.dbf RECID=28 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data4.dbf RECID=29 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data5.dbf RECID=30 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data6.dbf RECID=31 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data7.dbf RECID=32 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data8.dbf RECID=33 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data9.dbf RECID=34 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data10.dbf RECID=35 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_data11.dbf RECID=36 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx1.dbf RECID=37 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx2.dbf RECID=38 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx3.dbf RECID=39 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx4.dbf RECID=40 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx5.dbf RECID=41 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx6.dbf RECID=42 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx7.dbf RECID=43 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx8.dbf RECID=44 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx9.dbf RECID=45 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx10.dbf RECID=46 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/tx_idx11.dbf RECID=47 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/apps_ts_tx_interface.dbf RECID=48 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/ctx1.dbf RECID=49 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/sysaux01.dbf RECID=50 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/aadev.dbf RECID=51 STAMP=833274869

cataloged datafile copy

datafile copy file name=/VIS1/visdata/odm.dbf RECID=52 STAMP=833274870

cataloged datafile copy

datafile copy file name=/VIS1/visdata/olap.dbf RECID=53 STAMP=833274870

cataloged datafile copy

datafile copy file name=/VIS1/visdata/owa1.dbf RECID=54 STAMP=833274870

cataloged datafile copy

datafile copy file name=/VIS1/visdata/portal.dbf RECID=55 STAMP=833274870

cataloged datafile copy

datafile copy file name=/VIS1/visdata/mobile01.dbf RECID=56 STAMP=833274870

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=833274869 file name=/VIS1/visdata/sys2.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=833274869 file name=/VIS1/visdata/sys3.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=833274869 file name=/VIS1/visdata/sys4.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=4 STAMP=833274869 file name=/VIS1/visdata/sys5.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=5 STAMP=833274869 file name=/VIS1/visdata/sys6.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=6 STAMP=833274869 file name=/VIS1/visdata/sys7.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=7 STAMP=833274869 file name=/VIS1/visdata/undo01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=8 STAMP=833274869 file name=/VIS1/visdata/undo02.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=9 STAMP=833274869 file name=/VIS1/visdata/undo03.dbf

datafile 11 switched to datafile copy

input datafile copy RECID=10 STAMP=833274869 file name=/VIS1/visdata/undo04.dbf

datafile 12 switched to datafile copy

input datafile copy RECID=11 STAMP=833274869 file name=/VIS1/visdata/archive1.dbf

datafile 13 switched to datafile copy

input datafile copy RECID=12 STAMP=833274869 file name=/VIS1/visdata/archive2.dbf

datafile 14 switched to datafile copy

input datafile copy RECID=13 STAMP=833274869 file name=/VIS1/visdata/media1.dbf

datafile 15 switched to datafile copy

input datafile copy RECID=14 STAMP=833274869 file name=/VIS1/visdata/media2.dbf

datafile 16 switched to datafile copy

input datafile copy RECID=15 STAMP=833274869 file name=/VIS1/visdata/media3.dbf

datafile 17 switched to datafile copy

input datafile copy RECID=16 STAMP=833274869 file name=/VIS1/visdata/nologging1.dbf

datafile 18 switched to datafile copy

input datafile copy RECID=17 STAMP=833274869 file name=/VIS1/visdata/queues1.dbf

datafile 19 switched to datafile copy

input datafile copy RECID=18 STAMP=833274869 file name=/VIS1/visdata/queues2.dbf

datafile 20 switched to datafile copy

input datafile copy RECID=19 STAMP=833274869 file name=/VIS1/visdata/reference1.dbf

datafile 21 switched to datafile copy

input datafile copy RECID=20 STAMP=833274869 file name=/VIS1/visdata/reference2.dbf

datafile 22 switched to datafile copy

input datafile copy RECID=21 STAMP=833274869 file name=/VIS1/visdata/summary1.dbf

datafile 23 switched to datafile copy

input datafile copy RECID=22 STAMP=833274869 file name=/VIS1/visdata/summary2.dbf

datafile 24 switched to datafile copy

input datafile copy RECID=23 STAMP=833274869 file name=/VIS1/visdata/summary3.dbf

datafile 25 switched to datafile copy

input datafile copy RECID=24 STAMP=833274869 file name=/VIS1/visdata/summary4.dbf

datafile 26 switched to datafile copy

input datafile copy RECID=25 STAMP=833274869 file name=/VIS1/visdata/summary5.dbf

datafile 27 switched to datafile copy

input datafile copy RECID=26 STAMP=833274869 file name=/VIS1/visdata/tx_data1.dbf

datafile 28 switched to datafile copy

input datafile copy RECID=27 STAMP=833274869 file name=/VIS1/visdata/tx_data2.dbf

datafile 29 switched to datafile copy

input datafile copy RECID=28 STAMP=833274869 file name=/VIS1/visdata/tx_data3.dbf

datafile 30 switched to datafile copy

input datafile copy RECID=29 STAMP=833274869 file name=/VIS1/visdata/tx_data4.dbf

datafile 31 switched to datafile copy

input datafile copy RECID=30 STAMP=833274869 file name=/VIS1/visdata/tx_data5.dbf

datafile 32 switched to datafile copy

input datafile copy RECID=31 STAMP=833274869 file name=/VIS1/visdata/tx_data6.dbf

datafile 33 switched to datafile copy

input datafile copy RECID=32 STAMP=833274869 file name=/VIS1/visdata/tx_data7.dbf

datafile 34 switched to datafile copy

input datafile copy RECID=33 STAMP=833274869 file name=/VIS1/visdata/tx_data8.dbf

datafile 35 switched to datafile copy

input datafile copy RECID=34 STAMP=833274869 file name=/VIS1/visdata/tx_data9.dbf

datafile 36 switched to datafile copy

input datafile copy RECID=35 STAMP=833274869 file name=/VIS1/visdata/tx_data10.dbf

datafile 37 switched to datafile copy

input datafile copy RECID=36 STAMP=833274869 file name=/VIS1/visdata/tx_data11.dbf

datafile 38 switched to datafile copy

input datafile copy RECID=37 STAMP=833274869 file name=/VIS1/visdata/tx_idx1.dbf

datafile 39 switched to datafile copy

input datafile copy RECID=38 STAMP=833274869 file name=/VIS1/visdata/tx_idx2.dbf

datafile 40 switched to datafile copy

input datafile copy RECID=39 STAMP=833274869 file name=/VIS1/visdata/tx_idx3.dbf

datafile 41 switched to datafile copy

input datafile copy RECID=40 STAMP=833274869 file name=/VIS1/visdata/tx_idx4.dbf

datafile 42 switched to datafile copy

input datafile copy RECID=41 STAMP=833274869 file name=/VIS1/visdata/tx_idx5.dbf

datafile 43 switched to datafile copy

input datafile copy RECID=42 STAMP=833274869 file name=/VIS1/visdata/tx_idx6.dbf

datafile 44 switched to datafile copy

input datafile copy RECID=43 STAMP=833274869 file name=/VIS1/visdata/tx_idx7.dbf

datafile 45 switched to datafile copy

input datafile copy RECID=44 STAMP=833274869 file name=/VIS1/visdata/tx_idx8.dbf

datafile 46 switched to datafile copy

input datafile copy RECID=45 STAMP=833274869 file name=/VIS1/visdata/tx_idx9.dbf

datafile 47 switched to datafile copy

input datafile copy RECID=46 STAMP=833274869 file name=/VIS1/visdata/tx_idx10.dbf

datafile 48 switched to datafile copy

input datafile copy RECID=47 STAMP=833274869 file name=/VIS1/visdata/tx_idx11.dbf

datafile 49 switched to datafile copy

input datafile copy RECID=48 STAMP=833274869 file name=/VIS1/visdata/apps_ts_tx_interface.dbf

datafile 50 switched to datafile copy

input datafile copy RECID=49 STAMP=833274869 file name=/VIS1/visdata/ctx1.dbf

datafile 51 switched to datafile copy

input datafile copy RECID=50 STAMP=833274869 file name=/VIS1/visdata/sysaux01.dbf

datafile 52 switched to datafile copy

input datafile copy RECID=51 STAMP=833274869 file name=/VIS1/visdata/aadev.dbf

datafile 53 switched to datafile copy

input datafile copy RECID=52 STAMP=833274870 file name=/VIS1/visdata/odm.dbf

datafile 55 switched to datafile copy

input datafile copy RECID=53 STAMP=833274870 file name=/VIS1/visdata/olap.dbf

datafile 56 switched to datafile copy

input datafile copy RECID=54 STAMP=833274870 file name=/VIS1/visdata/owa1.dbf

datafile 57 switched to datafile copy

input datafile copy RECID=55 STAMP=833274870 file name=/VIS1/visdata/portal.dbf

datafile 58 switched to datafile copy

input datafile copy RECID=56 STAMP=833274870 file name=/VIS1/visdata/mobile01.dbf

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 04-DEC-13

RMAN>

RMAN>

Your clone Instance is ready.

SQL> select INSTANCE_NAME, STATUS from V$INSTANCE;

INSTANCE_NAME   STATUS 

-------------  ------ 

VIS1            OPEN