Home » RDBMS Server » Server Utilities » To perform restore of two oracle database from a single backup (11g r2)
To perform restore of two oracle database from a single backup [message #653115] Tue, 28 June 2016 02:59 Go to next message
sibashishnayak
Messages: 9
Registered: May 2014
Junior Member
Hi Guys,

I am new to database and there is a question as is it possible to restore more than one database from the same backup at the same time.if yes,then what all performance related issues will be there or any deadlock conditions.

thanks in advance

SP
Re: To perform restore of two oracle database from a single backup [message #653116 is a reply to message #653115] Tue, 28 June 2016 03:04 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
You cannot restore more than one database from one backup, because you cannot create a backup that contains more than one database. A backup can be of only one target, not several.
Re: To perform restore of two oracle database from a single backup [message #653117 is a reply to message #653116] Tue, 28 June 2016 03:12 Go to previous messageGo to next message
sibashishnayak
Messages: 9
Registered: May 2014
Junior Member
the requirement is to restore two databases(Dev and Test) from the backup of Prod.But the restore should be done at the same time so is it possible.
Re: To perform restore of two oracle database from a single backup [message #653119 is a reply to message #653117] Tue, 28 June 2016 03:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes.

Re: To perform restore of two oracle database from a single backup [message #653124 is a reply to message #653119] Tue, 28 June 2016 04:36 Go to previous messageGo to next message
sibashishnayak
Messages: 9
Registered: May 2014
Junior Member
@Michael.....Kindly elaborate what all thing are to be considered and their challenges
Re: To perform restore of two oracle database from a single backup [message #653127 is a reply to message #653124] Tue, 28 June 2016 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

First, I have to be sure you mean DATABASE when you say database and not SCHEMA.
Are you sure these are DATABASEs?
Re: To perform restore of two oracle database from a single backup [message #653131 is a reply to message #653127] Tue, 28 June 2016 05:27 Go to previous messageGo to next message
sibashishnayak
Messages: 9
Registered: May 2014
Junior Member
yes its the database refresh and not the schema refresh.
Re: To perform restore of two oracle database from a single backup [message #653132 is a reply to message #653131] Tue, 28 June 2016 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So there is no problem but maybe IO rate you can afford.
What size is the dump? Parallel or not?

Re: To perform restore of two oracle database from a single backup [message #653133 is a reply to message #653132] Tue, 28 June 2016 05:56 Go to previous messageGo to next message
sibashishnayak
Messages: 9
Registered: May 2014
Junior Member
Not Parallel....the size is around 1.5 TB
Re: To perform restore of two oracle database from a single backup [message #653136 is a reply to message #653133] Tue, 28 June 2016 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1.5TB not parallel! I hope you have time... Smile
As I said, all is a question of IO.

Re: To perform restore of two oracle database from a single backup [message #653147 is a reply to message #653117] Tue, 28 June 2016 07:46 Go to previous messageGo to next message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
Are you Dev and Test environments on separate servers? If yes, no problem. If no, see Michel's post.
Re: To perform restore of two oracle database from a single backup [message #653154 is a reply to message #653147] Tue, 28 June 2016 08:20 Go to previous messageGo to next message
sibashishnayak
Messages: 9
Registered: May 2014
Junior Member
The dev and test environment is on the same server.
Re: To perform restore of two oracle database from a single backup [message #653155 is a reply to message #653154] Tue, 28 June 2016 08:27 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
sibashishnayak wrote on Tue, 28 June 2016 06:20
The dev and test environment is on the same server.


Above presents a problem since two databases must have different ORACLE_SID; so one of the databases must end up with a different ORACLE_SID than Prod's
Re: To perform restore of two oracle database from a single backup [message #653156 is a reply to message #653155] Tue, 28 June 2016 08:31 Go to previous message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
I don't like the idea of more than one Prod SID in an environment. OP might be better off looking at RMAN DUPLICATE DATABASE.
Previous Topic: impdp error
Next Topic: How to increase SQL Loader performance
Goto Forum:
  


Current Time: Mon Nov 20 11:25:09 CST 2017

Total time taken to generate the page: 0.03395 seconds