| 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: FAST MIGRATION OF DATA
Singh - You may also want to take a look at cloning your database. This essentially the first step to creating a standby database, but doesn't necessarily mean going as far as loading the redo logs. Whether this will suffice for your purposes will depend on how long you will have to switch over. If you must have the system unavailable for just a few minutes, then the standby database may be your only alternative, and I believe that you are receiving good advice.
However, if you have a window of a few hours, then cloning may be
good enough. As far as the different OS mount points, the cloning techniques
handle that. I'm guessing that if you are within Oracle certification, patch
levels of the OS won't matter. To get more information on cloning a
database, go to http://www.orafaq.com and search on "cloning".
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, October 29, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L
Richard
The OS patchs are diffrent and OS mount points are diffrent.I have one
questions as per stand by Database creation the following things are
required
-copy of datafiles,standby controlfile,parameter files and archived logs
from primary.
Then it is necessary to have either cold or hotbackup of datafiles.Ultimate
my focus is to save time migration.Let me suggest please.
Thanks
-Seema
>From: "Richard Ji" <rji_at_exenet.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: FAST MIGRATION OF DATA
>Date: Mon, 29 Oct 2001 13:12:25 -0800
>
>Yes you can create the same "prod" on your new box. Now when you say
>configuration are different, please be more specific. Do you mean the
>mount
>points will be different, the OS will be different?
>
>Richard
>
> >>> oracledbam_at_hotmail.com 10/29/01 03:57PM >>>
>Richard
>Let the production instance name is "prod".Can I create standby database
>with same name like "prod" on another box.
>If the configuration of both servers are diffrent then what will be best
>approach of data migration.
>Thanks
>-Seema
>
>
> >From: "Richard Ji" <rji_at_exenet.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: FAST MIGRATION OF DATA
> >Date: Mon, 29 Oct 2001 11:15:32 -0800
> >
> >Assuming the same Oralce and OS version on both Unix boxes. You can
>create
> >a standby on the new box. Then activate it. The down time will be the
> >time
> >you need to move the online redo over and apply it.
> >
> >Richard
> >
> > >>> oracledbam_at_hotmail.com 10/29/01 11:15AM >>>
> >Hi
> >I have one production database of 60gb .i want to migrate from existing
> >unix
> >box to new unix box with minimun downtime.Please suggest what will be
>good
> >method for migration.I have oracle 8.1.7 on solaris 2.7.
> >Thanks
> >-Seema
> >
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Seema Singh
> > INET: oracledbam_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: Richard Ji
> > INET: rji_at_exenet.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).
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
> INET: oracledbam_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: Richard Ji
> INET: rji_at_exenet.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: Seema Singh INET: oracledbam_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: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.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 Mon Oct 29 2001 - 16:30:42 CST
 |
 |