Comprehensive data protection for all workloads
Post Reply
pls
Enthusiast
Posts: 34
Liked: 8 times
Joined: May 17, 2019 5:44 pm
Full Name: Phil Shields
Contact:

Oracle: create test db on different server

Post by pls »

We have our production Oracle database on a Linux physical server. DB is named Prod. We have a test database on a second physical server that is a copy of the prod db, it is named Test. Prior to Veeam to backup the db we would shut it down and backup the data files every night. To refresh the test db we would just restore the data files to the test server and run a script to create control files and redo log files. We refresh our test db about once a month. The refresh also gives us a way to test if our backups are good. We now want to use Veeam with application aware enabled to backup our prod database. How can I restore from backup to a different server and at the same time change the name of the database from Prod to Test.
Thanks
jmmarton
Veeam Software
Posts: 2097
Liked: 310 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: Oracle: create test db on different server

Post by jmmarton »

During the restore process there's an option to restore to a different location and to specify a different global database name.

https://helpcenter.veeam.com/docs/backu ... l?ver=95u4

Joe
Post Reply

Who is online

Users browsing this forum: massimiliano.rizzi and 160 guests