0 pts.
 10G Database Restore to New Server from Backup
I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot of difficulty understanding the process of recovering from a backup to a new server only using the backup files. This is a fairly simplistic task in SQL Server but the process in Oracle is in many shades gray. Please provide me a process of restoring just a backup to a new windows server. The database is in archive mode. Please e-mail me your response at sqldatapro@yahoo.com ASAP, Thanks Boatloads! Sincerely, Craig

Software/Hardware used:
ASKED: August 7, 2006  4:35 PM
UPDATED: August 8, 2006  1:37 PM

Answer Wiki:
Hi you may want to use the DUPLICATE instruction of RMAN: http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc2004.htm#sthref427 and then http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BGBHBIFE Good luck Younes El karama Oracle DBA
Last Wiki Answer Submitted:  August 8, 2006  1:37 pm  by  Elkarama   0 pts.
All Answer Wiki Contributors:  Elkarama   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _