and most importantly of all, if you don't want to have to repeat (and
repeat) this exercise...
BACKUP THE NEW DATABASE
- "Mercadante, Thomas F" <Thomas.Mercadante_at_Labor.State.Ny.Us> wrote:
> 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).
>
>
> _________________________________________________________________
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.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).
> --
> 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).
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).
Received on Wed Jan 23 2002 - 18:59:14 CST
