Home » RDBMS Server » Server Utilities » DB Export problem
DB Export problem [message #262805] Tue, 28 August 2007 05:28 Go to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
We are working with Oracle 9i on TRU 64 Unix OS for last some years. Now suddenly while taking daily export using the following code:

exp userid/password@sid file=file_name.dmp log=log_name.log
full=y consistent=y statistics=none

the export failed ----

. . exporting table PRTRNPDALC_200601 135105 rows exported
. . exporting table PRTRNPDALC_200602 140697 rows exported
. . exporting table PRTRNPDALC_200603 150778 rows exported
. . exporting table PRTRNPDALC_200604 201297 rows exported
. . exporting table PRTRNPDALC_200605File size exceeded -
core dumped
$

----------------------------------------------------------------
Now one core file is generated and whenever the dump size is 1082201088 export is automatically terminated. We have checked that there is enough free space to complete that export. Also we have checked that the parameter
'max_dump_file_size' = Unlimited is set.

Please suggest what to do, because we have to take cold backup or userwise backup or tablewise which is not the criteria.

Thanks & Regards,
Sam G
Re: DB Export problem [message #262807 is a reply to message #262805] Tue, 28 August 2007 05:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
ORA-07209: sfofi: file size limit was exceeded.
Cause: The size of the file to be opened exceeded the OS limit imposed on this process.
Action: Run osh to increase the file size limit.
Re: DB Export problem [message #262823 is a reply to message #262805] Tue, 28 August 2007 05:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Try ulimit -a
Re: DB Export problem [message #263405 is a reply to message #262823] Wed, 29 August 2007 23:52 Go to previous messageGo to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
We ran ulimit and the result is ----------------------------

ulimit -a.

$ ulimit -a
4194304
$ ulimit
unlimited

Now please advise me how to run 'osh' to increase file size limit. And export problem is till alive. When the dump size is exceeding 1GB export is terminated ----------------------------

Dump Output :

. . exporting table OP_LOAD_KM 2167515 rows exported
. . exporting table OP_LOAD_KM_0407 116493 rows exported
. . exporting table OP_LOAD_KM_0507 138823 rows exported
. . exporting table OP_LOAD_KM_0607File size exceeded -
core dumped
$

One core file is generated in the export destination directory --------------------------------
$ ls -l
total 4870120
-rw------- 1 oracle dba 133734400 Aug 29 15:59 core
-rw-r--r-- 1 oracle dba 1082201088 Aug 29 15:59 mis.dmp
-rw-r--r-- 1 oracle dba 24372 Aug 29 15:55 mis.log

----------------------------------------------------------------

Please look at this matter, and suggest me what to do.

Thanks & Regards,
Sam G
Re: DB Export problem [message #263406 is a reply to message #262805] Wed, 29 August 2007 23:58 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You should know how you can extend the file limit size of Operating System or as least ask your UNIX administrator to do that.

If you don't know then fragment your export file by 1000M by filesize parameter.

Like,

exp file=1.dmp,2.dmp,3.dmp filesize=1000M
Previous Topic: SQL Loader
Next Topic: Using 9i Export whole db while excluding couple of tables
Goto Forum:
  


Current Time: Wed Dec 25 10:08:44 CST 2024