Oracle-L: RE: Re[2]: Again RMAN - how to restore DB on another server?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 21 Apr 2003 05:41:44 -0800
Message-ID: <F001.00585AF6.20030421054144@fatcity.com>

Alex - No, you don't need to know the location of each file. But the directory must exist. Otherwise RMAN will attempt to restore a file to that location, and fail. Not a big deal, you can then create that directory (or link is fine), and restart RMAN. Most databases place files at just a few locations, so shouldn't be a big deal.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, April 21, 2003 2:57 AM
To: Multiple recipients of list ORACLE-L

Hi Folks,

Many thanks for your help. I just want to add a few more things: 1. I am staying with RH Linux Adv Server 2.0. 2. rman doesn't have the recovery catalog.

Q: Do I need to know exact location of all files of crushed database before I start recovery?

Alex.

Sunday, April 20, 2003, 1:36:39 AM, you wrote:

DW> Alex
DW> Just a warning. If your original server is gone, you may have problems.
DW> What you are describing is essentially a disaster recovery process. I've had

DW> to run through that several times, each time finding a file or something
DW> missing. 
DW>    Did you perform your RMAN backup using the control file or a catalog?
DW>    You don't say what type of system you are using, Unix or NT. My
DW> experience relates only to Unix.
DW>    First, can you place the RMAN backup pieces in the same location as

they

DW> were on the original machine. Or create a link to that path? 
DW>    Second, do the file locations for all the database files exist? 
DW>    If those conditions are met, then you basically need to create a

database
DW> with the same SID as the other database had, then start RMAN and recover the
DW> database. You will probably discover some minor issues, but probably not DW> anything you can't overcome.

DW> Dennis Williams
DW> DBA, 40%OCP, 100% DBA
DW> Lifetouch, Inc.
DW> dwilliams_at_lifetouch.com 


DW> -----Original Message-----

DW> Sent: Saturday, April 19, 2003 8:57 AM DW> To: Multiple recipients of list ORACLE-L

DW> Hello List,

DW> I have a question about database recovery with RMAN, Oracle 9i R2.

DW> I have a full database backup done with rman command "backup database"
DW> It includes original control file and spfile and all datafiles.
DW> Primary server has gone.

DW> How to run recovery process using this backupset on another machine with the

DW> same Oracle version and OS? I suppose I don't need to create any
DW> database on new place. I have to start some idle instance and use rman
DW> to restore and recovery files. Am I right? What are the necessary
DW> steps I have to do?

DW> Thank you for your help in advance.
DW> -- 
DW> Best regards,
DW>  Alex                          mailto:alex_a_at_pisem.net

DW> -- 
DW> Please see the official ORACLE-L FAQ: http://www.orafaq.net
DW> --

DW> Author: Alex Andriyashchenko
DW> INET: alex_a_at_pisem.net

DW> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
DW> San Diego, California        -- Mailing list and web hosting services
DW> ---------------------------------------------------------------------
DW> To REMOVE yourself from this mailing list, send an E-Mail message
DW> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
DW> the message BODY, include a line containing: UNSUB ORACLE-L
DW> (or the name of mailing list you want to be removed from).  You may
DW> also send the HELP command for other information (like subscribing).
DW> -- 
DW> Please see the official ORACLE-L FAQ: http://www.orafaq.net

--

Best regards,

 Alex                            mailto:alex_a_at_pisem.net

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Alex Andriyashchenko
INET: alex_a_at_pisem.net

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
---------------------------------------------------------------------