{\rtf1\ansi\ansicpg1252\cocoartf1038\cocoasubrtf320
{\fonttbl\f0\fmodern\fcharset0 CourierNewPSMT;}
{\colortbl;\red255\green255\blue255;}
\margl1440\margr1440\vieww9000\viewh8400\viewkind0
\deftab720
\pard\pardeftab720\ri720

\f0\fs24 \cf0 Recovery Manager: Release 11.2.0.1.0 - Production on Mon Aug 9 12:08:52 2010\
\
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.\
\
RMAN> connect auxiliary *\
2> connect catalog *\
3> duplicate database 'D112D1' DBID 1718629572 to 'STG'\
4> until time "to_date('08/09/10 10:44:53','mm/dd/yy hh24:mi:ss')"\
5> db_file_name_convert = ("+DATA/D112D1","/u01/oradata/stg")\
6> backup location '/u01/oraback'\
7> ;\
8> \
connected to auxiliary database: STG (not mounted)\
\
connected to recovery catalog database\
\
Starting Duplicate Db at 08/09/10 12:08:52\
allocated channel: ORA_AUX_DISK_1\
channel ORA_AUX_DISK_1: SID=134 device type=DISK\
\
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     744910848 bytes\
\
Fixed Size                     1339120 bytes\
Variable Size                444596496 bytes\
Database Buffers             293601280 bytes\
Redo Buffers                   5373952 bytes\
\
contents of Memory Script:\
\{\
   set until scn  13584379;\
   sql clone "alter system set  db_name = \
 ''D112D1'' comment=\
 ''Modified by RMAN duplicate'' scope=spfile";\
   sql clone "alter system set  db_unique_name = \
 ''STG'' comment=\
 ''Modified by RMAN duplicate'' scope=spfile";\
   shutdown clone immediate;\
   startup clone force nomount\
   restore clone primary controlfile;\
   alter clone database mount;\
\}\
executing Memory Script\
\
executing command: SET until clause\
\
sql statement: alter system set  db_name =  ''D112D1'' comment= ''Modified by RMAN duplicate'' scope=spfile\
\
sql statement: alter system set  db_unique_name =  ''STG'' comment= ''Modified by RMAN duplicate'' scope=spfile\
\
Oracle instance shut down\
\
Oracle instance started\
\
Total System Global Area     744910848 bytes\
\
Fixed Size                     1339120 bytes\
Variable Size                444596496 bytes\
Database Buffers             293601280 bytes\
Redo Buffers                   5373952 bytes\
\
Starting restore at 08/09/10 12:09:10\
allocated channel: ORA_AUX_DISK_1\
channel ORA_AUX_DISK_1: SID=134 device type=DISK\
\
channel ORA_AUX_DISK_1: starting datafile backup set restore\
channel ORA_AUX_DISK_1: restoring control file\
channel ORA_AUX_DISK_1: reading from backup piece /u01/oraback/20lkt9ta_1_1.rmb\
channel ORA_AUX_DISK_1: piece handle=/u01/oraback/20lkt9ta_1_1.rmb tag=TAG20100809T102338\
channel ORA_AUX_DISK_1: restored backup piece 1\
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01\
output file name=/u01/oradata/cntfile_STG_1.ctl\
Finished restore at 08/09/10 12:09:15\
\
database mounted\
\
contents of Memory Script:\
\{\
   set until scn  13584379;\
   set newname for datafile  1 to \
 "/u01/oradata/stg/datafile/system.256.696458617";\
   set newname for datafile  2 to \
 "/u01/oradata/stg/datafile/sysaux.257.696458617";\
   set newname for datafile  3 to \
 "/u01/oradata/stg/datafile/undotbs1.258.696458617";\
   set newname for datafile  4 to \
 "/u01/oradata/stg/datafile/users.259.696458617";\
   set newname for datafile  5 to \
 "/u01/oradata/stg/datafile/example.269.696458803";\
   set newname for datafile  6 to \
 "/u01/oradata/stg/datafile/abcd_data.272.697114011";\
   set newname for datafile  7 to \
 "/u01/oradata/stg/datafile/audit_ts.293.698028255";\
   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\
\
Starting restore at 08/09/10 12:09:20\
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 /u01/oradata/stg/datafile/system.256.696458617\
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/oradata/stg/datafile/sysaux.257.696458617\
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/oradata/stg/datafile/undotbs1.258.696458617\
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/oradata/stg/datafile/users.259.696458617\
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/oradata/stg/datafile/example.269.696458803\
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/oradata/stg/datafile/abcd_data.272.697114011\
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/oradata/stg/datafile/audit_ts.293.698028255\
channel ORA_AUX_DISK_1: reading from backup piece /u01/oraback/22lktatm_1_1.rmb\
channel ORA_AUX_DISK_1: piece handle=/u01/oraback/22lktatm_1_1.rmb tag=TAG20100809T104053\
channel ORA_AUX_DISK_1: restored backup piece 1\
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:03:08\
Finished restore at 08/09/10 12:12:29\
\
contents of Memory Script:\
\{\
   switch clone datafile all;\
\}\
executing Memory Script\
\
datafile 1 switched to datafile copy\
input datafile copy RECID=20 STAMP=726581549 file name=/u01/oradata/stg/datafile/system.256.696458617\
datafile 2 switched to datafile copy\
input datafile copy RECID=21 STAMP=726581549 file name=/u01/oradata/stg/datafile/sysaux.257.696458617\
datafile 3 switched to datafile copy\
input datafile copy RECID=22 STAMP=726581550 file name=/u01/oradata/stg/datafile/undotbs1.258.696458617\
datafile 4 switched to datafile copy\
input datafile copy RECID=23 STAMP=726581550 file name=/u01/oradata/stg/datafile/users.259.696458617\
datafile 5 switched to datafile copy\
input datafile copy RECID=24 STAMP=726581551 file name=/u01/oradata/stg/datafile/example.269.696458803\
datafile 6 switched to datafile copy\
input datafile copy RECID=25 STAMP=726581551 file name=/u01/oradata/stg/datafile/abcd_data.272.697114011\
datafile 7 switched to datafile copy\
input datafile copy RECID=26 STAMP=726581551 file name=/u01/oradata/stg/datafile/audit_ts.293.698028255\
\
contents of Memory Script:\
\{\
   set until time  "to_date('08/09/10 10:44:53','mm/dd/yy hh24:mi:ss')";\
   recover\
   clone database\
    delete archivelog\
   ;\
\}\
executing Memory Script\
\
executing command: SET until clause\
\
Starting recover at 08/09/10 12:12:31\
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=681\
channel ORA_AUX_DISK_1: reading from backup piece /u01/oraback/25lktelc_1_1.rmb\
channel ORA_AUX_DISK_1: piece handle=/u01/oraback/25lktelc_1_1.rmb tag=TAG20100809T114443\
channel ORA_AUX_DISK_1: restored backup piece 1\
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03\
archived log file name=/opt/oracle/product/11.2.0/db1/dbs/arch1_681_696458761.dbf thread=1 sequence=681\
channel clone_default: deleting archived log(s)\
archived log file name=/opt/oracle/product/11.2.0/db1/dbs/arch1_681_696458761.dbf RECID=394 STAMP=726581559\
media recovery complete, elapsed time: 00:00:02\
Finished recover at 08/09/10 12:12:41\
\
contents of Memory Script:\
\{\
   shutdown clone immediate;\
   startup clone nomount;\
   sql clone "alter system set  db_name = \
 ''STG'' 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\
\
database dismounted\
Oracle instance shut down\
\
connected to auxiliary database (not started)\
Oracle instance started\
\
Total System Global Area     744910848 bytes\
\
Fixed Size                     1339120 bytes\
Variable Size                444596496 bytes\
Database Buffers             293601280 bytes\
Redo Buffers                   5373952 bytes\
\
sql statement: alter system set  db_name =  ''STG'' 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     744910848 bytes\
\
Fixed Size                     1339120 bytes\
Variable Size                444596496 bytes\
Database Buffers             293601280 bytes\
Redo Buffers                   5373952 bytes\
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "STG" RESETLOGS ARCHIVELOG \
  MAXLOGFILES     16\
  MAXLOGMEMBERS      3\
  MAXDATAFILES      100\
  MAXINSTANCES     8\
  MAXLOGHISTORY      292\
 LOGFILE\
  GROUP  1 ( '+data', '+data' ) SIZE 50 M  REUSE,\
  GROUP  2 ( '+data', '+data' ) SIZE 50 M  REUSE,\
  GROUP  3 ( '+data', '+data' ) SIZE 50 M  REUSE\
 DATAFILE\
  '/u01/oradata/stg/datafile/system.256.696458617'\
 CHARACTER SET AL32UTF8\
\
\
contents of Memory Script:\
\{\
   set newname for tempfile  1 to \
 "/u01/oradata/stg/tempfile/temp.268.696458793";\
   switch clone tempfile all;\
   catalog clone datafilecopy  "/u01/oradata/stg/datafile/sysaux.257.696458617", \
 "/u01/oradata/stg/datafile/undotbs1.258.696458617", \
 "/u01/oradata/stg/datafile/users.259.696458617", \
 "/u01/oradata/stg/datafile/example.269.696458803", \
 "/u01/oradata/stg/datafile/abcd_data.272.697114011", \
 "/u01/oradata/stg/datafile/audit_ts.293.698028255";\
   switch clone datafile all;\
\}\
executing Memory Script\
\
executing command: SET NEWNAME\
\
renamed tempfile 1 to /u01/oradata/stg/tempfile/temp.268.696458793 in control file\
\
cataloged datafile copy\
datafile copy file name=/u01/oradata/stg/datafile/sysaux.257.696458617 RECID=1 STAMP=726581583\
cataloged datafile copy\
datafile copy file name=/u01/oradata/stg/datafile/undotbs1.258.696458617 RECID=2 STAMP=726581583\
cataloged datafile copy\
datafile copy file name=/u01/oradata/stg/datafile/users.259.696458617 RECID=3 STAMP=726581583\
cataloged datafile copy\
datafile copy file name=/u01/oradata/stg/datafile/example.269.696458803 RECID=4 STAMP=726581583\
cataloged datafile copy\
datafile copy file name=/u01/oradata/stg/datafile/abcd_data.272.697114011 RECID=5 STAMP=726581583\
cataloged datafile copy\
datafile copy file name=/u01/oradata/stg/datafile/audit_ts.293.698028255 RECID=6 STAMP=726581583\
\
datafile 2 switched to datafile copy\
input datafile copy RECID=1 STAMP=726581583 file name=/u01/oradata/stg/datafile/sysaux.257.696458617\
datafile 3 switched to datafile copy\
input datafile copy RECID=2 STAMP=726581583 file name=/u01/oradata/stg/datafile/undotbs1.258.696458617\
datafile 4 switched to datafile copy\
input datafile copy RECID=3 STAMP=726581583 file name=/u01/oradata/stg/datafile/users.259.696458617\
datafile 5 switched to datafile copy\
input datafile copy RECID=4 STAMP=726581583 file name=/u01/oradata/stg/datafile/example.269.696458803\
datafile 6 switched to datafile copy\
input datafile copy RECID=5 STAMP=726581583 file name=/u01/oradata/stg/datafile/abcd_data.272.697114011\
datafile 7 switched to datafile copy\
input datafile copy RECID=6 STAMP=726581583 file name=/u01/oradata/stg/datafile/audit_ts.293.698028255\
\
contents of Memory Script:\
\{\
   Alter clone database open resetlogs;\
\}\
executing Memory Script\
\
database opened\
Finished Duplicate Db at 08/09/10 12:13:30\
\
Recovery Manager complete.\
\
}