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

Report message to a moderator

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: 8966
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.

Report message to a moderator

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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Yes.

Report message to a moderator

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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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?

Report message to a moderator

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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

Report message to a moderator

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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

Report message to a moderator

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: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
Are you Dev and Test environments on separate servers? If yes, no problem. If no, see Michel's post.

Report message to a moderator

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.

Report message to a moderator

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: 26766
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

Report message to a moderator

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: 1119
Registered: November 2010
Location: Bedwas, 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.

Report message to a moderator

Previous Topic: impdp error
Next Topic: How to increase SQL Loader performance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 03 17:11:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.