Step by Step Duplicating Oracle Database Using RMAN Backup With Connection To Target Database
Step by Step Duplicating Oracle Database Using RMAN Backup With Connection To Target Database
Step by Step Duplicating Oracle Database Using RMAN Backup With Connection To Target Database
database:-
Details:
Oracle EE 11.2 on RHEL5
Target Server: 192.168.195.128
Clone Server: 192.168.195.137
As we are duplicating to a different we can use same SID for both Source and Clone. My source DBID is HCL
Step3. Configure tnsnames and listener at source and clone server as below:
At Source Server
--------------------------------------------------------------------
HCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.195.137)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HCL)
)
)
---------------------------------------------------------------------
At Clone Server
----------------------------------------------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = HCL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = HCL)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.195.137)(PORT = 1521))
)
------------------------------------------------------------------------
Step6. Create required directories at Clone server. Here I'm using same filesystem as source so no need to use
DB_FILE_NAME_CONVERT
mkdir -p /u01/app/oracle/oradata/HCL
mkdir -p /u01/app/oracle/flash_recovery_area/HCL
mkdir -p /u01/app/oracle/admin/HCL
cd /u01/app/oracle/admin/HCL
mkdir adump dpdump
Step8. At Remote Server set ORACLE_SID=HCL and start the Clone Server in NOMOUNT mode
SQL> STARTUP NOMOUNT;
database mounted
database dismounted
Oracle instance shut down
sql statement: alter system set db_name = ''HCL'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
DATAFILE
'/u01/app/oracle/oradata/HCL/system01.dbf'
CHARACTER SET WE8MSWIN1252
database opened
Finished Duplicate Db at 27-JAN-13
RMAN>