Simplified DBA 027- 02- Cloning Oracle Database using Duplicate from ACTIVE Database command

Demo : cloning oracle database from an Active Database
------------------------------------------------------

CLONING DB11LIN TO DB11CLN

1. Create pfile with ONE parameters only

DB_NAME=DB11CLN



2. Create directories

mkdir -p /u01/app/oracle/admin/DB11CLN/adump
mkdir -p /u01/app/oracle/admin/DB11CLN/pfile

mkdir -p /u01/app/oracle/oradata/DB11CLN
mkdir -p /u01/app/oracle/fast_recovery_area/DB11CLN



3. create password file for DB11CLN


cd $ORACLE_HOME/dbs
cp orapwDB11LIN orapwDB11CLN



4. edit TNSNAMES.ORA entry for DB11CLN

DB11CLN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node32.ansaridba.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB11CLN)
)
)



5. edit listener.ora file for SID_NAME

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DB11LIN)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = DB11LIN)
)
(SID_DESC =
(GLOBAL_DBNAME = DB11CLN)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = DB11CLN)
)
)


6. Start auxiliary insance in nomount

export ORACLE_SID=DB11CLN
sqlplus / as sysdba
startup nomount pfile=$ORACLE_HOME/dbs/initDB11CLN.ORA




7. create rman.txt script


run{
DUPLICATE TARGET DATABASE TO DB11CLN FROM ACTIVE DATABASE
spfile parameter_value_convert 'DB11LIN','DB11CLN'
set db_unique_name='DB11CLN'
set db_create_file_dest='/u01/app/oracle/oradata/DB11CLN'

set db_recovery_file_dest='/u01/app/oracle/oradata/DB11CLN'

set db_file_name_convert='/DB11LIN/','/DB11CLN/'

set log_file_name_convert='/DB11LIN/','/DB11CLN/'

set log_archive_max_processes='5'
;
}





7. Connect RMAN using password file and TNSNAMES entry

export ORACLE_SID=DB11CLN

rman target sys/Welcome1@DB11LIN auxiliary sys/Welcome1@DB11CLN
@rman.txt