| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Backup/Recovery questions ...
Would I be better off doing that or doing a "backup controlfile to trace" from server A, moving the datfiles & logfiles to server B, and then editing the newly created trace file into a script that creates a new controlfile with the new datafile/logfile locations?
>From: Rachel Carmichael <wisernet100_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Backup/Recovery questions ...
>Date: Wed, 23 Jan 2002 11:00:36 -0800
>
>First load all the datafiles and logfiles to server B in the locations
>you want them. Load the controlfiles as well, they aren't useless.
>
>Now.....
>
>edit the init.ora file on server B to point to where the control files
>are.
>
>create a sql script file that contains (for every datafile and logfile)
>
>alter database rename file '<original file name>' to '<new file name>';
>
>the file names should include the full path specification.
>
>now
>go into svrmgrl:
>
>connect internal
>startup mount
><run the script>
>alter database open;
>exit
>
>
>and you have moved the database and files to the new server
>
>--- 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: Rachel Carmichael
> INET: wisernet100_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).
-- 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).Received on Wed Jan 23 2002 - 13:39:03 CST
 |
 |