My apologies, I bumped the "send" button. Stephen - my understanding is that you are correct, the platforms have to be the same at the binary level - i.e.., both Solaris, both Windows, etc.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, November 24, 2003 3:20 PM To: '[EMAIL PROTECTED]' Good catch Stephen. My understanding is that you -----Original Message----- Sent: Monday, November 24, 2003 3:05 PM To: Multiple recipients of list ORACLE-L More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen >>> [EMAIL PROTECTED] 11/24/03 11:54AM >>> Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup & Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
