Step by Step guide to Clone/Replicate production database to test Database
Platform: Windows server 2016/ X-86-64bit
Database version(s)- 12c- 12.2.0.1.0- Live Production Database ----non-CDB
19c- 19.3.0.0.0 - TEST Database-------CDB with 1 PDB
I want to know the guided step-by-step instructions and commands on to making a clone or replication of my Production database to my Test Database on windows platform. An associate recommended RMAN tool, but I don't know how to get it done.
I do know that I have to run a full backup of production database using RMAN, but I need the instructions/ commands for the entire process.
Production database is a non-CDB and this how I found out;