| 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: Moving a database to a different machine
I think this will work fine. You could play with doing it with a standby database, the only advantage to that is that you could start the backup and move of files earlier in the process and just keep recovering the archived logs as you ship them across.
This has the advantage of giving you time to plan, test and play with starting the standby db.
So the steps would be:
create the standby database
ship archived logs to standby site, recover logs
when ready to move over:
on production db, force log switch, shutdown, and move the last archived log over
on standby machine, recover the last log. Open the database.
make the necessary changes to various tnsnames.ora and you are in business
Then when you move back to the "real" production machine, you do the same thing.
Rachel
>From: "Steve McClure" <steve_at_pactr.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Moving a database to a different machine
>Date: Thu, 17 May 2001 10:25:34 -0800
>
>Allright,
>We are physically moving our office, and have an OLTP application that
>needs
>to be up and running with minimal downtime. The current plan is to use the
>development computer as the production platform while the Primary computer
>is physically moved to the new location. The development system was the
>production system about 6 months ago, so it will not be under too much
>strain.
>
> I have completely duplicated the filesystems of the Primary machine on
>the
>development box.
>
>This is my plan. Please comment if there is an obviously better way. Oh
>the database is version 7.3.4
>
>1.Put the tablespaces of the production database in backup mode.
>2.Copy datafiles across the network to the "development" machine. Approx 3
>GB
>3.Take the production tablespaces out of backup mode.
>4.Force a log switch.(Habit I guess)
>5.wait until the production system is brought down.
>6.move the control files and redo logs to the development system
>7.move the initSID.ora and configSID.ora files.
>8.edit configSID.ora to change the host associated to Listener.
>9.fire up svrmgrl, and recover the database.
>10.change the tnsnames on the client systems to point to the development
>machine.
>
>Of course. This needs to be tested to some degree first. And we(well
>management at least) don't want to bring the production machine down to
>roll
>the databases forward together just for a test. I can use make a backup
>control file for use during recovery, and move the curently offline redo
>logs. I am not sure what to do about the most current redo log in this
>case. I have played with backup and recovery, but not this scenario. I
>don't currently have my copy of the Velpuri backup and recovery handbook at
>hand(Loaned it to a colleague). So I am bouncing this off of you folks
>while I ponder this until I retrieve my backup and recovery bible.
>
>Any Comments are appreciated.
>
>Thanks,
>Steve McClure
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve McClure
> INET: steve_at_pactr.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: Rachel Carmichael INET: carmichr_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).Received on Thu May 17 2001 - 12:57:44 CDT
 |
 |