Re: REDUCE DOWN TIME

From: Paul Vallee <dbalist_at_pythian.com>
Date: Fri, 01 Mar 2002 14:25:00 -0800
Message-ID: <F001.0041D53E.20020301142500@fatcity.com>

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" <ORACLE-L_at_fatcity.com> 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: oracledbam_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).
--

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

Author: Kevin Lange
  INET: kgel_at_ppoone.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: Paul Vallee
  INET: dbalist_at_pythian.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 Fri Mar 01 2002 - 16:25:00 CST