2 minutes readClone/Duplicate a ASM Enable Database to ASM Enable TARGET System

Source Setup Details:

Host Name: SUN1
IP: 192.168.126.2
Oracle Home: /export/home/oracle/oracle/product/db_1
DB Name: INDIAN
PORT: 1521
ASM DISK GROUP: DB_DATA01

Target Setup Details:

Host Name: SUN2
IP: 192.168.126.3
Oracle Home: /export/home/oracle/oracle/product/db_1
DB Name: CLONE
PORT: 1521
ASM DISK GROUP: CLN_DATA01

Step 1 Perform the backup of the ASM primary database (Datafiles, Control file for standby & Archive logs)

$ rman target /
RMAN>backup database format ‘/export/home/oracle/rman/database_%U.bkp’;

Step 2 Make the backup pieces available on the Standby server

• FTP or SCP the backup pieces to standby server. While doing FTP make sure to do it in binary mode only. OR

• NFS mount then mount the NFS on standby server with the same name as you mounted on primary database. OR

• If the backups are on tape then make sure that you make proper changes on standby server so that you can restore the backups on standby server.

Note: RMAN backup set mount point must be same.

Step 3 Create the password file for standby database with the same password as primary

$ export ORACLE_SID=CLONE
$orapwd file=orapwCLONE password=

Step 4 Configure Oracle net services on both the servers

In Target server
– configure listener.

In Source server
– configure tnsnames for standby.
– check connectivity using tnsping.

Step 5 Copy primary database initINDIAN.ora to auxiliary instance and rename to initCLONE.ora

Step 6 Modify initCLONE.ora file

• If not using OMF for control files, set the CONTROL_FILES parameter to the appropriate location. Otherwise, do not set this parameter.

• Set db_file_name_convert and log_file_name_convert to convert the diskgroup.

Example:

DB_FILE_NAME_CONVERT = (‘+DB_DATA01’, ‘+CLN_DATA01’)
LOG_FILE_NAME_CONVERT = (‘+DB_DATA01’, ‘+CLN_DATA01’)

• For a duplicate database that is not a standby database, change the value of the DB_NAME initialization parameter.

• Set the DB_CREATE_FILE_DEST initialization parameter to the desired OMF storage location.

Example:
*.DB_CREATE_FILE_DEST = ‘+CLN_DATA01’

Step 7 Startup Clone Instance with Nomount option

Export ORACLE_SID=CLONE
Sqlplus /nolog
Conn / as sysdba
Startup nomount

Step 8 invoke RMAN

$ rman target sys/anup123@indian auxiliary /

Step 9 Execute bellow mention command on RMAN prompt.

RMAN> duplicate target database to “CLONE”;