Rman output script for creating DUPLICATE database
                                                 Last update (2009-11-11 16:33:11)
                                                                                                                   Date added (2009-11-11 14:54:48)

This are the Rman steps executed from : Clone database with RMAN
allocated channel: ch01
channel ch01: sid=9 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 6.5 (2009050107)

sent command to channel: ch01

Starting Duplicate Db at 11-11-2009 13:12

printing stored script: Memory Script
{
   set until scn  6121687763194;
   set newname for datafile  1 to 
 "/orandr/ANDR/datafiles_new/system01.dbf";
   set newname for datafile  3 to 
 "/orandr/ANDR/datafiles_new/indx01.dbf";
   set newname for datafile  4 to 
 "/orandr/ANDR/datafiles_new/tools01.dbf";
   set newname for datafile  5 to 
 "/orandr/ANDR/datafiles_new/users01.dbf";
   set newname for datafile  6 to 
 "/orandr/ANDR/datafiles_new/testtab01.dbf";
   set newname for datafile  7 to 
 "/orandr/ANDR/datafiles_new/mst_tab01.dbf";
   set newname for datafile  8 to 
 "/orandr/ANDR/datafiles_new/undotbs_01.dbf";
   set newname for datafile  9 to 
 "/orandr/ANDR/datafiles_new/dr01.dbf";
   restore
   check readonly
   clone database
   ;
}
executing script: 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

Starting restore at 11-11-2009 13:12

channel ch01: starting datafile backupset restore
channel ch01: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /orandr/ANDR/datafiles_new/tools01.dbf
restoring datafile 00007 to /orandr/ANDR/datafiles_new/mst_tab01.dbf
restoring datafile 00009 to /orandr/ANDR/datafiles_new/dr01.dbf
channel ch01: restored backup piece 1
piece handle=BACKUP_ONLINE_ANDR_8uktoiot_1_1:702303005.dbf tag=TAG20091107T121005 params=NULL
channel ch01: restore complete
channel ch01: starting datafile backupset restore
channel ch01: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /orandr/ANDR/datafiles_new/indx01.dbf
restoring datafile 00005 to /orandr/ANDR/datafiles_new/users01.dbf
restoring datafile 00008 to /orandr/ANDR/datafiles_new/undotbs_01.dbf
channel ch01: restored backup piece 1
piece handle=BACKUP_ONLINE_ANDR_8vktoiot_1_1:702303005.dbf tag=TAG20091107T121005 params=NULL
channel ch01: restore complete
channel ch01: starting datafile backupset restore
channel ch01: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /orandr/ANDR/datafiles_new/system01.dbf
channel ch01: restored backup piece 1
piece handle=BACKUP_ONLINE_ANDR_8tktoiot_1_1:702303005.dbf tag=TAG20091107T121005 params=NULL
channel ch01: restore complete
channel ch01: starting datafile backupset restore
channel ch01: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /orandr/ANDR/datafiles_new/testtab01.dbf
channel ch01: restored backup piece 1
piece handle=BACKUP_ONLINE_ANDR_90ktoiot_1_1:702303005.dbf tag=TAG20091107T121005 params=NULL
channel ch01: restore complete
Finished restore at 11-11-2009 13:38
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG 
  MAXLOGFILES      5
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      226
 LOGFILE
  GROUP  1 ( '/orandr/ANDR/redologs_new/redolog1.log' ) SIZE  104857600  REUSE,
  GROUP  2 ( '/orandr/ANDR/redologs_new/redolog2.log' ) SIZE  104857600  REUSE,
  GROUP  3 ( '/orandr/ANDR/redologs_new/redolog3.log' ) SIZE  104857600  REUSE,
  GROUP  4 ( '/orandr/ANDR/redologs_new/redolog4.log' ) SIZE  104857600  REUSE,
  GROUP  5 ( '/orandr/ANDR/redologs_new/redolog5.log' ) SIZE  104857600  REUSE
 DATAFILE
  '/orandr/ANDR/datafiles_new/system01.dbf'
 CHARACTER SET EL8ISO8859P7


printing stored script: Memory Script
{
   switch clone datafile all;
}
executing script: Memory Script

