How about:
Copy your database to the new server. This needs to be
done in real time. I've done this a number of times by
putting the database in hot backup mode, copying the
datafiles to the new server.
Then when you're ready to switch, shutdown the old
database, copy all archive logs generated during the
backup to the new server.
Also, copy all unarchived redo logs to the new server
as well. Open the new database, apply media recovery
using all the archive logs you copied, as well as the
unarchived redo logs.
Applying the redo logs from the old database allows
you to open the database without 'RESETLOGS'.
This may be possible with RMAN, but I suspect the
hot backup method is simpler.
Jared
"Robin Li" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/14/2002 12:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Replication
Thanks to all who replied.
The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over,
he is going to use the DB on the old server as reporting.
Robin
[EMAIL PROTECTED] wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose? High Availability? Querying and
reporting?
>
> Jared
>
> "Robin Li" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 10/14/2002 06:58 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject: Replication
>
> Hi all,
>
> Does anyone have the appropriate time on implementing replication for a
> newbe?
>
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
>
> TIA
>
> Robin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robin Li
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
--
Robin
****************************************************************
* Robin Li *
* Technical Specialist, DBA Phone#: (212) 297-3073 *
* Information Services Fax#: (212) 297-4231 *
* 333 East 38th Street, 2nd fl. E-mail: [EMAIL PROTECTED] *
* New York, NY 10016 *
****************************************************************
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robin Li
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
