Backup a production database and restore to a development/test database
in need of creating a full backup of our production database daily and restoring to a TEST database.
12c on a server 2012 r2 environment
in our current 11g environment someone created a batch file to; (at least that what it looks like to me)
1 stop database "PROD"
2 "cold back up" data base
3 start database "PROD"
4 on 2nd server ; copy previous days backup file to a different folder, delete backup from current folder
5 copy backup PROD to a folder on 2nd server
6 stop database "TEST"
7 restore backed up database PROD to "TEST" instance
8 start "TEST"
TEST is now available to test users who export data with custom "Access" database programs to create reports without touching the production "PROD" database