datafile 3 switched to datafile copy
input datafilecopy recid=1 stamp=702653890 filename=/orandr/ANDR/datafiles_new/indx01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=2 stamp=702653890 filename=/orandr/ANDR/datafiles_new/tools01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=3 stamp=702653890 filename=/orandr/ANDR/datafiles_new/users01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=4 stamp=702653890 filename=/orandr/ANDR/datafiles_new/testtab01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=5 stamp=702653890 filename=/orandr/ANDR/datafiles_new/mst_tab01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=6 stamp=702653890 filename=/orandr/ANDR/datafiles_new/undotbs_01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=7 stamp=702653890 filename=/orandr/ANDR/datafiles_new/dr01.dbf

printing stored script: Memory Script
{
   set until time  "SYSDATE-3";
   recover
   clone database
    delete archivelog
   ;
}
executing script: Memory Script

executing command: SET until clause

Starting recover at 11-11-2009 13:38

starting media recovery

channel ch01: starting archive log restore to default destination
channel ch01: restoring archive log
archive log thread=1 sequence=10746
channel ch01: restored backup piece 1
piece handle=BACKUP_ARCHIVELOGS_ANDR_91ktp7nf_1_1:702324463.arch tag=TAG20091107T180743 params=NULL
channel ch01: restore complete
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10746.dbf thread=1 sequence=10746
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10746.dbf recid=1 stamp=702654419
channel ch01: starting archive log restore to default destination
channel ch01: restoring archive log
archive log thread=1 sequence=10747
channel ch01: restored backup piece 1
piece handle=BACKUP_ARCHIVELOGS_ANDR_92ktpsqh_1_1:702346065.arch tag=TAG20091108T000745 params=NULL
channel ch01: restore complete
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10747.dbf thread=1 sequence=10747
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10747.dbf recid=2 stamp=702654768
channel ch01: starting archive log restore to default destination
channel ch01: restoring archive log
archive log thread=1 sequence=10748
channel ch01: restoring archive log
archive log thread=1 sequence=10749
channel ch01: restoring archive log
archive log thread=1 sequence=10750
channel ch01: restoring archive log
archive log thread=1 sequence=10751
channel ch01: restoring archive log
archive log thread=1 sequence=10752
channel ch01: restored backup piece 1
piece handle=BACKUP_ARCHIVELOGS_ANDR_93ktqhu3_1_1:702367683.arch tag=TAG20091108T060803 params=NULL
channel ch01: restore complete
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10748.dbf thread=1 sequence=10748
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10748.dbf recid=7 stamp=702655140
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10749.dbf thread=1 sequence=10749
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10749.dbf recid=3 stamp=702655140
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10750.dbf thread=1 sequence=10750
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10750.dbf recid=4 stamp=702655140
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10751.dbf thread=1 sequence=10751
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10751.dbf recid=5 stamp=702655140
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10752.dbf thread=1 sequence=10752
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10752.dbf recid=6 stamp=702655140
channel ch01: starting archive log restore to default destination
channel ch01: restoring archive log
archive log thread=1 sequence=10753
channel ch01: restoring archive log
archive log thread=1 sequence=10754
channel ch01: restoring archive log
archive log thread=1 sequence=10755
channel ch01: restoring archive log
archive log thread=1 sequence=10756
channel ch01: restoring archive log
archive log thread=1 sequence=10757
channel ch01: restored backup piece 1
piece handle=BACKUP_ARCHIVELOGS_ANDR_94ktqhu3_1_1:702367683.arch tag=TAG20091108T060803 params=NULL
channel ch01: restore complete
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10753.dbf thread=1 sequence=10753
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10753.dbf recid=12 stamp=702655521
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10754.dbf thread=1 sequence=10754
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10754.dbf recid=9 stamp=702655521
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10755.dbf thread=1 sequence=10755
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10755.dbf recid=10 stamp=702655521
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10756.dbf thread=1 sequence=10756
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10756.dbf recid=11 stamp=702655521
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10757.dbf thread=1 sequence=10757
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10757.dbf recid=8 stamp=702655504
channel ch01: starting archive log restore to default destination
channel ch01: restoring archive log
archive log thread=1 sequence=10758
channel ch01: restored backup piece 1
piece handle=BACKUP_ARCHIVELOGS_ANDR_95ktr70a_1_1:702389258.arch tag=TAG20091108T120738 params=NULL
channel ch01: restore complete
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10758.dbf thread=1 sequence=10758
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10758.dbf recid=13 stamp=702655876
channel ch01: starting archive log restore to default destination
channel ch01: restoring archive log
archive log thread=1 sequence=10759
channel ch01: restored backup piece 1
piece handle=BACKUP_ARCHIVELOGS_ANDR_96ktrs3a_1_1:702410858.arch tag=TAG20091108T180738 params=NULL
channel ch01: restore complete
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10759.dbf thread=1 sequence=10759
channel clone_default: deleting archive log(s)
archive log filename=/orandr/ANDR/9.2.0/dbs/arch1_10759.dbf recid=14 stamp=702656231
media recovery complete
Finished recover at 11-11-2009 14:17

