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.
[EMAIL PROTECTED]
-----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" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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
>
> >>> [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >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
> >
> > >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> >
> >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
