Home » RDBMS Server » Backup & Recovery » Restore backup to another db server (11.2.0)
Restore backup to another db server [message #681176] Mon, 22 June 2020 11:52 Go to next message
Messages: 4
Registered: February 2019
Junior Member

Please would you suggest the best way to do the following..?
We have the live database on one linux server, and another pre production which is the same as the live, but not updated with the last 8 months of data as the live database.

We want to update the preproduction db as in the live environment. I am thinking on restoring the full backup on the live database to the preproduction server.

Please would you help me, i am a junior db admin..

Also, both servers are virtual machines running on the same network. I am afraid of doing something wrong on preproductiob which might affect live server. Do i have to change anything so the restore on the preproduction doesnt affect live.

Thank you!
Re: Restore backup to another db server [message #681177 is a reply to message #681176] Mon, 22 June 2020 13:17 Go to previous message
Michel Cadot
Messages: 68500
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can use the export/import method easier for a beginner.

Otherwise you can read Database Backup and Recovery User's Guide, Chapter 24 Duplicating a Database.

Previous Topic: Using Rubrik to back Oracle DBs
Next Topic: Clone virtual machine with Oracle DB
Goto Forum:

Current Time: Sat Sep 23 02:27:47 CDT 2023