Home » RDBMS Server » Backup & Recovery » Restoration of RMAN to Create New database (Windows Server 2003)
Restoration of RMAN to Create New database [message #542416] Tue, 07 February 2012 03:42 Go to next message
dba.waheed
Messages: 2
Registered: February 2012
Location: Pakistan
Junior Member
On production environment i am running Oracle 10g (10.2.0.4) on windows server 2003. and take full compress backup through rman .
What i want to know or learn is following

I have create a new machine from scratch OS (windows 2003 server)
Database Oracle 10g R2 (10.2.0.4) same architecture as live,
Can i standup a instance with the backup i have taken from my live database. And if yes .......how can i ......means i want to take backup from live and restore it on new created machine

I am new in rman so please describe in detail i ll be very thankfull.

Regards
Waheed
Re: Restoration of RMAN to Create New database [message #542417 is a reply to message #542416] Tue, 07 February 2012 03:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can just restore in new machine
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmrecov.htm#i1007814

or use duplicate options
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#i1008564
Re: Restoration of RMAN to Create New database [message #542421 is a reply to message #542417] Tue, 07 February 2012 03:55 Go to previous messageGo to next message
dba.waheed
Messages: 2
Registered: February 2012
Location: Pakistan
Junior Member
Your reply is highly appreciated.
It would be good if i get an example on windows os.
Re: Restoration of RMAN to Create New database [message #542431 is a reply to message #542421] Tue, 07 February 2012 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no difference if OS is Unix, Windows or anything else.

Regards
Michel
Re: Restoration of RMAN to Create New database [message #578349 is a reply to message #542431] Wed, 27 February 2013 03:54 Go to previous messageGo to next message
sureshmnv659
Messages: 1
Registered: February 2013
Location: hyderabad
Junior Member
i have database in windows xp datafiles,controlfile and spfile is threr.
how can i restore the database in new home using these files.

Thanks in advance
suresh
Re: Restoration of RMAN to Create New database [message #578396 is a reply to message #578349] Wed, 27 February 2013 08:54 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Mount the database and execute "alter database rename file" for each file.

Regards
Michel
Previous Topic: recover data from .dbf files
Next Topic: catalog
Goto Forum:
  


Current Time: Thu Mar 28 18:27:11 CDT 2024