Home » Developer & Programmer » Forms » backup from oracle form
icon6.gif  backup from oracle form [message #332021] Mon, 07 July 2008 04:57 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Drear friends,
How can i backup(Export), my oracle-8.1.7i database by D2K,

i try to this process but it is not working.........




host('exp test/testpass@hrd BUFFER=100000 FULL=Y GRANTS=y ROWS=Y COMPRESS=Y FILE=F:\backup\b'||to_char(sysdate,'ddmmrr'));

Re: backup from oracle form [message #332037 is a reply to message #332021] Mon, 07 July 2008 05:29 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
A part of my one of the form used for export purpose is as follow

Kindly read it and get guidence from it. ( i think you will able to recognize variables and input fields)

Good luck!


Quote:
the_username:= GET_APPLICATION_PROPERTY(USERNAME);
the_password:= GET_APPLICATION_PROPERTY(PASSWORD);
the_connect:= GET_APPLICATION_PROPERTY(CONNECT_STRING);


the_command := 'exp '
||the_username
|| '/'|| the_password
|| '@'|| the_connect
|| ' file='|| :drive ||'\' ||:path || '\' ||:filename || '.dmp owner='|| the_username;



Message('Exporting...', NO_ACKNOWLEDGE);
Synchronize;
Host( the_command, no_screen);


Re: backup from oracle form [message #332046 is a reply to message #332021] Mon, 07 July 2008 05:58 Go to previous messageGo to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Thanks..a lot..


but i need to export data without given value at every time ,like drive name ,path etc

because my backup location is fixed.filename may change by the sysdate.
pls give me help as my requirement .....
Re: backup from oracle form [message #332084 is a reply to message #332046] Mon, 07 July 2008 08:32 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
ziauldba wrote on Mon, 07 July 2008 15:58
Thanks..a lot..


but i need to export data without given value at every time ,like drive name ,path etc

because my backup location is fixed.filename may change by the sysdate.
pls give me help as my requirement .....



Then fix the drive and path. And then set the filename with the help of sysdate.
Whats is difficulty in it?

You try it and report the problems you face.


Re: backup from oracle form [message #332144 is a reply to message #332021] Mon, 07 July 2008 11:02 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know whether you have succeeded to fix the error or not, but - as an option - you might take a look at message #271266 in this topic which will show you how to add date to export file. It is a DOS batch script which can be run using the HOST built-in.

By the way, export is NOT a backup.
Re: backup from oracle form [message #332148 is a reply to message #332144] Mon, 07 July 2008 11:42 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Dear Littlefoot

There is one discrepancy which i feel in the referenced message.i.e the password of the user has to be provided all the time.

By the way what is method of backup?
Kindly give reference of some good article about it.

Regards

-Dude

Re: backup from oracle form [message #332176 is a reply to message #332148] Mon, 07 July 2008 14:37 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Backup and Recovery guides can be found in the Oracle documentation; there are several books available on the page the previous link points to.

There are two kinds of a backup: physical, which saves physical files (datafiles, redo log files, control files) and logical, which is (yes, it is!) a file created by Oracle's Export utility.

However, as the Guide suggests,
Quote:
Physical backups are the foundation of any sound backup and recovery strategy. Logical backups are a useful supplement to physical backups in many circumstances but are not sufficient protection against data loss without physical backups.


Export and import utilities are great for moving data between databases, but one should really rely on a physical backup, not export.
Re: backup from oracle form [message #332385 is a reply to message #332176] Tue, 08 July 2008 07:27 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Littlefoot wrote on Tue, 08 July 2008 00:37
Backup and Recovery guides can be found in the Oracle documentation; there are several books available on the page the previous link points to.

There are two kinds of a backup: physical, which saves physical files (datafiles, redo log files, control files) and logical, which is (yes, it is!) a file created by Oracle's Export utility.

However, as the Guide suggests,
Quote:
Physical backups are the foundation of any sound backup and recovery strategy. Logical backups are a useful supplement to physical backups in many circumstances but are not sufficient protection against data loss without physical backups.


Export and import utilities are great for moving data between databases, but one should really rely on a physical backup, not export.


Thanks
-Dude
Re: backup from oracle form [message #332702 is a reply to message #332385] Wed, 09 July 2008 07:05 Go to previous message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

maybe this will help http://www.orafaq.com/forum/m/317938/84678/#msg_317938
Previous Topic: Cursor
Next Topic: how to store variable in a session in forms 6i
Goto Forum:
  


Current Time: Fri Dec 02 12:11:26 CST 2016

Total time taken to generate the page: 0.09960 seconds