Export error in 7.3.2.1.0

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/01/12
Message-ID: <69dnu9$mek$1@pebble.ml.org>#1/1

I always wonder about those lucky souls who never have a problem with exp.

This weekend I got this:

. . exporting table                       DOCUMENT

EXP-00014: error on row 6071497 of table DOCUMENT

EXP-00222:
System error message 28

EXP-00008: ORACLE error 1089 encountered
ORA-01089: immediate shutdown in progress - no operations are permitted
EXP-00008: ORACLE error 1089 encountered
ORA-01089: immediate shutdown in progress - no operations are permitted
EXP-00000: Export terminated unsuccessfully

This just shut down the instance.

Some perhaps salient facts:

This is part of a cron job that uses svrmgrl to connect internal shutdown immediate startup restrict open, then exp pipes the compressed output to a raid array mounted from another computer.

GRANTS=Y FULL=Y INDEXES=Y COMPRESS=Y FILE=/dev/PIPE.dmp LOG=exp.log &

The job ran fine last week - the compressed file well under a gig.

The document table has about 7.7 million rows, with no more than a few thousand (more like hundreds, I haven't ascertained exactly yet) added since last week. The records are adding in ascending order, making it unlikely the record that blew up was a new one. There are a number of indices, however. A few weeks ago, I populated the tablespace from another tablespace using the sizing that exp thinks it should be, so should be no problem with fragmentation.

Some minor hardware reconfiguration was done Thursday, necessitating a hardware reboot. Nothing else has shown up wrong.

Nothing out of the ordinary in the alert log.

No problem restarting the instance, so far as I know (someone else did it).

sparcserver 1000, SunOS 5.5.

Any suggestions? I'll be going to hot backups soon, but this has me spooked. This is supposed to be 7x24, so I don't have lots of opportunities to exp. I also need to shrink the system tablespace, as I've been moving a lot of stuff out of it that should never have been put there.

Is that row that exp complained about the same as rownum?

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!

Received on Mon Jan 12 1998 - 00:00:00 CST