OraFAQ Forum: Forms » backup from oracle form

Home » Developer & Programmer » Forms » backup from oracle form

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

backup from oracle form [message #332021]

Mon, 07 July 2008 04:57

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'));

Report message to a moderator

Re: backup from oracle form [message #332037 is a reply to message #332021]

Mon, 07 July 2008 05:29

dude4084
Messages: 222
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);

Report message to a moderator

Re: backup from oracle form [message #332046 is a reply to message #332021]

Mon, 07 July 2008 05:58

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 .....

Report message to a moderator

Re: backup from oracle form [message #332084 is a reply to message #332046]

Mon, 07 July 2008 08:32

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

ziauldba wrote on Mon, 07 July 2008 15:58

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.

Report message to a moderator

Re: backup from oracle form [message #332144 is a reply to message #332021]

Mon, 07 July 2008 11:02

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: backup from oracle form [message #332148 is a reply to message #332144]

Mon, 07 July 2008 11:42

dude4084
Messages: 222
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

Report message to a moderator

Re: backup from oracle form [message #332176 is a reply to message #332148]

Mon, 07 July 2008 14:37

Littlefoot
Messages: 21823
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.

Report message to a moderator