Home » RDBMS Server » Backup & Recovery » Use form to database backup
Use form to database backup [message #228389] Mon, 02 April 2007 19:57 Go to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
sir,
i have developed a software,recently it will use a company,
my problem is databackup,End of a day this company need data backup for their
security,they use this process
at first they log

in dos mood then (c:\oracle\bin>

then write this code

exp user/password@databasename file=c:/imu.dmp ;

i think it is not easy process,i want to back up touse interface(form),
a form contain a text box and a button, a user type the textbox the dmp file name
and click the button that time a dmp file will creat a specific location.

please help me any body with example
Re: Use form to database backup [message #228424 is a reply to message #228389] Tue, 03 April 2007 00:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What OS name & version on both server & client?
What verion Oracle DB to 4 decimal places?
What version Forms?
Admirable goal, but poor/unrealistic implementation plan.
Re: Use form to database backup [message #228427 is a reply to message #228389] Tue, 03 April 2007 00:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
data backup for their
security,they use this process


Then you know first EXP / IMP is not BACKUP METHOD.
It is just DATA MOVING TOOLS.

Plan your proper backup method.
with help of below link.
http://www.oracle.com/pls/db10g/portal.portal_demo3?selected=3#index-BAC


Regards
Taj
Re: Use form to database backup [message #228663 is a reply to message #228424] Tue, 03 April 2007 10:18 Go to previous messageGo to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
Hi
thanks for your reply,
Serve op windows 2000,and clients are Windows xp,
Oracle9i,Developer6i,
Please you will suggest me or
please tell me what is the easy way to back up data base.
Re: Use form to database backup [message #228664 is a reply to message #228663] Tue, 03 April 2007 10:24 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Data Security Depand on Recovery and Recovery depand on Backup.
You should look below link

and plan your proper backup.
http://www.oracle.com/pls/db10g/portal.portal_demo3?selected=3#index-BAC
Backup depand on Database Type
1.Database Running in ARCHIVE LOG MODE / NO ARCHIVE LOG MODE
2.How much you have Downtime.
3.Which Backup you want to use.
1.RMAN
2.User Managed Backup


Regards
Taj
Previous Topic: cloning file needs more recovery to be consistent
Next Topic: Build New DB from RMAN
Goto Forum:
  


Current Time: Mon May 13 19:30:29 CDT 2024