OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » back up

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

back up [message #181434]

Mon, 10 July 2006 02:27

shishirnaik55
Messages: 2
Registered: July 2006
Location: india

Junior Member

hi
i am facing one problem ,
That i have taken backup through ftp
in ascii mode i got the dmp file . (by mistake i kept it ascii rather than binary) now i have to restore that backup but it gives error imp 00010 . can any body help me out of this problem
or can that file be converted into binar mode again[/ALIGN]please help me

Report message to a moderator

Re: back up [message #181444 is a reply to message #181434]

Mon, 10 July 2006 03:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, you'd better get binary copy of the same file. ASCII one won't help much here and can not be converted into a binary file.

Although, if I remember well, some really, really small .dmp files (for example, export of the Scott's EMP table) could have been imported although FTPed as ASCII files. But, again, maybe I don't remember that well.

Report message to a moderator

Re: back up [message #181483 is a reply to message #181444]

Mon, 10 July 2006 05:30

shishirnaik55
Messages: 2
Registered: July 2006
Location: india

Junior Member

sir ,
actually the problem is ,i have the only back up with ascii mode and the server is crashed with two hdd fulty so i have to restore with that only and other backups are old ( two months back )

i am in a very critical stage
pls help me out sir

Report message to a moderator

Re: back up [message #181494 is a reply to message #181483]

Mon, 10 July 2006 05:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm terribly sorry, but I really wouldn't know how to do that; so, you have ASCII .dmp file which is unusable, and a valid backup which is 2 months old. The best you can do is to restore your database with backup you have ...

I believe this situation will, in the future, make you think of someone's signature which says "Did you hug your backup today?".

Report message to a moderator

Previous Topic:	data export problem
Next Topic:	How to can back up some table to dump file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 04:20:01 CST 2024