RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name

1.Copy the init parameter file from source . 2.In target place this init file to $ORACLE_HOME/dbs 3.Change following parameter in init file to make it compatible to single instance. Replace original instance name to target name in pfile .For my case it should EBILTST as target. ##Remove following parameters## EBILDR12.__data_transfer_cache_size=0 EBILDR11.__data_transfer_cache_size=0 EBILDR11.__db_cache_size=5939134464 EBILDR12.__db_cache_size=3154116608 EBILDR12.__java_pool_size=234881024 EBILDR11.__java_pool_size=234881024 EBILDR12.__large_pool_size=5335154688 EBILDR11.__large_pool_size=5268045824 EBILDR11.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from […]

Database proactive patching step (PSU) 26635880 for 12.1.0.2 October 2017

PSU patching for 12.1.0.2:-   First Identify the patch to be downloaded:- Oracle 12.1.0.2 proactive DB patching . Patch number:-26635880.We needed to apply in RHEL 7 64-bit. Please download this patch from Oracle support. We need to follow below link for details of steps:- https://updates.oracle.com/Orion/Services/download?type=readme&aru=21529863   We need to download following OPATCH utility as well as this patch requires version12.2.0.1.7 . […]