Starting Duplicate Db at 12-OCT-06
using channel ORA_AUX_DISK_1
RMAN-00571: ===============================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS 
RMAN-00571: ===============================================
RMAN-03002: failure of Duplicate Db command at 10/12/2006 13:26:40
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename F:\ORACLE\ORADATA\MY_DB\DATA\DDIX01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename F:\ORACLE\ORADATA\MY_DB\DATA\DDI01.DBF conflicts with a file used by the target database

RMAN> configure auxname for datafile 'F:\ORACLE\ORADATA\MYDB\data\cattbs.ora' to  'c:\oracle\oradata\sandbox\cattbs.ora';

RMAN> configure auxname for datafile 'F:\ORACLE\ORADATA\MYDB\REDOLOG\REDO4A.LOG' to 'c:\oracle\oradata\sandbox\REDOLOG\REDO4A.LOG';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 10/12/2006 14:09:56
RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: F:\ORACLE\ORADATA\MYDB\REDOLOG\REDO4A.LOG

duplicate target database to your_duplicate_database
PFILE = /yourpfile
LOGFILE
  group 1 ('/yourlogfilepath/redo1_1a',
           '/yourlogfilepath/redo1_1b')  size 128M reuse,
  group 2 ('/yourlogfilepath/redo1_2a',
           '/yourlogfilepath/redo1_2b')  size 128M reuse,
  group 3 ('/yourlogfilepath/redo1_3a',
           '/yourlogfilepath/redo1_3b')  size 128M reuse;
}

set newname for datafile 1 to '/newpath/system';
...
... Simarlarly  for all other files

@/somepath/rename_files.lst
duplicate .... 
..
rest_of_the_business;

RMAN-00571: ===============================================
RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS ======
RMAN-00571: ===============================================
RMAN-03002: failure of Duplicate Db command at 10/13/2006 08:52:18
RMAN-03015: error occurred in stored script Memory Script
ORA-19505: failed to identify file "E:\RMAN_BACKUP\05HVLTNR_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

RMAN> BACKUP DATABASE FORMAT 'e:\rman_backup\%U';
....
piece handle=E:\RMAN_BACKUP\05HVLTNR_1_1 comment=NONE

rman  msglog '/backup/rmanscr/logs/duplicate_prod_test.log' <<EOF ### EOF is unix thing. You can ignore this.
connect target sys/sys@prod                            ### source database that is about to be duplicated
connect catalog rman/rman@rmandb                  ### Rman user. i use seperate users for backup/restore and duplication.
connect auxiliary  sys/sys 		                ###  Target database that would be the cloned database. Make ORACLE_SID is properly set to duplicate database
run {
allocate channel ch1 type disk;                          ### Upto you. depends on your available resources.
..
..
allocate channel chn type disk;
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;  ### again, upto you.
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
set until time "to_date('$dat','MON DD YYYY HH24:MI:SS')";  ### for TSPITR. You do need this for a full restore
@/xxxx/rename_files.lst
duplicate target database to your_duplicate_database
PFILE = /.../initpfile_foryour_duplicateDataabse.ora
LOGFILE
  group 1 ('/yourredolofilepath/redo1_1a',
           '/yourredolofilepath/redo1_1b')  size 128M reuse,
  group 2 ('/yourredolofilepath/redo1_2a',
           '/yourredolofilepath/redo1_2b')  size 128M reuse,
  group 3 ('/yourredolofilepath/redo1_3a',
           '/yourredolofilepath/redo1_3b')  size 128M reuse;
}
exit;
EOF

RMAN> BACKUP DATABASE FORMAT 'e:\rman_backup\%U';
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00013 name=F:\<PATH>\<FILENAME>
input datafile fno=00002 name=F:\<PATH>\<FILENAME_2>
...
...
channel ORA_DISK_1: starting piece 1 at 16-OCT-06
RMAN-00571: ===============================================
RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS ===========
RMAN-00571: ===============================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/16/2006 09:55:22
ORA-00600: internal error code, arguments: [ksuloget4], [], [], [], [], [], [], []

