Re: Moving a Database

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Fri, 28 May 2004 22:52:34 +0200
Message-Id: <6.0.1.1.0.20040528223052.44166760@pop.xs4all.nl>

Ian,

Data Guard is available for 8.1.7 as well, at least when you're on AIX, HP-UX or Solaris. One of the lurkers of this list might confirm, though it might be the first post ever I see of him. (Hi Casey ;-)) ).

When you want to find the Data Guard software & manuals search google for the keywords: data guard 8.1.7 oracle-l. This will point you to a previous post on this list with the relevant links.

1,5 year ago I used Data Guard to move a database from Singapore to the Hague. 90 GB in about an hour and a half. Little bit cheating, using Data Guard for 8i. This has a nice feature of skipping the copy datafile part when you restored a previously created hot backup before. We had a very small bandwith (128Kb) available for log transport, but that was no problem, it wasn't for availability, but just for moving the DB. The bandwith was enough for transporting the amount of redo per week in 168 hours.

Wat we did was:
- Create a hot backup in Singapore and fly the tapes to the Hague by some Express Postal Service
- In the meantime, set up the parameters for the DG-environment on both ends. (The docs are quite straight-forward)

- Do the restore on the new box.
- Instantiate without datafile-copy.
- Test the whole thing (they used NetApp filers on that site, took a

snapshot of a nicely closed standby, activated it and looked whether it worked. After that we put back the snapshot and restarted the standby and watched it catching up with the primary). - In some weekend we did the move by closing down the primary in Singapore after some logswitches, activated the standby in The Hague and pointed the users to the new location for their application.

Upon D-Day you'll send all users home, perform your last logswitches, wait until the archives have been sent and applied and do a gracefull switchover. (This allows you to revert to the original primary on the old machine). Test, and when everything seems OK disable Data Guard (by removing the relevant parameters from your init.ora and bouncing the instance) and live happily with your new machine with a copy of the old database. Choose to change your IP, or just change tnsnames/oranames/whateveryouhave.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

At 09:38 PM 5/28/2004, you wrote:

>I must be overlooking something. It seems easier to move a database the
>old way rather than through rman. One more tidbit, although the script
>above is for a 9.2.0 database. The one I need to move is a 8.1.7 database.
>
>
>
>Ian MacGregor
>Stanford Linear Accelerator Center
>ian_at_slac.stanford.edu
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 28 2004 - 15:49:55 CDT