OraFAQ Forum: Backup & Recovery » Restore database in another Server by Rman

Home » RDBMS Server » Backup & Recovery » Restore database in another Server by Rman

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

Restore database in another Server by Rman [message #125725]

Tue, 28 June 2005 21:42

jy77
Messages: 5
Registered: June 2005

Junior Member

hi:
I make a full database backup(including current control files) using Rman,Can i restore it in another Server(same OS)?

thks!

Report message to a moderator

Re: Restore database in another Server by Rman [message #125731 is a reply to message #125725]

Wed, 29 June 2005 00:06

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Yes.

For details pls refer to RMAN documentation.

Report message to a moderator

Re: Restore database in another Server by Rman [message #125786 is a reply to message #125731]

Wed, 29 June 2005 04:35

jy77
Messages: 5
Registered: June 2005

Junior Member

I want to restore the backup file to another Server that have different oracle install directory.

Report message to a moderator

Re: Restore database in another Server by Rman [message #125789 is a reply to message #125786]

Wed, 29 June 2005 04:40

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

For restoration of database, having a different Oracle Install Directory is immaterial. You can restore it at any location u wish.
At the max, u may need to rename some filenames.

Regds
Girish

Report message to a moderator

Re: Restore database in another Server by Rman [message #129426 is a reply to message #125789]

Mon, 25 July 2005 04:09

leei
Messages: 2
Registered: July 2005
Location: Singapore

Junior Member

Hi Girish,

I just join in the question.
How about if I want to create a new tablespace
I don't want it to be the same tablespace as when it was exported out.

Thanks in advance

Report message to a moderator

Re: Restore database in another Server by Rman [message #129588 is a reply to message #125789]

Mon, 25 July 2005 20:09

jy77
Messages: 5
Registered: June 2005

Junior Member

hi,Girish

Could you tell me the detail about restoring to another Server(same OS,different orale home directory)?

thks

[Updated on: Mon, 25 July 2005 20:10]

Report message to a moderator

Re: Restore database in another Server by Rman [message #129590 is a reply to message #129588]

Mon, 25 July 2005 20:41

leei
Messages: 2
Registered: July 2005
Location: Singapore

Junior Member

Yup,

Basically I have a DB in "SYSTEM" tablespace and under username: SYSTEM.

What I want to do is:
To transfer the DB to a new tablespace, example name: "DATA" and under a new username: ADMIN. (between different Instance)

What I have done is:
I create a new Instance, then export the DB from old Instance and import into the new Instance.

Is it correct to do so?
What command should I write for import or export to just specify the particular tablespace to transfer?

Thanks in advance,
Cheers

Report message to a moderator

Previous Topic:	Bad results from V$LOGMNR_LOGS!!
Next Topic:	Exporting data from a Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 17:27:12 CDT 2024