OraFAQ Forum: Backup & Recovery » I will like to backup one database and restore to another

Home » RDBMS Server » Backup & Recovery » I will like to backup one database and restore to another

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I will like to backup one database and restore to another [message #251373]

Fri, 13 July 2007 06:41

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

Report message to a moderator

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

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This case is described in details, step by step in the documentation (http://tahiti.oracle.com).

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Explain what are the steps you executed to NOT find anything useful.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

ebrian
Messages: 2794
Registered: April 2006

Senior Member

It's definitely there...Creating a Duplicate Database with RMAN.

Report message to a moderator

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

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?

Report message to a moderator

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

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

ebrian
Messages: 2794
Registered: April 2006

Senior Member

It sounds like to me, you may be able to consider Resynchronize a Duplicate Database.

Report message to a moderator

Previous Topic:	Import Oracle dmp file into SqlServer
Next Topic:	ora-01152

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 16:02:22 CDT 2024