OraFAQ Forum: Enterprise Manager » Job error

Home » RDBMS Server » Enterprise Manager » Job error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Job error [message #246292]

Wed, 20 June 2007 09:31

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

i tried to create a job in oracle management console to export a database every 30mins but got this error when the job was run

EXP-00028: failed to open H:\probackups\pro.dmp for write
Export file: EXPDAT.DMP >
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully

Report message to a moderator

Re: Job error [message #246310 is a reply to message #246292]

Wed, 20 June 2007 10:22

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Do you have enough space??

Quote:

EXP-00028: failed to open string for write
Cause: Export failed to open the export file for writing. This message is usually followed by device messages from the operating system.
Action: Take appropriate action to restore the device.

Report message to a moderator

Re: Job error [message #246319 is a reply to message #246292]

Wed, 20 June 2007 10:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

to export a database every 30mins

Why do you want to do this?
Did you never ear about archivelog mode and recovery?

Regards
Michel

Report message to a moderator

Re: Job error [message #246323 is a reply to message #246319]

Wed, 20 June 2007 11:07

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

its a test because the archive log mode is shutdown so this is being done as a fail safe it will be restored soon but this is being used right now, also there is enough space on the hard drive for the export it is a very small database

Report message to a moderator

Re: Job error [message #246324 is a reply to message #246292]

Wed, 20 June 2007 11:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Does the (oracle?) user have write permission to this folder?
When was the last time this worked?

Report message to a moderator

Re: Job error [message #246326 is a reply to message #246323]

Wed, 20 June 2007 11:20

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It takes 30 seconds to activate archivelog mode.
Much less than this topic lifetime.

Regards
Michel

Report message to a moderator

Re: Job error [message #246327 is a reply to message #246324]

Wed, 20 June 2007 11:21

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

actually it has never worked i was trying it just to make sure the system was backed up, this being a test and all i wasnt sure if the database might crash

Report message to a moderator

Re: Job error [message #246331 is a reply to message #246326]

Wed, 20 June 2007 11:32

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

ok we have a standby database but this particular database is not supported on it as yet and i wont be on there for a bit so in the mean time i am trying to find an alternate way to keep it "kinda" backed up until we decide to put it onto the standby database server

Report message to a moderator

Re: Job error [message #246334 is a reply to message #246331]

Wed, 20 June 2007 11:39

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you check from command prompt weather that works or not??

Report message to a moderator

Re: Job error [message #246336 is a reply to message #246331]

Wed, 20 June 2007 11:41

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Given that you can export in less than 30 minutes, I'll take less than 30 minutes to switch to archivelog mode, take a hot backup and no more care about crash.
Just backup from time to time the archived logs (once a day?).

Regards
Michel

Report message to a moderator

Re: Job error [message #246367 is a reply to message #246336]

Wed, 20 June 2007 13:42

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

ok i will try ur suggestion but can u give any reason why the export did not work with the oracle enterprise manager because i would also like to be able to do this export once a day for other purposes.

Ur idea makes much more sense but i am working under other instructions if u know what i mean.

Report message to a moderator

Re: Job error [message #246373 is a reply to message #246367]

Wed, 20 June 2007 14:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't use OEM, I can't answer you.
If you want we can transfer this thread to EM forum.

Regards
Michel

Report message to a moderator

Re: Job error [message #246377 is a reply to message #246292]

Wed, 20 June 2007 14:19

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

thanks can u do thaat for me i am kinda new in the position took over after a resignations o i am trying to feel my way into some things right now

Report message to a moderator

Re: Job error [message #246725 is a reply to message #246292]

Thu, 21 June 2007 12:48

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

can anybody offer help i am trying to schedule and export using the system console and it is working find posted the error at the top of the post

Report message to a moderator

Re: Job error [message #247095 is a reply to message #246292]

Sat, 23 June 2007 23:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

It usually makes no sense that you will take export of the whole database in every 30 minutes. Take the backup after every 1 days. What I think is that the time you need to take export is more than 30 minutes. As a result the scheduler tries to take the dump in same place again but it is busy with previous backup process.So error comes.

It also may be the case that in your file there is no permission of the user by whom u are making export.

N.B: I am new and my suggestion may be wrong.

Report message to a moderator

Previous Topic:	Oracle Schema Manager
Next Topic:	Problem in configuring OMS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:01:19 CST 2024