1.  #
2.  ## this is PRE script. Just preparing for a duplication process.
3.  ## It looks lengthy. But a very simple stuff.
4.  #
5.  #!/bin/bash							
6.  export ORACLE_SID=secondary				#SID for duplicate database
7.  export ORACLE_BASE=/u01/base                                    	#Oracle base  
8.  export ORACLE_HOME=/u01/home                                    	#oracle home 
9.  export NLS_DATE_FORMAT='MON DD YYYY HH24:MI:SS'           #this date format is must for TSPITR (may be not in 10g. I have not yet checked)  
10. echo '************************'			#I am using seperate users to backup/restore and clone.	
11. echo ' UNREGISTERING C_SECONDARY    '                           	#C_secondary is the user used to clone the database PRIMARY to SECONDARY
12. echo '************************'                                 #after a successul clone, C_SECONDARY will be looking into duplicate database. 
13. sqlplus -s c_secondary/rman@rmandb <<EOF		#I need to unregister from duplicate and register back to PRIMARY.
14. 	set feed on;                                              		#lines 9-34 will do the same.
15. 	set feed on;
16. 	set serveroutput on;
17. 	prompt
18. 	declare
19. 		key rc_database.db_key%type;
20. 		dbid rc_database.dbid%type;
21. 	begin
22. 	select db_key,dbid into key,dbid from rc_database;
23. 	dbms_output.put_line('dbms_rcvcat.unregisterdatabase('||key||','||dbid||');');
24. 	dbms_rcvcat.unregisterdatabase(key,dbid);
25. 	end;
26. 	/
27. exit;
28. EOF
29. #
30. date
31. #
32. echo '*****************************'
33. echo  REGISTERING C_secondary to primary
34. echo '*****************************'
35. rman target sys/sys@primary rcvcat c_secondary/rman@rmandb <<EOF
36. 	register database;
37. exit;
38. EOF
39. echo '*******************************'             	#I am renaming the files for duplication
40. echo ' Renaming the files for secondary '                       	#In source database PRIMARY datafiles are resding in /u02/oradata/primary 
41. echo '*******************************'                    #I wanted the datafiles for SECONDARY to reside on /secondary
42. sqlplus -s c_secondary/rman@rmandb <<EOF                        	#get the info, just a replace would do the job on the fly
43.  	set heading off;					#spool the output and call it later during DUPLICATION
44. 	set feedback off;					#A subtle change in 10g. Tempfile information is now recorded in catalog.
45. 	set echo off;					#we need to take care of that.	
46. 	set verify off;					#lines 35-57 does all this	
47. 	set termout off;
48. 	set trimspool on;
49. 	set pagesize 3000;
50. 	spool /backup/rmanscr/secondary/rename_secondary.lst;
51.	select 'set newname for datafile '||file#||' to '''||replace(name,'/u02/oradata/primary/','/secondary/') ||''';' 
52. 	from rc_datafile where db_name='PRIMARY';
53. 	select 'set newname for tempfile '||file#||' to '''||replace(name,'/u02/oradata/primary/','/secondary/') ||''';' 
54.	 from rc_tempfile where db_name='PRIMARY';
55. 	spool off;
56. exit;
57. EOF
58. #
59. echo '**********************************'		#duplication should be done in nomount stage.
60. echo 'Bring secondary to NOMOUNT stage'                         	#i already have a seperate copy of initpfile in a location. 
61. echo '**********************************'
62. sqlplus "sys/sys@secondary as sysdba" <<EOF 
63. 	shutdown abort;
64. 	startup nomount pfile='/backup/rmanscr/secondary/initsecondary.ora';
65. exit;
66. EOF
67. echo
68. echo
69. echo '******************************************************************'
70. echo '          completed pre_duplicate_prod_secondary			'
71. echo '          check whether ORACLE_SID=secondary     			'
72. echo '          run duplicate_primary_secondary				'
73. echo '******************************************************************'

