I am a java person and not so much familiar with Oracle available features. Please help me. The requirement is that, we are looking for some virtual(replica/mirror/view) database to be created from Production database just for testing purpose. Once we are done with executing all the automation test cases, delete the virtual database created. So are there any such concepts in Oracle ?
We are on Oracle 12c. Many apps use same DB(its huge)
PS: We also use docker for deployment and also AWS.
use Rman duplicate to duplicate the test database from production. https://oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2 you can duplicate from backups or duplicate from active database