| 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 ...
Fred,
Either method works fine. You have the same amount of data editing in both methods (Either issue "alter database rename" commands, or edit the "create controlfile" file.
The other consideration is that in Rachel's method, you are simply opening the database afterword.
With the re-creation of the control file, you must (I think) "alter database open resetlogs".
A minor difference.
Whichever way you decide to do it would be fine. The end result is a ton of typing.
Something to consider is, on your production box, create disk directories based on a Unix soft link, and place your database files into these directories. This would facilitate your moving of the database in the future, as your "soft links" are at the operating system level, and can be changed more easily than issuing the "alter database" commands.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, January 23, 2002 2:40 PM
To: Multiple recipients of list ORACLE-L
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: Thomas.Mercadante_at_Labor.State.Ny.Us 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 - 14:45:01 CST
 |
 |