Wednesday, 4 December 2013

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  


Post a Comment