This method doesn't do the defragmentation Seema is hoping for, though. Seema, you're aware that fragmentation is no longer as big an issue as it was in the olden days, right? :-) Kevin's approach here is definitely the downtime minimization king. Paul ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 4:59 PM
2 items here: (This assumes that the Database Instance is only used for this single purpose). First, don't bother with an export. FTP the files over when the DB is down. This way you do not have to take the time of an unnecessary Export/Import. When the files are on the new server you can immediately bring it up. Point the users to this server now. But, there is a beter way to do this. STANDBY Databases. 1. Put DB on SV1 into Archive Mode. 2. Shut down DB on SV1. 3. Copy the files to an alternate local directory. 4. Bring up DB on SV1. 5. FTP the files from the alternate location to their correct location on SV2. 6. Bring up DB on SV2 into Standby Mode. 7. At different times during the day bring the Archive files from SV1 to SV2. 8. Apply these logs to DB on SV2. This can go on until you need to make the DB on SV2 active. 1. Shutdown DB on SV1. 2. Bring Archive files that are left on SV2 over to SV2. 3. Apply these logs on SV2. 4. Bring the DB on SV2 up as a normal Database. Your only down time is the initial copy of files and then a small time of copying over the last of the archive logs when you have to switch. You can even add a step at the end of the process to bring down the DB on SV2 and copy the files out before you open it up to the users. This way you can copy the files over to SV1 and get it ready as a standby to SV2. For information on this take a look in the manuals under Standby Databases. -----Original Message----- Sent: Friday, March 01, 2002 2:48 PM To: Multiple recipients of list ORACLE-L Hi I want to switch from one server to another serevr with minimun down time of site.I am using export/import because removal of fragmentation. The folowing is my idea -export consistent=y on server1 -Ftp export files into serevr2 -Drop fragmenetd tablespace and recreate it -run import at schema level on server2(IMPORT is taking too much time) -Point the site to server2 But I am worry about those data which will loss during ftp time and import time.How to sync both server at particular time keeping in view with less down time of site. Can Incremental export/import help us to minimize the site down? Let me suggest please. -sEEMA _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [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: Kevin Lange INET: [EMAIL PROTECTED] 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: [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: Paul Vallee INET: [EMAIL PROTECTED] 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: [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).
