| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Moving a database to a different machine
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). Received on Thu May 17 2001 - 12:25:57 CDT
 |
 |