Re: Backup/Recovery questions ...

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Wed, 23 Jan 2002 11:03:09 -0800
Message-ID: <F001.003F8FAF.20020123110034@fatcity.com>

Fred,

one of the easier ways is this:

1. on ur prod take a control file backup to trace
2. copy the trace to server b and edit the path/drives
3. copy init file from prod to server b
4. set the env vars in server b and startup nomount
5. create the control file using edited trace on B
6. restore database {rman}
7. recover database {rman}
8. open resetlogs

alternate method:
all steps are similar except 1,2,5
instead u can restore controlfile (rman backup) and then manualkly rename the file before u mount and restore your database.

let me know if this still does not answer your q

Thx
Deepak
--- Fred Smith <fred_fred_1_at_hotmail.com> wrote:
> List,
>
> I am attempting to verify the validity/integrity
> of a full cold backup I
> did off of my production server. I backed up the
> datafiles,logfiles,&
> controlfiles. The production server (server A) is
> much larger with dozens of
> drives. I now wish to apply this backup to another
> server (server B). Server
> B does not have the same drive configurations as
> server A. Based on this
> I'm assuming that my controlfiles from Server A are
> useless.
> How can I bring this database up on server B now?
> There are over 100 datafiles.
>
> OS: SunOS 5.6
> Oracle8 Enterprise Edition Release 8.0.4.4.0 -
> Production
>
> Thank you,
> -Fred S.
>
>

---

> Chat with friends online, try MSN Messenger:
> http://messenger.msn.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Fred Smith
> INET: fred_fred_1_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

---

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

---

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Wed Jan 23 2002 - 13:03:09 CST