Re: Replication

The directory structure was the problem I had in mind actually.

Moving to a different disk layout is easy with hot backup.

Jared

Rajesh.Rao_at_jpmchase.com
Sent by: root_at_fatcity.com
 10/15/2002 10:24 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: Replication

This is definitely possible with RMAN. The only hitch is that in case you use RMAN to write to disk, the same directory structure must exist on the target server. The workaround would be to create soft links. Also, in case,
you are moving the datafiles to a different destination, then one needs to use the 'set newname' in RMAN. If you are looking for the fastest way to replicate a db, and $$ aint a problem, I would recommend BCV splits.

If you only plan to use it as a reporting database only, and periodic refreshes, why not use standby databases, instead of replication.

Raj   

                    Jared.Still_at_r  
                    adisys.com           To:     Multiple recipients of 
list ORACLE-L <ORACLE-L_at_fatcity.com> 
                    Sent by:             cc:   
                    root_at_fatcity.        Subject:     Re: Replication      
 
                    com  
  
  
                    October 14,  
                    2002 04:44 PM  
                    Please  
                    respond to  
                    ORACLE-L  
  
  

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" <rli_at_nyp.org>
Sent by: root_at_fatcity.com
 10/14/2002 12:53 PM
 Please respond to ORACLE-L

        To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

        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

Jared.Still_at_radisys.com wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose? High Availability? Querying and
reporting?
>
> Jared
>
> "Robin Li" <rli_at_nyp.org>
> Sent by: root_at_fatcity.com
> 10/14/2002 06:58 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> 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: 
  INET: Rajesh.Rao_at_jpmchase.com

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: 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: 
  INET: Jared.Still_at_radisys.com

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: 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).