Database Clone Using RMAN on same server with connection to Target and Catalog DB.
My Environment Operating System : RHEL 6.4 64 Bit DB Version : 12CR1 [12.1.0.1.0] Primary DB Name : ORCL Primary DB Mount Point : /PRIM Clone DB Name : ORATEST Clone DB Mount Point : /TEST Creating Directory Structures: First need to create directory structure for the clone db. Easy way to create the directory structure is copy the source filesystem and change the path according to the clone db requirement and delete the content of the source at clone db side. Copy ORACLE_BASE and ORACLE_HOME from source to clone db. Create directory structure for control files, fast_recovery_area. Create directory structure for audit files. Establishing Connection: Edit listener.ora, tnsnames.ora and pfile copied from source db and change according to clone db. Below is the content of my clone db listener, tnsnames file and pfile. Once everything is changed, copy the clone DB’s pfile to source/target[ORCL] DB since we need to start our auxiliary DB[O...