Database Backup and Recovery (MOSC)

MOSC Banner

Backup a production database and restore to a development/test database

edited Feb 6, 2017 4:00AM in Database Backup and Recovery (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center