Source(TARGET) instance information:
Instance name=DLINK
hostname=mydbt4db2
datafile location=/u03/oradata/DLINK, /u02/oradata/DLINK
Redolog file location=/u03/oradata/DLINK
Archive log file location=/u02/oradata/arch
Auxiliary instance (RLINK) information:
Instance name=RLINK
hostname=mydbt4db4
datafile location=/u03/oradata/RLINK, /u02/oradata/RLINK
Redolog file location=/u03/oradata/RLINK
Archive log file location=/u02/oradata/arch_RLINK
1) Create required directory structure at
auxiliary side
[oracle@mydbt4db4 admin]$ mkdir -p
/u02/oradata/RLINK
[oracle@mydbt4db4 admin]$ mkdir -p
/u03/oradata/RLINK
[oracle@mydbt4db4 admin]$ mkdir -p
/u02/oradata/arch_RLINK
2) Define ORACLE_SID and other
required settings for auxiliary instance
[oracle@mydbt4db4 ~]$ vi .bash_profile
[oracle@mydbt4db4 ~]$ pwd
/home/oracle
[oracle@mydbt4db4 ~]$ . .bash_profile
[oracle@mydbt4db4 ~]$ echo $ORACLE_SID
RLINK
[oracle@mydbt4db4 ~]$
3) Creating initialization
Parameter file for the Auxiliary instance(RLINK)
[oracle@mydbt4db4 dbs]$ vi initTLINK.ora
[oracle@mydbt4db4 dbs]$ cat initTLINK.ora
db_name='RLINK'
memory_target=200M
db_block_size=8192
control_files ='/u02/oradata/RLINK/control1.ctl','/u03/oradata/RLINK/control2.ctl'
compatible ='11.2.0'
log_archive_dest=/u02/oradata/arch_RLINK
log_file_name_convert='/u03/oradata/DLINK','/u03/oradata/RLINK'
db_file_name_convert='/u03/oradata/DLINK','/u03/oradata/RLINK','/u02/oradata/DLINK','/u02/oradata/RLINK'
4) Create
password file at auxiliary side(TLINK)
[oracle@mydbt4db4 ~]$ cd $ORACLE_HOME/dbs
[oracle@mydbt4db4 dbs]$ orapwd
file=orapw$ORACLE_SID password=sys force=y
[oracle@mydbt4db4 dbs]$ ls -ltr orapwR*
-rw-r----- 1 oracle oinstall 1536 Nov 26 16:55
orapwRLINK
[oracle@mydbt4db4 dbs]$
5) Take a
backup of the database Source
RMAN> backup database plus archivelog;
Starting backup at 26-NOV-12
current log archived
configuration for DISK channel 2 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting archived log backup
set
channel ORA_DISK_1: specifying archived log(s) in
backup set
.
.
.
.
Starting Control File and SPFILE Autobackup at
26-NOV-12
piece
handle=/u02/oradata/rman_bkp/c-2903807241-20121126-00 comment=NONE
Finished Control File and SPFILE Autobackup at
26-NOV-12
6) Prepare for
duplicate by starting the auxiliary instance
[oracle@mydbt4db4 rman_bkp]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Mon
Nov 26 08:41:59 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
.
7) Copy
the backupsets from source to your auxiliary server
If the duplicate is going to happen on
different server, move the backup pieces to a new server using commands like
ftp,scp etc
[oracle@mydbt4db2 rman_bkp]$ scp * oracle@192.168.3.19:/u02/oradata/RMAN_BKP
8) Connect
to the auxiliary instance from RMAN and perform the rman duplicate as follows
rman auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production
on Mon Nov 26 20:41:32 2012
Copyright (c) 1982, 2009, Oracle and/or its
affiliates. All rights reserved.
connected to auxiliary database: RLINK (not
mounted)
RMAN>
DUPLICATE DATABASE TO 'RLINK'
2> BACKUP LOCATION '/u02/oradata/RMAN_BKP';
Starting Duplicate Db at 26-NOV-12
contents of Memory Script:
{
sql
clone "create spfile from memory";
}
.
.
.
.
.
executing Memory Script
contents of Memory Script:
{
Alter
clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 26-NOV-12
