Home » RDBMS Server » Backup & Recovery » I will like to backup one database and restore to another
I will like to backup one database and restore to another [message #251373] Fri, 13 July 2007 06:41 Go to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
I would like to backup one database and restore to another. Is this in any way possible? If so, how can I perform this? Both databases reside on seperate servers but share NFS. Also is there a way of speeding up the process? Will this be a hot or cold backup? I know in restoring I will probably have to change the database id? What the factors and steps involved? Can someone provide me with a sample script? Thank you so much for your time... Embarassed
Re: I will like to backup one database and restore to another [message #251381 is a reply to message #251373] Fri, 13 July 2007 06:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This case is described in details, step by step in the documentation (http://tahiti.oracle.com).

Regards
Michel
Re: I will like to backup one database and restore to another [message #251392 is a reply to message #251373] Fri, 13 July 2007 07:27 Go to previous messageGo to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Michel -
Thanks so much for your response but I couldn't seem to find anything in the link provided. Is there any other help you can render Embarassed
Re: I will like to backup one database and restore to another [message #251397 is a reply to message #251392] Fri, 13 July 2007 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Explain what are the steps you executed to NOT find anything useful.

Regards
Michel
Re: I will like to backup one database and restore to another [message #251427 is a reply to message #251397] Fri, 13 July 2007 09:44 Go to previous messageGo to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
I went to the link, clicked on my database version typed in all possible search queries possible on the topic and I didn't get anything. So sorry for the hassle
Re: I will like to backup one database and restore to another [message #251429 is a reply to message #251427] Fri, 13 July 2007 09:50 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It's definitely there...Creating a Duplicate Database with RMAN.
Re: I will like to backup one database and restore to another [message #251432 is a reply to message #251429] Fri, 13 July 2007 10:06 Go to previous messageGo to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Thanks for your response Brian! I have read about creating a duplicate database but the database to be restored already exists. The duplicate command, from what I understand, has never been utilized by previous DBAs and I don't want to mess up anything? Is there any other information you can provide for example, should I take a cold backup? How can I perform a restore on the other database?
Re: I will like to backup one database and restore to another [message #251442 is a reply to message #251432] Fri, 13 July 2007 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't.
You have to export the original database and import in the target one.
Or maybe you can use transportable tablespaces.

Regards
Michel

Re: I will like to backup one database and restore to another [message #251445 is a reply to message #251442] Fri, 13 July 2007 11:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Well really I think more information is needed on the OP's environment. You have the potential to actually refresh the development database with RMAN, however without more insight into your setup it's hard to say for certain.
Re: I will like to backup one database and restore to another [message #251448 is a reply to message #251373] Fri, 13 July 2007 11:23 Go to previous messageGo to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
Both databases are 9i. This is downtime allowed on Saturdays. Incremental backups are taken Sunday through Friday and a level 0 backup taken on Saturday. The last data refresh was taken two months ago.
Re: I will like to backup one database and restore to another [message #251450 is a reply to message #251448] Fri, 13 July 2007 11:26 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It sounds like to me, you may be able to consider Resynchronize a Duplicate Database.
Previous Topic: Import Oracle dmp file into SqlServer
Next Topic: ora-01152
Goto Forum:
  


Current Time: Sat Dec 07 03:34:14 CST 2024