1.  #
2.  ####This is the actual duplication script
3.  #!/bin/bash
4.  export ORACLE_SID=secondary				
5.  export ORACLE_BASE=/u01/base
6.  export ORACLE_HOME=/u01/home
7.  export NLS_DATE_FORMAT='MON DD YYYY HH24:MI:SS'				#When executed from unix command line, this line will prompt for
8.  export SERVER=`uname -n`							#timstamp. RMAN will perform a TSPITR based duplication until a point in time specified here.
9.  echo "Please enter the time in the format - MON DD YYYY HH24:MI:SS
10. For Example : AUG 20 2006 09:00:00
11. Please enter the time: \c"
12. read dat
13. rman target sys/sys@primary rcvcat c_secondary/rman@rmandb <<EOF                	#Just a resync to make sure C_SECONDARY is seeing all latest backupsets.
14. 	resync catalog;
15. exit;
16. EOF
17. rman  msglog '/backup/rmanscr/logs/duplicate_primary_secondary.log' <<EOF      		#A logfile duplicate_primary_secondary.log is created where all information is redirected (from display).
18. 	connect target sys/sys@primary						#Connect to target database which is about to be duplicated	
19. 	connect catalog c_secondary/rman@rmandb					#connect to catalog
20. 	connect auxiliary  sys/sys							#Connect to AUXILLARY instance (duplicate instance) that is identified by line-4
21. 	run {									#Allocating channels. Number of channels is upto you.  More than one channel is preferred.
22. 	allocate channel ch1 type disk;
23. 	allocate channel ch2 type disk;
24. 	allocate channel ch3 type disk;
25. 	allocate channel ch4 type disk;
26. 	allocate channel ch5 type disk;
27. 	allocate channel ch6 type disk;
28. 	ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;				#Allocation some aux channels. Again, number of channels, upto you.
29. 	ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
30. 	ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
31. 	set until time "to_date('$dat','MON DD YYYY HH24:MI:SS')";			#asking RMAN to do an incomplete TSPITR based duplication. Timestamp is read from command line
32. 	@/backup/rmanscr/secondary/rename_secondary.lst				#remember the file we created. This file will have the list of files to be renamed.
33. 	duplicate target database to secondar					#This single line RMAN command does all the magic. All the rest we did, is just to facilitate us.
34. 	PFILE = /backup/rmanscr/secondary/initsecondary.ora				#You can even skip the tablespaces you want and do a selective/partial duplication.
35. 	LOGFILE									#create logfiles on the fly
36.	GROUP 1 ('/secondary/redo1a.log',
	     '/secondary/redo1b.log')  SIZE 128M REUSE,
37. 	GROUP 2 ('/secondary/redo2a.log',
  	     '/secondary/redo2b.log')  SIZE 128M REUSE;
38. 	}
39. exit;
40. ### Just some post duplication work.						#You do not need this
41. sqlplus "sys/sys@secondary as sysdba" <<EOF					#It is all the customizations you want to be doing after the duplication is done.
42. 	shutdown;								#If you are duplication into a RAC database, then create more threads here.	
43. 	startup mount exclusive pfile='/backup/rmanscr/secondary/initsecondary.ora';
44. 	alter database noarchivelog;
45. 	alter database open;
46. 	shutdown;
47. 	startup open pfile='/backup/rmanscr/secondary/initsecondary.ora';
48. 	create spfile='/secondary/spfilesecondary.ora' from pfile='/backup/rmanscr/secondary/initsecondary.ora';
49. 	shutdown;
50. 	startup
51. 	create pfile='/backup/rmanscr/secondary/initsecondary.ora' from spfile;
52. 	create temporary tablespace temp2  tempfile  '/secondary/temp2'
		size 2048 M reuse
		extent management local
		uniform size 1m ;
53. 	ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
54. 	drop tablespace temp including contents;
55. EOF

...
starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\SANDBOX\SYSTEM01.DBF'

