2 minutes readClone/Duplicate Database from ASM to Non-ASM

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
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
DB FILE LOCATION: /DB/INDIAN/DATABASE

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 standby server
– configure listener.

In Primary 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

• Control_files=’/DB/INDIAN/DATABASE/CONTROL.ct
• Set db_file_name_convert and log_file_name_convert to convert the diskgroup.

Example:

DB_FILE_NAME_CONVERT= (‘+DB_DATA01′,’/DB/INDIAN/DATABASE/’)
LOG_FILE_NAME_CONVERT= (‘+DB_DATA01′,’/DB/INDIAN/DATABASE/’)

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

Step 7 Startup Clone Instance with Nomount option

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

Step 5 invoke RMAN
$ rman target sys/anup123@indian auxiliary /

Step 6 Execute bellow mention command on RMAN prompt.

RMAN> duplicate target database to “CLONE”;