Hi You may recreate controlfile, quick and easy. Stefano -- http://www.stefanocislaghi.eu ------Original Message------ From: Joel.Patterson@xxxxxxxxxxx Sender: oracle-l-bounce@xxxxxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx ReplyTo: Joel.Patterson@xxxxxxxxxxx Subject: Restore old backup to new database name Sent: Mar 9, 2010 20:34 I duplicate databases regularly from production to test. I have a request to restore test with production data from 2/26. The sys admin has restored the 2/26 backup to test server in normal backup directory location. What extra is needed can I do to either restore to new database name, or duplicate if possible. Is that example in Robert Freeman's 10g book? If so page# would be nice. Joel Patterson Database Administrator 904 727-2546 -- //www.freelists.org/webpage/oracle-l Sent by BlackBerry®