RMAN-00571: ===============================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOWS ============
RMAN-00571: ===============================================
RMAN-03002: failure of Duplicate Db command at 10/18/2006 15:03:19
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 14888 scn 286281916 found to restore
RMAN-06025: no backup of log thread 1 seq 14887 scn 286254120 found to restore
RMAN-06025: no backup of log thread 1 seq 14765 scn 283934114 found to restore

RMAN>

RMAN> CROSSCHECK ARCHIVELOG ALL
and
RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\SANDBOX\SYSTEM01.DBF'

RMAN-00571: ===============================================
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================
RMAN-03002: failure of Duplicate Db command at 10/20/2006 15:53:16
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 14904 scn 286635889 found to restore
RMAN-06025: no backup of log thread 1 seq 14765 scn 283934114 found to restore

RMAN>

RMAN> SHOW ALL;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   'f:\rman_backup\%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA92\DATABASE\SNCFMYDB.ORA'; # default
CONFIGURE AUXNAME FOR DATAFILE 'F:\ORACLE\ORADATA\MYDB\DATA\SYSTEM01.DBF' TO 'C:\ORACLE\ORADATA\SANDBOX\SYSTEM01.DBF
...
CONFIGURE AUXNAME FOR DATAFILE 'F:\ORACLE\ORADATA\MYDB\DATA\UNDOTBS01.DBF' TO 'C:\ORACLE\ORADATA\SANDBOX\UNDOTBS01.D

RMAN>

...
RMAN-00571: ===============================================
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===============================================
RMAN-03002: failure of Duplicate Db command at 10/27/2006 10:38:35
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
...

RMAN>

RMAN> RUN {
	SET UNTIL TIME "to_date('OCT-25-2006 13:30:00','MON-DD-YYYY HH24:MI:SS')";
	DUPLICATE TARGET DATABASE TO sandbox
	PFILE=c:\oracle\init_data\init_sandbox.ora
	LOGFILE group 1 ('c:\oracle\oradata\sandbox\redolog\redo1_1a','c:\oracle\oradata\sandbox\redolog\redo1_1b')  size 128M reuse,
		group 2 ('c:\oracle\oradata\sandbox\redolog\redo1_2a','c:\oracle\oradata\sandbox\redolog\redo1_2b')  size 128M reuse,
		group 3 ('c:\oracle\oradata\sandbox\redolog\redo1_3a','c:\oracle\oradata\sandbox\redolog\redo1_3b')  size 128M reuse;
}

RMAN> LIST BACKUP;
...
BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12448   606M       DISK        00:00:35     25-OCT-06
        BP Key: 12466   Status: AVAILABLE   Tag: TAG20061025T130339
        Piece Name: F:\RMAN_BACKUP\3QI0NR40_1_1

  List of Archived Logs in backup set 12448
  Thrd   Seq     Low SCN    Low Time  Next SCN   Next Time
...
   1    14765   283934114  12-OCT-06 283967476  12-OCT-06
...

RMAN>

sql>alter system switch logfile;

RMAN>backup database plus archivelog;

RMAN>list incarnation of database

rman> catalog archivelog '/mydir/myarchivelog';

RMAN> LIST INCARNATION OF database;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       2       NMED_DB  3309219400       YES 190578     15-JUN-04

RMAN>

SQL> RECOVER database USING BACKUP CONTROLFILE UNTIL CANCEL;
... [here I specified the location of each of the necessary log files... 14765 was not needed]
SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL>

RMAN>SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RMAN>BACKUP ARCHIVELOG ALL;

SET UNTIL TIME "to_date('OCT-25-2006 13:30:00','MON-DD-YYYY HH24:MI:SS')"

SET UNTIL SEQUENCE 14765 THREAD 1;

RMAN> BACKUP database PLUS archivelog;

RMAN-06023: no backup or copy of datafile 20 found to restore

RMAN-06025: no backup of log thread 1 seq 14765 scn 283934114 found to restore