RMAN CLONNING WITH ACTIVEDUPLICATION:
Steps in source database:
STEP1:verify whether the database is up with pfile or spfile if started with spfile create a pfile from spfile and transfer the pfile to the target database through scp
STEP2:Transfer the password file which is present in the $ORACLE_HOME/dbs location to the target database
Steps in target database:
STEP1:edit the pfile for db_name, controlfile, and add two parameters called db_file_name_convert which will carry all the datafiles to the location mentioned in the db_file_name_convert this also applies for the log files by the parameter log_file_name_convert
STEP2:start the database with pfile and get the database to nomount stage
STEP3:create the listener in the target database and source database and create the TNS entry of the source database in the target database
STEP4:connect to rman utility target database and auxiliary database by providing the command rman target sys/oracle@tns_entry auxiliary sys/oracle, connecting to auxiliary database will create a new database in target location.
STEP5:after getting connected to auxiliary database issue the command in the utility
Duplicate database to ‘database_name’ from active database nofilenamecheck;
NOFILENAMECHECK:if the database are in different hosts and if we want the files to be in the location that we mentioned in the pfile, we must include this parameter
STEP6:Verify the clonned database
Posted by:Sakthi Sethu Perumal S