printing stored script: Memory Script
{
   shutdown clone;
   startup clone nomount ;
}
executing script: Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     165638760 bytes

Fixed Size                      737896 bytes
Variable Size                113246208 bytes
Database Buffers              50331648 bytes
Redo Buffers                   1323008 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG 
  MAXLOGFILES      5
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      226
 LOGFILE
  GROUP  1 ( '/orandr/ANDR/redologs_new/redolog1.log' ) SIZE  104857600  REUSE,
  GROUP  2 ( '/orandr/ANDR/redologs_new/redolog2.log' ) SIZE  104857600  REUSE,
  GROUP  3 ( '/orandr/ANDR/redologs_new/redolog3.log' ) SIZE  104857600  REUSE,
  GROUP  4 ( '/orandr/ANDR/redologs_new/redolog4.log' ) SIZE  104857600  REUSE,
  GROUP  5 ( '/orandr/ANDR/redologs_new/redolog5.log' ) SIZE  104857600  REUSE
 DATAFILE
  '/orandr/ANDR/datafiles_new/system01.dbf'
 CHARACTER SET EL8ISO8859P7


printing stored script: Memory Script
{
   catalog clone datafilecopy  "/orandr/ANDR/datafiles_new/indx01.dbf";
   catalog clone datafilecopy  "/orandr/ANDR/datafiles_new/tools01.dbf";
   catalog clone datafilecopy  "/orandr/ANDR/datafiles_new/users01.dbf";
   catalog clone datafilecopy  "/orandr/ANDR/datafiles_new/testtab01.dbf";
   catalog clone datafilecopy  "/orandr/ANDR/datafiles_new/mst_tab01.dbf";
   catalog clone datafilecopy  "/orandr/ANDR/datafiles_new/undotbs_01.dbf";
   catalog clone datafilecopy  "/orandr/ANDR/datafiles_new/dr01.dbf";
   switch clone datafile all;
}
executing script: Memory Script

cataloged datafile copy
datafile copy filename=/orandr/ANDR/datafiles_new/indx01.dbf recid=1 stamp=702656299

cataloged datafile copy
datafile copy filename=/orandr/ANDR/datafiles_new/tools01.dbf recid=2 stamp=702656314

cataloged datafile copy
datafile copy filename=/orandr/ANDR/datafiles_new/users01.dbf recid=3 stamp=702656326

cataloged datafile copy
datafile copy filename=/orandr/ANDR/datafiles_new/testtab01.dbf recid=4 stamp=702656338

cataloged datafile copy
datafile copy filename=/orandr/ANDR/datafiles_new/mst_tab01.dbf recid=5 stamp=702656351

cataloged datafile copy
datafile copy filename=/orandr/ANDR/datafiles_new/undotbs_01.dbf recid=6 stamp=702656362

cataloged datafile copy
datafile copy filename=/orandr/ANDR/datafiles_new/dr01.dbf recid=7 stamp=702656376

datafile 3 switched to datafile copy
input datafilecopy recid=1 stamp=702656299 filename=/orandr/ANDR/datafiles_new/indx01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=2 stamp=702656314 filename=/orandr/ANDR/datafiles_new/tools01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=3 stamp=702656326 filename=/orandr/ANDR/datafiles_new/users01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=4 stamp=702656338 filename=/orandr/ANDR/datafiles_new/testtab01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=5 stamp=702656351 filename=/orandr/ANDR/datafiles_new/mst_tab01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=6 stamp=702656362 filename=/orandr/ANDR/datafiles_new/undotbs_01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=7 stamp=702656376 filename=/orandr/ANDR/datafiles_new/dr01.dbf

printing stored script: Memory Script
{
   Alter clone database open resetlogs;
}
executing script: Memory Script

database opened
Finished Duplicate Db at 11-11-2009 14:20

RMAN> exit

Recovery Manager complete.
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search