Creating a Duplicate Database in using RMAN in 10g(windows platform), Same server with different file structure

Hi,
Please find the below steps for creating a duplicate DB in 10g

• Step1(take proper backup & list backups ensure control file auto backup on)

        Take RMAN backup from primary database(please refer the attachment)

        List all the backups from RMAN

        Now see if any backups are taken in different location(my case i put all the backups in "D:\rman_backup") ,
        My case i moved controlfile autobackup from 'C:\oracle\product\10.2.0\db_1\flash_recovery_area\ORCL\AUTOBACKUP\2012_01_12\O1_MF_S_772414891_7JY8LSN2_' to 'D:\rman_backup\'

        Catalog any of the moved backuppiece in RMAN


RMAN> catalog backuppiece 'D:\rman_backup\O1_MF_S_772414891_7JY8LSN2_.BKP';

cataloged backuppiece
backup piece handle=D:\RMAN_BACKUP\O1_MF_S_772414891_7JY8LSN2_.BKP recid=57 stamp=772416237

• Prepare a proper init file for the new database , please find the below file i used(note log_file_name_convert & db_file_name_convert parameters)

        Content of initDUP.ora

*.audit_file_dest='D:\dup\adump'

*.background_dump_dest='D:\dup\bdump'

*.compatible='10.2.0.1.0'

*.control_files='D:\dup\control01.ctl','D:\dup\control02.ctl','D:\dup\control03.ctl'

*.core_dump_dest='D:\dup\cdump'

*.cursor_sharing='SIMILAR'

*.db_block_size=8192

*.db_create_file_dest='D:\dup\'

*.db_create_online_log_dest_1='D:\dup\redolog\'

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_file_name_convert='C:\oracle\product\10.2.0\oradata\orcl\','D:\dup\','C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\','D:\dup\','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORCL\DATAFILE\','D:\dup\'

*.log_file_name_convert='C:\oracle\product\10.2.0\oradata\orcl\','D:\dup\redolog\','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDOLOG\ORCL\ONLINELOG\','D:\dup\redolog\'

*.db_name='orcldup'

*.db_recovery_file_dest='D:\dup\flash_recovery_area\'

*.db_recovery_file_dest_size=6442450944

*.dg_broker_start=TRUE

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.global_names=TRUE

*.job_queue_processes=10

*.log_archive_dest_1='location=D:\dup\archive valid_for=(all_logfiles,all_roles)'

*.nls_date_format='YYYY/MM/DD HH24:MI:SS'

*.nls_time_format='YYYY/MM/DD HH24:MI:SS'

*.open_cursors=300

*.optimizer_mode='all_rows'

*.pga_aggregate_target=96468992

*.processes=150

*.query_rewrite_integrity='TRUSTED'

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=290455552

*.sql_trace=TRUE

*.standby_file_management='AUTO'

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='D:\dup\udump'

         Create a new instance in windows using

  

C:\Windows\system32>oradim -new -sid orcldup

Instance created.

     Start the instance with the pfile

now exit from sqlplus and go to RMAN for restoration, connect to both target & auxiliary as in the screenshots

Now login & check you should have your duplicate database ready..... enjoy...:)