Re: RMAN restore to different machine

Wait till 10g.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 24, 2003 11:29 PM

> 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.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Monday, November 24, 2003 3:20 PM
> To: 'ORACLE-L_at_fatcity.com'
>
>
> 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
>
> >>> DWILLIAMS_at_lifetouch.com 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.
> dwilliams_at_lifetouch.com
>
> -----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: RASTEIN_at_NYCT.com
>
> 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: StephenAndert_at_firsthealth.com
>
> 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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: ListGuru_at_fatcity.com (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).