Home » Developer & Programmer » Forms » Error message after the backup process is complete
Error message after the backup process is complete [message #683264] Mon, 21 December 2020 08:46 Go to next message
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 103 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 Go to previous messageGo to next message
Michel Cadot
Messages: 67817
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
But it makes name.dmp files
Re: Error message after the backup process is complete [message #683270 is a reply to message #683269] Mon, 21 December 2020 11:27 Go to previous messageGo to next message
Michel Cadot
Messages: 67817
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Error message after the backup process is complete [message #683271 is a reply to message #683270] Mon, 21 December 2020 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 67817
Registered: March 2007
Location: Nanterre, France, http://...
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?

Re: Error message after the backup process is complete [message #683272 is a reply to message #683271] Tue, 22 December 2020 00:00 Go to previous messageGo to next message
alhakimy
Messages: 56
Registered: December 2016
Member
i use database 11g and dev 10g
Re: Error message after the backup process is complete [message #683273 is a reply to message #683272] Tue, 22 December 2020 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 67817
Registered: March 2007
Location: Nanterre, France, http://...
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.
Re: Error message after the backup process is complete [message #683274 is a reply to message #683273] Tue, 22 December 2020 01:14 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 67817
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Apr 22 16:09:13 CDT 2021