Oracle-L: RE: Snapshot Too Old Error on Export !!!

From: Nelson, Allan <anelson_at_midf.com>
Date: Fri, 21 Feb 2003 07:09:27 -0800
Message-ID: <F001.005544A6.20030221070927@fatcity.com>

You might try running hot backups at the OS level instead. It sounds like your export is just taking too long. To get it to work with active users on board you might have to increase your rollback segments to truly ridiculous levels especially if you have large batches running while the export is running. To really understand the issue go to http://www.ixora.com.au and look at Steve Adams' material on snapshot too old.

Allan

-----Original Message-----
Sent: Friday, February 21, 2003 4:00 AM
To: Multiple recipients of list ORACLE-L

Hi all

I have a problem when doing an export in one of ourt production databases. The export fails with ORA-01555, snapshot too old error.

I have increased the number of rollback segments and their sizes on the database. Also I have went to an extent of specifying the parameter constent=n on my script but backups fails. The worst part is this export runs for a long time and then fails, more than 24 hours.

The only time that this export succeed is over the weekend, because most of the time few people are working or not at all. Now I have tried to start it after hours but as I said it still takes long and end up failing the next day.

Could somebody help me here, this is very critical to be running production without proper backups .....!

Thanx

http://www.webmail.co.za the South-African free email service

NetWiseGurus.Com Portal - Your Own Internet Business Today!

--

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

Author: Jackson Dumas
INET: tjaros_at_webmail.co.za

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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).

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

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

Author: Nelson, Allan
INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------