Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fwd: RE: EXP-00008: ORACLE error 1555 encountered

Re: Fwd: RE: EXP-00008: ORACLE error 1555 encountered

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Fri, 16 Mar 2001 18:34:38 -0800
Message-ID: <F001.002CFB39.20010316180620@fatcity.com>

option 3 -- increase the rollback segments and redo with users in the database

jumping in... yes of course an export will use a rollback segment.. to all intents and purposes, exporting a table is the same as doing a select * from <tablename> that is written to a spool file.

so it doesn't matter if you are using consistent=y or not (sorry Scott, all that does is make sure that EVERY table that has referential integrity is consistent within the constraints). if you are doing an export, and someone is updating the table, the export will read from the rollback segment

Paul is right, the best way is to export with no users in the system. If you can't do that (24x7) then change rollback segment number and sizes and pray each time you run the export. Because you will always be at risk for the snapshot too old.

Rachel

>From: Paul Drake <drake_at_psscorp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Fwd: RE: EXP-00008: ORACLE error 1555 encountered
>Date: Fri, 16 Mar 2001 14:56:49 -0800
>
>2 options:
>
>1. Option #1 - produce a real dump file - export a quiescent database
>shutdown immediate
>startup restrict
>call export job with user that has restricted session
><export job completes>
>alter system disable restricted session;
>
>2. Option #2 - create a garbage export.
>call export job without consistent=Y
>update resume.
>
>hth,
>
>Paul
>
>-------- Original Message --------
>Date: Fri, 16 Mar 2001 12:01:02 -0800
>Reply-To: ORACLE-L_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>
>Are you doing a consistent=y export? Was there significant activity on
>the
>system?
>
>Scott Shafer
>San Antonio, TX
>
>"In /dev/null no one can hear you scream..."
>
>
> > -----Original Message-----
> > From: Charlie Mengler [SMTP:charliem_at_mwh.com]
> > Sent: Friday, March 16, 2001 8:42 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: EXP-00008: ORACLE error 1555 encountered
> >
> > FWIW this is a V7.3.4.5 DB on V2.6 Solaris.
> > For months & months I've had this nightly export script run via cron.
> > Last night it generated the error below.
> > I was unaware that export used RBS.
> > Other than making the RBS larger, how can I avoid this in the future.
> >
> > TIA!
> >
> > Connected to: Oracle7 Server Release 7.3.4.5.0 - Production
> > With the distributed and parallel query options
> > PL/SQL Release 2.3.4.5.0 - Production
> > Export done in US7ASCII character set
> > Note: indexes on tables will not be exported
> >
> > About to export specified tables via Direct Path ...
> > Current user changed to MWH
> > . . exporting table DBW_DAILY_SALES
> >
> > ORA-01555: snapshot too old: rollback segment number 1 with name "R05"
>too
> > small
> > Export terminated successfully with warnings.
> > --
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Drake
> INET: drake_at_psscorp.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).



Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
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 Fri Mar 16 2001 - 20:34:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US