OraFAQ Forum: Forms » Error message after the backup process is complete

Home » Developer & Programmer » Forms » Error message after the backup process is complete

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

Error message after the backup process is complete [message #683264]

Mon, 21 December 2020 08:46

alhakimy
Messages: 56
Registered: December 2016

Member

I use dump for backup and recovery
Backup is done well But
When the process is completed I see this message

I'm suffering problem that I am making the backup copy from the client not from the server

And when I make a backup, I have to go to the server and click on this message to close it and return to my office

I use this code

declare
begin
host ('cmd.exe /c expdp scott/tiger DIRECTORY=alhakimy_expdp DUMPFILE='||:TEXT_ITEM7||'.dmp LOGFILE='||:TEXT_ITEM7||'.log SCHEMAS=alhakimy');
end;

Attachment: exp.jpg
(Size: 67.85KB, Downloaded 1720 times)

[Updated on: Mon, 21 December 2020 08:52]

Report message to a moderator

Re: Error message after the backup process is complete [message #683266 is a reply to message #683264]

Mon, 21 December 2020 09:53

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

Senior Member
Account Moderator

You cannot use a 10.1 data pump client (expdp) against a 11.2 data pump server.

Note that you have NOT a database backup.
Data Pump is NOT a database backup tool.

The first line of your client version documentation states:
Quote:

Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another.

Nowhere in the Data Pump part of this documentation the word "backup" (or "restore") is mentioned.

[Updated on: Mon, 21 December 2020 09:59]

Report message to a moderator

Re: Error message after the backup process is complete [message #683269 is a reply to message #683266]

Mon, 21 December 2020 10:47

alhakimy
Messages: 56
Registered: December 2016

Member

But it makes name.dmp files

Report message to a moderator

Re: Error message after the backup process is complete [message #683270 is a reply to message #683269]

Mon, 21 December 2020 11:27

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

Senior Member
Account Moderator

I don't know what your "but" refers to but ( Smile

) file name could "something.whatever", Oracle does not care about it.
".dmp" is the default extension for an export dump file whatever is the export tool: exp or expdp, which does not mean they have the same format and indeed they have not.

Report message to a moderator

Re: Error message after the backup process is complete [message #683271 is a reply to message #683270]

Mon, 21 December 2020 11:49

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

Senior Member
Account Moderator

Quote:

You cannot use a 10.1 data pump client (expdp) against a 11.2 data pump server.

My bad, it is the opposite, you cannot use a 11.2 client to export a 10g db.

So your problem has nothing to do with Data Pump but with the interface you use to launch expdp.
Which one is it?

Report message to a moderator

Re: Error message after the backup process is complete [message #683272 is a reply to message #683271]

Tue, 22 December 2020 00:00

alhakimy
Messages: 56
Registered: December 2016

Member

i use database 11g and dev 10g

Report message to a moderator

Re: Error message after the backup process is complete [message #683273 is a reply to message #683272]

Tue, 22 December 2020 00:23

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

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 21 December 2020 18:49

...
So your problem has nothing to do with Data Pump but with the interface you use to launch expdp.
Which one is it?

Quote:

i use database 11g and dev 10g

If this is just a copy of your prod database into the dev one, why don't you just make the export from the DOS prompt?
It is a bad idea to have a direct link between prod and dev, for security and confidentiality reasons;
then it is not a good idea to make export from a dev client.
It is a bad idea to have dev and prod not in the same major release as the behavior of Oracle changes.

Report message to a moderator

Re: Error message after the backup process is complete [message #683274 is a reply to message #683273]

Tue, 22 December 2020 01:14

alhakimy
Messages: 56
Registered: December 2016

Member

I have an external server (vps)
It has all product
And from the clients I have this shortcut (http://xxx.170.223.151:8889/forms/frmservlet?config=km)

[Updated on: Tue, 22 December 2020 01:15]

Report message to a moderator

Re: Error message after the backup process is complete [message #683275 is a reply to message #683274]

Tue, 22 December 2020 02:38

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

Senior Member
Account Moderator

So, if you have the wanted dump As you said but nothing in your posts shows it, the problem is with Forms and its interface with Windows/DOS commands not with Data Pump.
I move the topic to Forms forum.

[Updated on: Tue, 22 December 2020 02:40]

Report message to a moderator

Previous Topic:	when list changed
Next Topic:	compare value with recod group query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 21:35:36 CST 2025