Steps for cloning in RMAN no catalog mode :
root@venu1> su - oracle
root@venu1> export ORACLE_SID=venu
oracle@venu1> sqlplus / as sysdba
SQL> startup
SQL> select name,open_mode,log_mode from v$database;
SQL> select instance_name from v$instance;
SQL> select name from v$datafile;
SQL> create tablespace venu
datafile '/u01/app/oracle/venu/venu01.dbf'
size 10m autoextend on;
SQL> select name from v$datafile;
SQL> show parameter spfile
SQL> create pfile from spfile;
root@venu1> cd $ORACLE_HOME/dbs
root@venu1 dbs> ls
root@venu1 dbs> scp initvenu.ora venu2:/home/oracle
root@venu1> ssh venu2
root@venu2> su - oracle
oracle@venu2> ls
oracle@venu2> cp initvenu.ora initvenudup.ora
oracle@venu2> mv initvenudup.ora $ORACLE_HOME/dbs
oracle@venu2> cd $ORACLE_HOME/dbs
oracle@venu2 dbs> ls
oracle@venu2 dbs> vi initvenudup.ora
esc shift:%s/u01/u02
db_file_name_convert=('/u03/app/oracle/venu/','/u02/app/oracle/venu/')
log_file_name_convert=('/u03/app/oracle/venu/','/u02/app/oracle/venu/')
:wq!
root@venu2> mkdir -p /u02/app/oracle
root@venu2> chown -R oracle:oinstall /u02/app/oracle
root@venu2> chmod -R 775 /u02/app/oracle
root@venu2> mkdir -p /u02/app/oracle/admin/venu/adump
root@venu2> chown -R oracle:oinstall /u02/app/oracle/admin/venu/adump
root@venu2> chmod -R 775 /u02/app/oracle/admin/venu/adump
root@venu2> mkdir -p /u02/app/oracle/fast_recovery_area/venu
root@venu2> chown -R oracle:oinstall /u02/app/oracle/fast_recovery_area/venu
root@venu2> chmod -R 775 /u02/app/oracle/fast_recovery_area/venu
root@venu2> mkdir -p /u02/app/oracle/venu
root@venu2> chown -R oracle:oinstall /u02/app/oracle/venu
root@venu2> chmod -R 775 /u02/app/oracle/venu
root@venu2> su - oracle
oracle@venu2> cd $ORACLE_HOME/dbs
oracle@venu2 dbs> orapwd file=orapwvenudup password=rac entries=3 force=y
root@venu1> xhost +
root@venu1> ssh -Y oracle@venu2
oracle@venu2> cd /u01/app/oracle/product/11.2.0/db_home/network/admin
oracle@venu2 admin> ls
oracle@venu2 admin> netca --> create listener
oracle@venu2 admin> lsnrctl start listener
oracle@venu2> export ORACLE_SID=venudup
oracle@venu2> sqlplus / as sysdba
SQL> startup nomount
oracle@venu2> cd $ORACLE_HOME/dbs
oracle@venu2 dbs> ls
oracle@venu2 dbs> vi initvenudup.ora
Change database name to venudup
oracle@venu2> export ORACLE_SID=venudup
oracle@venu2> sqlplus / as sysdba
SQL> startup nomount
root@venu1> xhost +
root@venu1> su - oracle
oracle@venu1> cd /u01/app/oracle/product/11.2.0/db_home/network/admin
oracle@venu1 admin> ls
oracle@venu1 admin> netca --> create tnsnames
oracle@venu1 admin> tnsping to_venudup
oracle@venu1> cd $ORACLE_HOME/dbs
oracle@venu1 dbs> ls
oracle@venu1 dbs> orapwd file=orapwvenu password=rac entries=3 force=y
oracle@venu1> export ORACLE_SID=venu
oracle@venu1> rman target sys/rac auxiliary sys/rac@to_venudup
RMAN> duplicate tatget database to venudup from active database;
RMAN> sql 'alter system switch logfile';
RMAN> duplicate tatget database to venudup from active database;
