Home » RDBMS Server » Backup & Recovery » how to restore a database from a different server (RDBMS 12G on linux )
how to restore a database from a different server [message #585888] Thu, 30 May 2013 13:17 Go to next message
evoradba
Messages: 81
Registered: April 2005
Location: Canada
Member
We have a database server running oracle 12G on linux which is the production then we have a DR using the same version of DB and linux, I want to restore from tape into the DR from the production backup. the UNIX admin has restored already from tape the rman backup, i would like to know what are the steps to restore the backup from tape, also the DR database server was created identical like production using the same spfile etc

were do i copy restored file into on the DR server?
also then in RMAN do i just start the DR database and run the command restore database? what else do i need?
thank you
Re: how to restore a database from a different server [message #585891 is a reply to message #585888] Thu, 30 May 2013 13:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No offense intended.
If this is a true DR site, there should be a proven, documented procedure sitting somewhere.

All the required information are available here in documentation.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#i1007814

[Updated on: Thu, 30 May 2013 13:32]

Report message to a moderator

Re: how to restore a database from a different server [message #585892 is a reply to message #585888] Thu, 30 May 2013 13:29 Go to previous messageGo to next message
John Watson
Messages: 4610
Registered: January 2010
Location: Global Village
Senior Member
Hello. I'm going to assume that "12g" is a typo for "11g".
You have to explain what you are trying to achieve. Usually, A "DR" site would mean setting up Data Guard (or standby database, if you do not have Enterprise Edition licences) but it sounds more as though you are trying to do what is called a database duplication. What is the ultimate requirement?
Re: how to restore a database from a different server [message #585894 is a reply to message #585892] Thu, 30 May 2013 13:35 Go to previous messageGo to next message
evoradba
Messages: 81
Registered: April 2005
Location: Canada
Member
it is a true DR site, the dba left and no documentation left, i want to test it and put in place a document as how to restore
Re: how to restore a database from a different server [message #585895 is a reply to message #585894] Thu, 30 May 2013 13:38 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Mahesh Rajendran gave you the link that explains how to do it.

Regards
Michel
Re: how to restore a database from a different server [message #585897 is a reply to message #585892] Thu, 30 May 2013 13:48 Go to previous messageGo to next message
evoradba
Messages: 81
Registered: April 2005
Location: Canada
Member
it is 12G version and it is a stand by server
Re: how to restore a database from a different server [message #585898 is a reply to message #585897] Thu, 30 May 2013 13:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
12g does not and will not exist, so it is NOT a 12g.

Regards
Michel

[Updated on: Thu, 30 May 2013 13:57]

Report message to a moderator

Re: how to restore a database from a different server [message #585900 is a reply to message #585898] Thu, 30 May 2013 14:01 Go to previous message
evoradba
Messages: 81
Registered: April 2005
Location: Canada
Member
sorry it is SQL*Plus: Release 11.2.0.2.0 Production
Previous Topic: RMAN backup successfully?
Next Topic: RMAN-0621-List of Mismatched objects
Goto Forum:
  


Current Time: Tue Sep 30 16:59:50 CDT 2014

Total time taken to generate the page: 0.16388 seconds