RMAN duplicate database

10g with ASM

On Target:


Create pfile:
*** All your required memory paramerts ****
##if it from RAC to RAC/Non RAC:
cluster_database=False
#control_files= ==== comment this parameter
db_create_file_dest=
db_create_online_log_dest_1='+_REDO_01'
db_create_online_log_dest_2='+_REDO_02'
undo_tablespace= ( Make sure what are the names your Target RAC uses and put anyone of those here )

Now start the aux instance:

SQL>startup nomount pfile=
resolve any pfile conflicts

On Source:
Verify the files are there on TAPE or disk for the timestamp you want to restore/duplicate the database.

One way:-

#!/bin/ksh
export ORACLE_HOME=/fin03/u0001/oracle/product/10.2.0/db_1
export ORACLE_SID=TARGETDB
#SET UNTIL TIME "TO_DATE('09/15/2011 12:48:00', 'MM/DD/YYYY HH24:MI:SS')" ;
NLS_DATE_FORMAT="MM/DD/YYYY HH24:MI:SS"
export NLS_DATE_FORMAT
/fin03/u0001/oracle/product/10.2.0/db_1/bin/rman msglog logseq_restore_preview.log append<